PHP - Using __construct & __destruct

This line of PHP
mysqli::__construct($CFG->dbhost, $CFG->dbuser, $CFG->dbpass, $CFG->dbname);

returns
Quote

Fatal error: Non-static method mysqli::mysqli() cannot be called statically in


Why does it do this?

I want to use the OOP MySQLi methods in PHP and NO procedural PHP

Hi, I'm fairly new to OOP so please bare with me.
 
I've been given to understand __construct is put forth in order to do that as soon as the object is created.

Now I've created an object to control sessions. so here is my construct code includes a function within that object and session_start().

However, I get the error that the function within that object is non-existent but the function is right underneath the __construct function. should I put __construct last thing in my object? ANy help on this issue would be excellent!


Thank you.

Hi! I'm new here 

I'm following an online course where we building CMS using OOP PHP and PDO. I read some articles and watched a few youtube tutorials and to be honest, I'm pretty confused. Some of the developers suggest using function __construct(PDO $connection) inside the class.

Their code looks something like that:

  private PDO $connection;
  function __construct(PDO $connection) {
    $this->connection = $connection;

connect.php

class dbh{
    
        private $host = "localhost";
        private $user = "root";
        private $pwd = "";
        private $dbname = "cms";

        protected function connect() {
            $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname;
            $pdo = new PDO ($dsn, $this->user, $this->pwd);
            $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
            return $pdo;

    }
}

function.php // not a whole code
 

class CategoriesData extends dbh{

    public function getAllCategories() {

			$sql = "SELECT * FROM categories_tbl";
			$stmt = $this->connect()->query($sql);
				while ($row = $stmt->fetch()){
				
				echo $row['category_name'] . '<br>';

		}
    }

 	public function getCategoryName() {

			$sql = "SELECT category_name FROM categories_tbl";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute();
			$category = $stmt->fetch(PDO::FETCH_OBJ);
			
			if($category == null) {

				return null;
			}else {

				return $category->category_name;
			}
    } 

	public function getCategoryDetials() {

			$sql = "SELECT * FROM categories_tbl";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute();
			$result = $stmt->fetchAll((PDO::FETCH_OBJ));
			
			return $result;
    }   
		
    public function addCategory ($filter_name, $filter_title, $filter_description, $filter_slug) {

			$sql = "INSERT INTO categories_tbl (category_name, category_title, category_description, category_slug) VALUES (?, ?, ?, ?)";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute([$filter_name, $filter_title, $filter_description, $filter_slug]);
 
		}

	public function deleteCategory($delete_category_id) {
			$sql =  "DELETE FROM categories_tbl WHERE category_id = ?";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute([$delete_category_id]);
    }
    }
       }
   

 

Hello, I'm in need of help. Sometimes my PHP reads XML from a ssh and it tends to fail at times.

Heres my complete error:

Code: [Select]
[04-Aug-2010 18:03:16] PHP Warning:  SimpleXMLElement::__construct() [<a href='simplexmlelement.--construct'>simplexmlelement.--construct</a>]: Entity: line 3: parser error : Premature end of data in tag info line 2 in /home/nmdgamin/public_html/private/includes/functions/revision.php on line 69
[04-Aug-2010 18:03:16] PHP Warning:  SimpleXMLElement::__construct() [<a href='simplexmlelement.--construct'>simplexmlelement.--construct</a>]:  in /home/nmdgamin/public_html/private/includes/functions/revision.php on line 69
[04-Aug-2010 18:03:16] PHP Warning:  SimpleXMLElement::__construct() [<a href='simplexmlelement.--construct'>simplexmlelement.--construct</a>]: ^ in /home/nmdgamin/public_html/private/includes/functions/revision.php on line 69
[04-Aug-2010 18:03:16] PHP Fatal error:  Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/nmdgamin/public_html/private/includes/functions/revision.php:69
Stack trace:
#0 /home/nmdgamin/public_html/private/includes/functions/revision.php(69): SimpleXMLElement->__construct('<?xml version="...')
#1 /home/nmdgamin/public_html/private/includes/functions/update.php(16): CheckRemoteRevision('SpaceBuild')
#2 /home/nmdgamin/public_html/prv_updater.php(13): Update()
#3 {main}
  thrown in /home/nmdgamin/public_html/private/includes/functions/revision.php on line 69

Remote function:

function CheckRemoteRevision($Name){
    if($Name){
        if($Query = MySQLQuery('SELECT name, url, sv_revision FROM data WHERE name=\''. $Name .'\';')){
            if($XMLFile = shell_exec('svn info \''. $Query['url'] .'\' --username anonsvn --password anonsvn --xml')){
                if($DCheck = explode(' ', $XMLFile)){
                    if($DCheck[0] == 'svn:'){
                        $Revision = '0';
                        $Result = MySQLQuery('UPDATE data SET sv_revision=\''. $Revision .'\' WHERE name=\''. $Query['name'] .'\';');
                        return False;
                    }
                }
                $XML = new SimpleXMLElement($XMLFile);
                foreach($XML->entry as $Attribute){
                    $Revision = $Attribute['revision']; 
                }
                if($Query['sv_revision'] < $Revision || $Query["sv_revision"] != $Revision){
                    $Result = MySQLQuery('UPDATE data SET sv_revision=\''. $Revision .'\' WHERE name=\''. $Query['name'] .'\';');
                }
                return $Revision;
            }else{
                return False;
            }
        }else{
            return False;
        }
    }else{
        return False;
    }
}

How would I full proof this from getting this error again, It seems to happen at completely random times.

I'm not very good with XML in PHP

Thanks!

Hi all

If there a better way of setting variables within classes than taking it through the __construct and setting via $this ??

e.g.

class SectionsConnect {
protected $var;
public function __construct($var){ 
$this->var= $var;
        }
}

Can you not set the variable automatically as it comes in through the __construct?

Thanks Magnetica