Archief - PHP: classes en OOP

<?php
/**
* Database class.
*
* @package core
* @subpackage database
* @version 0.1.0
*/

class Database {
    /////////////////////////////////////////////
    // CLASS VARIABLES
    /////////////////////////////////////////////

    var $hostname;
    var $username;
    var $password;
    var $database;

    /////////////////////////////////////////////
    // CLASS FUNCTIONS
    /////////////////////////////////////////////

    function database($hostname, $username, $password, $database) {
        $this->setHostname($hostname);
        $this->setUsername($username);
        $this->setPassword($password);
        $this->setDatabase($database);
    }

    function setHostname($hostname) {
        $this->hostname = $hostname;
    }

    function setUsername($username) {
        $this->username = $username;
    }

    function setPassword($password) {
        $this->password = $password;
    }
    
    function setDatabase($database) {
        $this->database = $database;
    }

    function getHostname() {
        return $this->hostname;
    }

    function getUsername() {
        return $this->username;
    }

    function getPassword() {
        return $this->password;
    }

    function getDatabase() {
        return $this->database;
    }
}; // END DATABASE CLASS
?>

<?php
/**
* MySQL database class.
* 
* @package core
* @subpackage database
* @see database.php
* @version 0.1.0
*/

class MySQL extends Database {
    /////////////////////////////////////////////
    // CLASS VARIABLES
    /////////////////////////////////////////////

    var $kernel;            // A pointer to the kernel object.
    var $resource;
    var $connectstatus;
    
    /////////////////////////////////////////////
    // CLASS FUNCTIONS
    /////////////////////////////////////////////

    function mysql($hostname, $username, $password, $database, &$kernel) {
        parent::database($hostname, $username, $password, $database);
        $this->setKernel($kernel);
        $this->setConnectStatus(false);
        $this->connect();
        $this->selectDatabase();
    }

    function getKernel() {
        return $this->kernel;
    }
    
    function setKernel($kernel) {
        $this->kernel = $kernel;
    }

    function getResource() {
        return $this->resource;
    }

    function setResource($resource) {
        $this->resource = $resource;
    }

    function getConnectStatus() {
        return $this->connectstatus;
    }

    function setConnectStatus($connectstatus) {
        $this->connectstatus = $connectstatus;
    }

    function connect() {
        if ($this->getConnectStatus() === false) {
            $succes = mysql_connect(parent::getHostname(), parent::getUsername(), parent::getPassword());
            if ($succes === false) {
                $this->getKernel()->getError()->handleError("An error has occured while trying to connect to the database server.");
            } else {
                $this->setResource($succes);
                $this->setConnectStatus(true);
            }
        }
        // Already connected.
    }

    function disconnect() {
        if ($this->getConnectStatus() === true) {
            $succes = mysql_close($this->getResource());
            if ($succes === false) {
                $this->getKernel()->getError()->handleError("An error has occured while trying to close the connection with the database server.");
            } else {
                $this->setConnectStatus(false);
            }
        }
        // Nothing to close.
    }

    function selectDatabase($database = parent::getDatabase()) {
        if ($this->getConnectStatus() === true) {
            $succes = mysql_select_database($database);
            if ($succes === false) {
                $this->getKernel()->getError()->handleError("An error has occured while selecting the database ".$database.".");
            }
            // Database succesfully selected.
        } else {
            $this->getKernel()->getError()->handleError("Tried to select a database, but without a connection to a database server.");
        }
    }

    function query($querystring) {
        if ($this->getConnectStatus() === true) {
            $succes = mysql_query($querystring);
            if ($succes === false) {
                $this->getKernel()->getError()->handleError("Tried to execute the following query, but failed. >> ".$querystring);
                return false;
            } else {
                return $succes;
            }
        } else {
            $this->getKernel()->getError()->handleError("Tried to execute the following query, but failed: no connection with a database server. >> ".$querystring);
            return false;
        }
    }
}; // END MYSQL CLASS   
?>

$mysql = new MySQL($hostname, $username, $password, $database, $kernel);
$resultresource = $mysql->query("SELECT * FROM table");