Pastable version of Database Class

<pre class='prettyprint' language='php'>class DB {
        /*
        $c=new DB();

*/
	var $properties=array(
			'die_on_errors'=&gt;true,
			'complain_about_errors'=&gt;false
		);
        var $database='web2_db1';
        var $user=/*woops*/;
        var $password=/*woops*/;
        var $connected=false;
        var $connection=&quot;&quot;;
        var $count=-1;
        var $id=-1;
        var $result=false;
        var $error;
        var $results=false;
        var $last_ql;
        function __construct($db='web2_db1') {
                        $this-&gt;database=$db;
			$this-&gt;connect();
        }
	function connect() {
		$this-&gt;connection=mysql_connect('localhost',$this-&gt;user,$this-&gt;password);
		if (!$this-&gt;connection) {
			die(&quot;Cannot connect to the database!&quot;);
		}
		$select=mysql_select_db($this-&gt;database);
		if (!$select) {
			die(&quot;Could not read $deatabase database&quot;);
		}
		$this-&gt;connected=true;
	}
	function __destruct() {
		@mysql_close($this-&gt;connection);
	}
	function SetProperty($property,$value) {
		$this-&gt;properties[$property]=$value;
	}
        function Query($ql,$args=false,$json=false) {
                if ($args)
                        $this-&gt;last_ql=str_replace(array_keys($args),array_values($args),$ql);
                else
                        $this-&gt;last_ql=$ql;
               if (!mysql_ping($this-&gt;connection)) {
                        $this-&gt;connect();
                }

try {
	                $this-&gt;result=mysql_query($this-&gt;last_ql,$this-&gt;connection);
		} catch (Exception $e) {
			$this-&gt;connect();
			return $this-&gt;Query($ql,$args,$json);
		}
                if (!$this-&gt;result) {
                        $this-&gt;error=mysql_error();
			if ($this-&gt;properties['die_on_errors'])
				die(var_dump(array(&quot;error&quot;=&gt;$this-&gt;error,&quot;last_ql&quot;=&gt;$last_ql)));
			if ($this-&gt;properties['complain_about_errors'])
				throw new Exception($this-&gt;error.&quot; IN SQL &quot;.$this-&gt;last_ql);
			
                        return false;
                }
                $this-&gt;results=array();
                $i=0;
                try {
                while ($row=mysql_fetch_assoc($this-&gt;result)) {
                        $this-&gt;results[$i]=array();
                        foreach ($row as $key=&gt;$value) {
                                $this-&gt;results[$i][$key]=$value;
                        }
                        $i++;
                }
                } catch (Exception $e) {
                        var_dump($e);
                        var_dump(debug_backtrace());
                        die(var_dump($this-&gt;result));
                }

return ((!$json)?$this-&gt;results:Utilities::JSENC($this-&gt;results));
        }
        function Command($ql,$args=false,$json=false) {
                if ($args) {
                        $this-&gt;last_ql=str_replace(array_keys($args),array_values($args),$ql);

}else
                        $this-&gt;last_ql=$ql;
		if (!mysql_ping($this-&gt;connection)) {
			$this-&gt;connect();
		}	
                try {
                        $this-&gt;result=mysql_query($this-&gt;last_ql,$this-&gt;connection);
                } catch (Exception $e) {
                        $this-&gt;connect();
                        return $this-&gt;Query($ql,$args,$json);
                }

if (substr($ql,0,2)=='IN'&amp;&amp;$this-&gt;result)
                        $this-&gt;id=mysql_insert_id($this-&gt;connection);
                if (!$this-&gt;result) {
                        $this-&gt;error=mysql_error();
                        $this-&gt;results=false;
                } else {
                        $this-&gt;result=true;
                        $this-&gt;results=true;
                }
                return ((!$json)?$this-&gt;results:Utilities::JSENC($this-&gt;results));
        }

}
}</pre>
<a href="http://www.refactormycode.com/codes/356-database-class" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Database Class