<?php
class DBConfig {

    var $host;
    var $user;
    var $pass;
    var $db;
    var $db_link;
    var $conn = false;
    var $persistant = false;

    public $error = false;

    public function config(){ // class config
        $this->error = true;
        $this->persistant = false;
    }

    function conn($host='localhost',$user='user',$pass='123456',$db='orgp'){ // connection function
        $this->host = $host;
        $this->user = $user;
        $this->pass = $pass;
        $this->db = $db;

        // Establish the connection.
        if ($this->persistant)
            $this->db_link = mysql_pconnect($this->host, $this->user, $this->pass, true);
        else
            $this->db_link = mysql_connect($this->host, $this->user, $this->pass, true);

        if (!$this->db_link) {
            if ($this->error) {
                $this->error($type=1);
            }
            return false;
        }
        else {
        if (empty($db)) {
            if ($this->error) {
                $this->error($type=2);
            }
        }
        else {
            $db = mysql_select_db($this->db, $this->db_link); // select db
            if (!$db) {
                if ($this->error) {
                    $this->error($type=2);
                }
            return false;
            }
            $this -> conn = true;
        }
            return $this->db_link;
        }
    }

    function close() { // close connection
        if ($this -> conn){ // check connection
            if ($this->persistant) {
                $this -> conn = false;
            }
            else {
                mysql_close($this->db_link);
                $this -> conn = false;
            }
        }
        else {
            if ($this->error) {
                return $this->error($type=4);
            }
        }
    }

    public function error($type=''){ //Choose error type
        if (empty($type)) {
            return false;
        }
        else {
            if ($type==1)
                echo "<strong>Database could not connect</strong> ";
            else if ($type==2)
                echo "<strong>mysql error</strong> " . mysql_error();
            else if ($type==3)
                echo "<strong>error </strong>, Proses has been stopped";
            else
                echo "<strong>error </strong>, no connection !!!";
        }
    }
}

// example to use

$DB = new DBConfig();
$DB -> config();
$DB -> conn();
if( isset( $_POST['ajax'] ) ){
  mysql_query('INSERT INTO `notes` (`number`,`date`,`subj`,`status`) values ("'. mysql_real_escape_string($_POST['number']) .'", "'. mysql_real_escape_string($_POST['date']) .'","'. mysql_real_escape_string($_POST['subject']) .'","'. mysql_real_escape_string($_POST['st']) .'");');
}
$DB -> close();
?>