1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114

class DB {
        /*
        $c=new DB();


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

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

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

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

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

}
}