PHP - How To Reuse Data From Sql In A Class.

hello dear community, good day,

 

I've been having an issue trying to parse text in a span cass with DOM. Here is my code example. try to extract some lines out of a webpage - with following technique: with the Extraction of values of attributes of elements with DOMDocument. Here is what i have gathered and learned:

 

$remote = "http://website.com/"; $doc = new DOMDocument(); @$doc->loadHTMLFile($remote); $xpath = new DOMXpath($doc); $node = $xpath->query('//span[@class="user"]'); echo $node;

 

and this returns the following

 

error -> "Catchable fatal error: Object of class DOMNodeList could not be converted to string". 

 

And now - with this i need help.

 

What I am trying to do is parse the user name between this tag;

 

<div class="widget plugin-meta"> <h3 class="screen-reader-text">Meta</h3>

 

see more below:Here the concrete example view-source: https://wordpress.org/plugins/participants-database/ and https://wordpress.org/plugins/participants-database/

 

goal  i need the following data:

 

Version: Last updated: Active installations: Tested up:

 

view-source: https://wordpress.org/plugins/participants-database/

 

Proceedings; i checked the source of the webpage. i tried to find out whether the texte is related to some kind of pattern.i have looked closely and found that all of them have

class=”widget plugin-meta”

. Well - This will make extracting them, a piece of cake. I tried with the code below helps to filter html elements based on values of attributes.

but unfortunatley this ends up in a bad result; i need a helping hand and need to know how to parse the above mentioned data

Again; the goal: i need the following data:

Quote

Version:

Last updated:

Active installations:

Tested up:

 

 

Any idea for the starting-point!?  I love to hear from you.

 

Hello, my first post here.

I created a Validation class that depends entirely on static methods. It appears to be working well, but perhaps I misunderstood exactly the purpose and the consequences of using static methods.

My class essentially looks like this:


class Validate
{
static public $errors  = array();
static public $valid   = array();

static public function Name($name)
{
if ($name != '')
{
self::$valid['name'] = $name;
return true;
}
                                else
                                {
                self::$errors['name'] = 'Name is empty';
                return false;
                                 }
}
}


Does this create any chance whatsoever for a collision of data from multiple users? I am beginning to think it does, simply because from what I have recently learned about static methods, theyr'e essentially global variables because they are not instantiated. If that's the case, then it would seem possible that during times of heavy use, any application depending on this class would confuse submitted data.

Any thoughts?

Thanks in advance.

Hi...

I have query in highlighting null data using this code:

Code: [Select]
<?php

include 'config.php';

$currentEmpID = $_SESSION['empID']; 
 
 if(!isset($_POST['Regsubmit_'])){ 
     
    $DATE1 = $_GET['Regfirstinput'];
    $DATE2   = $_GET['Regsecondinput'];
 
 $sql = "SELECT DISTINCT IF(ISNULL(a.LOG_IN), 'rdc', '') AS LOGIN_CLASS, IF(ISNULL(a.LOG_OUT), 'rdc', '') AS LOGOUT_CLASS, a.EMP_ID, CONCAT(LASTNAME, ', ' , FIRSTNAME) AS FULLNAME, a.LOG_IN, a.LOG_OUT
 FROM $ATTENDANCE.attendance_build AS a JOIN $ADODB_DB.employment em ON (a.EMP_ID = em.EMP_NO AND em.STATUS IN ('Reg Operatives', 'Reg Staff')) 
 WHERE LOG_IN BETWEEN '$DATE1' AND '$DATE2' 
 OR ISNULL(LOG_IN) OR ISNULL(LOG_OUT)";
 
    $DTR = $conn3->GetAll($sql);
    $smarty->assign('attendance', $DTR);
 }
 $smarty->display('header_att.tpl');
 $smarty->display('RegAttendance.tpl');
 $smarty->display('footer.tpl');
?>

and here is the tpl code:

Code: [Select]
{section name=att loop=$attendance}
  <tr>
    <td colspan="2">{$attendance[att].EMP_ID}</td>
    <td colspan="2">{$attendance[att].FULLNAME}</td> 
    <td colspan="2" class="{$attendance[att].LOGIN_CLASS}">{$attendance[att].LOG_IN|date_format:"%d-%m-%Y %I:%M %p"}</td>
    <td colspan="2" class="{$attendance[att].LOGOUT_CLASS}">{$attendance[att].LOG_OUT|date_format:"%d-%m-%Y %I:%M %p"}</td>
  </tr>
{sectionelse}
  <tr><td colspan="1">No DATA</td></tr>
{/section}

this code highlight the null value of login or logout or both.

this is the css:
Code: [Select]
.rdc {background-color:#ff0000;}

Now, I need to revised my query statement, because i have separate code for adding attendance if the employee has no attendance or no login or no logout.

I just want to happen is if the employee is already add his attendance in NRS table or should I said if the LOG_IN in attendance table is equal to TIME_IN in NRS table the data will have a color yellow.

For Example:

I have this data in attendance table:

EMP_ID = 012012
LOG_IN = NULL
LOG_OUT = 2011-12-12 13:35:00

I will his attendance in NRS table to have his attendance:

EMP_NO = 012012
TIME_IN = 2011-12-12 05:35:00
TIME_OUT = 2011-12-12 13:35:00



In my above query the LOG_IN has a background color of RED.

I want to happen is if I add his attendance in NRS the EMP_NO, LOG_IN, LOGOUT will have a color to notice that it is already have in NRS.

Because theirs a scenario that the employee has no login or no logout or both.


Feel free to ask me if my explanation is not clear to you.

Thank you in advance

I need to set up a threaded comments system in a PHP project and I got this script shown below from http://www.jongales....#comment-436261

class Threaded_comments
{
    
    public $parents  = array();
    public $children = array();

    /**
     * @param array $comments 
     */
    function __construct($comments)
    {
        foreach ($comments as $comment)
        {
            if ($comment['parent_id'] === NULL)
            {
                $this->parents[$comment['id']][] = $comment;
            }
            else
            {
                $this->children[$comment['parent_id']][] = $comment;
            }
        }        
    }
   
    /**
     * @param array $comment
     * @param int $depth 
     */
    private function format_comment($comment, $depth)
    {   
        for ($depth; $depth > 0; $depth--)
        {
            echo "\t";
        }
        
        echo $comment['text'];
        echo "\n";
    }
    
    /**
     * @param array $comment
     * @param int $depth 
     */ 
    private function print_parent($comment, $depth = 0)
    {   
        foreach ($comment as $c)
        {
            $this->format_comment($c, $depth);

            if (isset($this->children[$c['id']]))
            {
                $this->print_parent($this->children[$c['id']], $depth + 1);
            }
        }
    }

    public function print_comments()
    {
        foreach ($this->parents as $c)
        {
            $this->print_parent($c);
        }
    }
  
}

Here’s the example usage with the data provided as an array:

$comments = array(  array('id'=>1, 'parent_id'=>NULL,   'text'=>'Parent'),
                    array('id'=>2, 'parent_id'=>1,      'text'=>'Child'),
                    array('id'=>3, 'parent_id'=>2,      'text'=>'Child Third level'),
                    array('id'=>4, 'parent_id'=>NULL,   'text'=>'Second Parent'),
                    array('id'=>5, 'parent_id'=>4,   'text'=>'Second Child')
                );

$threaded_comments = new Threaded_comments($comments);

$threaded_comments->print_comments();

I have a sample select query that pulls data from a database and stores the result in the $comments array as shown below. The $comments array is then passed as an argument to the $threaded_comments object:

$sql = 'SELECT * FROM test_comments';
// submit the query and capture the result
$result = $conn->query($sql);
$comments = array();
while ($row = $result->fetch_assoc()) {
    $comments[] = $row;
}

The challenge is that nothing is printed to the screen when I run the script. Inspection of the comments array with the var_dump function is shown below:

array (size=4)
  0 => 
    array (size=3)
      'id' => string '1' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  1 => 
    array (size=3)
      'id' => string '2' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  2 => 
    array (size=3)
      'id' => string '3' (length=1)
      'parent_id' => string '1' (length=1)
      'text' => string 'comment ' (length=8)
  3 => 
    array (size=3)
      'id' => string '4' (length=1)
      'parent_id' => string '3' (length=1)
      'text' => string 'comment ' (length=8)

I was wondering if the array format from my select query is the issue? Could anyone provide a clue as to how to fix this?   Thanks.
Edited by terungwa, 11 January 2015 - 05:07 PM.

I have mysqli object in Database class base:

[color=]database class:[/color]

class Database {
  private $dbLink = null;
  
  public function __construct() {
    if (is_null($this->dbLink)) {
      // load db information  to connect
      $init_array = parse_ini_file("../init.ini.inc", true);
      $this->dbLink = new mysqli($init_array['database']['host'],
                           $init_array['database']['usr'],
                           $init_array['database']['pwd'],
                           $init_array['database']['db']);
  
      if (mysqli_connect_errno()) {
        $this->dbLink = null;
      }
    }
  }

  public function __destruct() {
    $this->dbLink->close();
  }
}


Class derived is Articles where I use object dBLink in base (or parent) class and I can't access to mysqli methods (dbLink member of base class):

Articles class:

require_once ('./includes/db.inc');

class Articles extends Database{
  private $id,
              ....
              ....
             $visible = null;
  
  public function __construct() {
    // Set date as 2009-07-08 07:35:00
    $this->lastUpdDate = date('Y-m-d H:i:s');
    $this->creationDate = date('Y-m-d H:i:s');
  }
  
  // Setter
  ....
  ....

  // Getter
  ....
  ....

  public function getArticlesByPosition($numArticles) {
    if ($result = $this->dbLink->query('SELECT * FROM articles ORDER BY position LIMIT '.$numArticles)) {
      $i = 0;
      while ($ret = $result->fetch_array(MYSQLI_ASSOC)) {
        $arts[$i] = $ret;
      }
      $result->close();
      return $arts;
    }
  }
}


In my front page php I use article class:


include_once('./includes/articles.inc');
$articlesObj = new articles();
$articles = $articlesObj->getArticlesByPosition(1);
var_dump($articles);


[color=]Error that go out is follow[/color]

Notice: Undefined property: Articles::$dbLink in articles.inc  on line 89

Fatal error: Call to a member function query() on a non-object in articles.inc on line 89

If I remove constructor on derived class Articles result don't change 
Please help me

Hi

Can you call Class A's methods or properties from Class B's methods?

Thanks.

If a class has a constructor but also has a static method, if I call the static method does the constructor run so that I can use an output from the constructor in my static method?

--Kenoli

Ok. I know you can pass the object of a class as an argument. Example:


class A {
    function test() {
        echo "This is TEST from class A";
    }
}


class B {
    function __construct( $obj ) {
        $this->a = $obj;
    }

    function test() {
       $this->a->test();
    }

}


Then you could do:

$a = new A();
$b = new B($a);


Ok so that's one way i know of.

I also thought that you could make a method static, and do this: (assuming class A's test is 'static')

class B {
    function test() {
       A::test(); 
   }
}


But that is not working.


I'd like to know all possible ways of accomplishing this. Any hints are appreciated. thanks

I have an existing instance of my class Database, now I want to call that instance in my Session class, how would I go about doing this?

Hi,

I need to be able to call a class based on variables.  E.G.

I would normally do:
Code: [Select]
$action = new pattern1()
but i would like to be able to do it dynamicaly:
Code: [Select]
$patNum = 1;
$action = new pattern.$patNum.()
Im wondering if that's possible?  If so what would the correct syntax be?

Many Thanks.

I have two classes:

## Admin.php

<?php
class Admin
{
public function __construct()
{
include("Config.php");
}

/**
* deletes a client
* @returns true or false
*/
function deleteClient($id)
{
return mysql_query("DELETE FROM usernames WHERE id = '$id'");
}
}
?>


## Projects.php

<?php
class Projects
{
public function __construct()
{
include("Config.php");
$this->admin = $admin;
$this->dataFolder = $dataFolder;
}

/**
* Deletes a project
* @returns true or false
*/
function deleteProject($id)
{
$root  = $_SERVER['DOCUMENT_ROOT'];
$theDir  = $root . $this->dataFolder;
$sql  = mysql_query("SELECT * FROM projectData WHERE proj_id = '$id'");
while ($row = mysql_fetch_array($sql))
{
$mainFile = $row['path'];
$thumb = $row['thumbnail'];
if ($thumb != 'null')
{
unlink($theDir . "/" . substr($thumb,13));
}
unlink($theDir . "/" . substr($mainFile,13));
}
$delete = mysql_query("DELETE FROM projectData WHERE proj_id = '$id'");
$getDir = mysql_query("SELECT proj_path FROM projects WHERE id = '$id'");
$res = mysql_fetch_array($getDir);
rmdir($theDir . "/" . $res['proj_path']);
return mysql_query("DELETE FROM projects WHERE id = '$id'");
}
}
?>


How can I call deleteProject() from within Admin.php?

Hi people!

class FirstOne{

public function FunctionOne($FirstInput){
//do stuff and output value
return $value1;
}

}


Then:-


class SecondOne{

public function FunctionTwo($AnotherInput){
//do stuff and output value
return $value2;
}

}


What I want to know is this, if I want to use FunctionOne() in Class SecondOne do I do it like this:-

(Assume as I have instantiated the first class using $Test = new FirstOne(); )


class SecondOne{

function SecondedFunction(){
global $Test;
return $Test->FunctionOne();
}

public function FunctionTwo($AnotherInput){
//do stuff and output value
return $value2;
}

public function FunctionThree(){

//some code here
$this->Test->SecondedFunction();<--I think as I can omit the $this-> reference
}
}


My point is: Do I have to do it this way or is there way of having this done through __construct() that would negate the need for a third party function?

I have a version working, I just think that it is a little convoluted in the way as I have done it, so I thought I would ask you guys.

Any help/advice is appreciated.

Cheers
Rw

How does one go about using one class inside another?

For example, building a class that does some series of functions, and uses a db abstraction layer class in the process?

I have a class in which I have a function called connection. I am now trying to call this function from another class, but it will not work. It works if I put the code in from the other function rather than calling it but that defeats the purpous.

class locationbox

{
   function location()
   {
   
   
   $databaseconnect = new databaseconnect();
         $databaseconnect -> connection();{

$result = mysql_query("SELECT * FROM locations");

while($row = mysql_fetch_array($result)) // line that now gets the error, mysql_fetch_array() expects parameter 1 to be resource, boolean given //in
  {
  echo "<option>" . $row['location'] . "</option>";
    }
   
}
}}

Hi all,

I have two classes. Registration and Connection.

Inside a registration.php I include my header.php, which then includes my connection.php...

So all the classes should be declared when the page is loaded.

This is my code:


registration.php:

<?php include ('assets/header.php'); ?> 
        
    <?php
        class registration{                    
            public $fields = array("username", "email", "password");
            public $data = array();
            public $table = "users";
            public $dateTime = "";
            public $datePos = 0;
            public $dateEntryName = "date";
            
            function timeStamp(){
                return($this->dateTime = date("Y-m-d H:i:s"));
            }
            
            function insertRow($data, $table){      
                    
                    foreach($this->fields as $key => $value){
                        mysql_query("INSERT INTO graphs ($this->fields)
                        VALUES ('$data[$key]')");
                    }
                    
                    mysql_close($connection->connect);
            }
            
            function validateFields(){
            
                $connection = new connection(); 
                $connection->connect();
                        
                foreach($this->fields as $key => $value){
                    array_push($this->data, $_POST[$this->fields[$key]]);
                }
                $this->dateTime = $this->timeStamp();
                array_unshift($this->data, $this->dateTime);                
                array_unshift($this->fields, $this->dateEntryName);   
                
                foreach($this->data as $value){
                    echo "$value";
                }
                
                $this->insertRow($this->data, $this->table);
            }
        }
        
        $registration = new registration();
        $registration->validateFields();
    ?>

<?php include ('assets/footer.php'); ?>



At this point I cannot find my connection class defined on another included/included page.



                $connection = new connection(); 
                $connection->connect;





config.php (included within header.php)

<?
    class connection{ 
        public $dbname = '**';   
        public $dbHost = '**';
        public $dbUser = '**';
        public $dbPass = '**';
        public $connect;
        
        function connect(){
            $this->connect = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass) or die ('Error connecting to mysql');
            mysql_select_db($this->dbname, $this->connect);
        }
    }
?>



Any ideas how to call it properly?