Snippet of the Day

[RodneyTrot]

<?php

class Database
{
    var $con;
    var $sel;
    var $res;
    var $assoc;
    var $escape;
    var $array;
    var $row;

    function connect()
    {
        $this->con = mysql_connect("localhost", "host", "") or die(mysql_error());
        $this->sel = mysql_select_db("test") or die(mysql_error());
    }

    function close()
    {
        if (isset($this->connect)) {
            mysql_close($this->connect());
            unset($this->connect);
        }
    }

    function query($sql)
    {
        $this->res = mysql_query($sql) or die(mysql_error());
        return $this;
    }

    function fetch($type)
    {
        switch ($type) {
            case 1:
                $this->assoc = mysql_fetch_assoc($this->res);
                return $this;
                break;
            case 2:
                $this->array = mysql_fetch_array($this->res);
                return $this;
                break;
            case 3:
                $this->row = mysql_fetch_row($this->res);
                return $this;
                break;
        }
    }

    function escape($escape)
    {
        $this->escape = mysql_real_escape_string($escape);
        return $this->escape;
    }


    function get($num, $col)
    {
        switch ($num) {
            case 1:
                return ($this->assoc[$col]);
                break;
            case 2:
                return ($this->array[$col]);
                break;
            case 3:
                return ($this->row[$col]);
                break;
        }
    }

}
//initiate the database class
$database = new Database();
//connect to the database
$database->connect();
//run a query
$database->query("SELECT * FROM table");
//runs, chooses the type of query, and what collumn
$database->query()->fetch(1)->get(1,'username');
//close the database
$database->close();
?>