mysqlClass + blogEngine

[psycho54h]

mysqlClass.php

<?php 
    class mysqlClass { 
        // parameters to set 
        private $hostname; // generally 'localhost' 
        private $username; 
        private $password; 
        private $databaseName; 
        public $linkIdentifier; 
        public $activated = false; // connection checker 
         
        // function to set parameters 
        public function __construct() { 
            $this->hostname = 'localhost'; 
            $this->username = 'root'; 
            $this->password = 'password'; 
            $this->databaseName = 'nome_db'; 
        } 
         
        // function to connect to mysql 
        public function connect() { 
            if(!$this->activated) { 
                print("Connected to mysql
"); 
                $this->linkIdentifier = mysql_connect($this->hostname, $this->username, $this->password); 
                mysql_select_db($this->databaseName, $this->linkIdentifier) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = true; 
            } else { 
                print("Not connected to mysql"); 
                return false; 
            } 
        } 
         
        // function to close mysql connection 
        public function close() { 
            if($this->activated) { 
                echo("Connection closed"); 
                mysql_close($this->linkIdentifier) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = false; 
            } else { 
                echo("Connection doesn't close"); 
                return false; 
            } 
        } 
         
        // function to execute a query 
        public function execute($sql) { 
            if($this->activated) { 
                echo("Query executed
"); 
                return mysql_query($sql, $this->linkIdentifier) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = false; 
            } else { 
                echo("Query doesn't execute"); 
                return false; 
            } 
        } 
         
        // function to extract a query 
        public function extract($query) { 
            if($this->activated) { 
                echo("Query extracted
"); 
                return mysql_fetch_object($query) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = false; 
            } else { 
                echo("Query doesn't extracted"); 
                return false; 
            } 
        } 
         
        // function to insert records in a table 
        public function insert($t, $f, $v) { 
            if($this->activated) { 
                echo("Records inserted
"); 
                $sql = "INSERT INTO $t ($f) VALUES ($v)";
                return mysql_query($sql, $this->linkIdentifier) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = false; 
            } else { 
                echo("Records don't insert"); 
                return false; 
            } 
        } 
         
        // function to delete records from table 
        public function delete($f, $t, $w) { 
            if($this->activated) { 
                echo("Records deleted
"); 
                $sql = "DELETE $f FROM $t WHERE $w";
                return mysql_query($sql, $this->linkIdentifier) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = false; 
            } else { 
                echo("Records don't deleted"); 
                return false; 
            } 
        } 
         
        // function to update records from a table 
        public function update($t, $s, $w) { 
            if($this->activated) { 
                echo("Records updated
"); 
                $sql = "UPDATE $t SET $s WHERE $w";
                return mysql_query($sql, $this->linkIdentifier) or die(mysql_error($this->linkIdentifier)); 
                return $this->activated = false; 
            } else { 
                echo("Records don't update"); 
                return false; 
            } 
        } 
    } 
?>

Nel codice c'era e c'è qualche errore... ho rivisto un paio di cose almeno per far girare qualche funzione, ma dovresti riguardarlo per bene...

I settaggi per la connessione al db devi farli all'interno della classe, nella funzione __construct

Per chiamare la classe devi solo scrivere:

<?php 
require_once('__class/blogEngine.php'); 
$data = new blogEngine();

$data->connect();
$data->close(); 
?>

Ovviamente fra connect e close ci vanno le altre funzioni.

Però, intanto se gira questo, dovresti vedere sul broswer l'ouput:
Connected to mysql
Connection closed