yakka/storage-providers/YakkaMySqlDatabase.php

<?php

class YakkaMySqlDatabase {
        var $connection;

        function YakkaMySqlDatabase() {
        }

        function connect($host, $database, $user, $password) {
                if ($this->connection = @mysql_connect($host, $user, $password, true))
                        mysql_select_db($database, $this->connection);
        }

        function execute($sql) {
                return mysql_query($sql, $this->connection);
        }

        function escapeString($string) {
                return mysql_escape_string($string);
        }

        function queryRecord($sql) {
                $row = null;
                if ($result = $this->execute($sql)) {
                        $row = mysql_fetch_assoc($result);
                        mysql_free_result($result);
                }
                return $row;
        }

        function queryRecordset($sql) {
                $recordset = array();
                if ($result = $this->execute($sql)) {
                        while($row = mysql_fetch_assoc($result))
                                $recordset[] = $row;

                        mysql_free_result($result);
                }
                return $recordset;
        }       
}

?>
1	<?php
2
3	class YakkaMySqlDatabase {
4	var $connection;
5
6	function YakkaMySqlDatabase() {
7	}
8
9	function connect($host, $database, $user, $password) {
10	if ($this->connection = @mysql_connect($host, $user, $password, true))
11	mysql_select_db($database, $this->connection);
12	}
13
14	function execute($sql) {
15	return mysql_query($sql, $this->connection);
16	}
17
18	function escapeString($string) {
19	return mysql_escape_string($string);
20	}
21
22	function queryRecord($sql) {
23	$row = null;
24	if ($result = $this->execute($sql)) {
25	$row = mysql_fetch_assoc($result);
26	mysql_free_result($result);
27	}
28	return $row;
29	}
30
31	function queryRecordset($sql) {
32	$recordset = array();
33	if ($result = $this->execute($sql)) {
34	while($row = mysql_fetch_assoc($result))
35	$recordset[] = $row;
36
37	mysql_free_result($result);
38	}
39	return $recordset;
40	}
41	}
42
43	?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26