mysqlClass + blogEngine

[reb333l]

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 = 'root';
            $this->databaseName = 'root';
        }
        
        // 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 = <<<ENDSQL
                    INSERT INTO $t ($f) VALUES ($v)        
ENDSQL;
                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 insert($f, $t, $w) {
            if($this->activated) {
                echo('Records deleted
');
                $sql = <<<ENDSQL
                    DELETE $f FROM $t WHERE $w        
ENDSQL;
                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 insert($t, $s, $w) {
            if($this->activated) {
                echo('Records updated
');
                $sql = <<<ENDSQL
                    UPDATE $t SET $s WHERE $w    
ENDSQL;
                return mysql_query($sql, $this->linkIdentifier) or die(mysql_error($this->linkIdentifier));
                return $this->activated = false;
            } else {
                echo('Records don\'t update');
                return false;
            }
        }
    }
?>

blogEngine.php

<?php
    require_once('mysqlClass.php');
    class blogEngine extends mysqlClass {
        // function to set parameters
        public function __construct() {
            parent::__construct();
        }
    }
?>

Non capisco perché non funziona, mi potete aiutare?

[psycho54h]

Già così, è palese la mancanza di backslash (\) prima degli apici...

echo('Connection doesn't close'); ----> echo('Connection doesn\'t close');

altrimenti:

echo("Connection doesn't close");

[reb333l]

in realtà quelli ci sono è html.it che nn li mostra

[psycho54h]

Ah ecco.

Beh, qual è la riga che da errore? Almeno evitiamo di perdere tempo...

[reb333l]

è questo il problema dreamweaver non da errori, semplicemente non funziona e non capisco il perché

[psycho54h]

Sì ma non funziona in che senso? Incolla il codice in php in cui richiami le funzioni.

Qui si costruisce solo una classe, ma come la fai girare? Questo voglio sapere.

[reb333l]

<?php
require_once('__class/blogEngine.php');
$data = new blogEngine('localhost', 'root', 'root', 'blog');
$data->connect();
$data->close();
?>

non visualizza nessun messaggio mi sai dire perchè?

[Samleo]

Nemmeno se metti un error_reporting(E_ALL) all'inizio della pagina?

[reb333l]

no niente di niente

[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