1: <?php
2: namespace {
3: /**
4: * MySQL class
5: *
6: * This class should be responsible for all mysql Database activities
7: *
8: * @author Sartaj Singh
9: * @copyright 2007
10: * @version 4.0.0
11: */
12: class MySQL extends \Sphp\kit\DbEngine {
13: public static $dlink;
14: public static $isConnect = false;
15: public $all_query_ok = true;
16: /**
17: * Class Constructor
18: * This returns the MySQL class object
19: * @return MySQL
20: */
21: public function connect($db1 = "", $dhost1 = "", $duser1 = "", $dpass1 = "") {}
22: public function cleanQuery($string) {}
23: public function clearQuery($string) {}
24: public function executeQuery($sql) {}
25: public function executeQueryQuick($sql) {}
26: public function commitRollback() {}
27: public function commit() {}
28: public function rollback() {}
29: public function disableAutoCommit() {}
30: public function enableAutoCommit() {}
31: public function getDatabaseLink() {}
32: public function multiQuery($sql) {}
33: public function prepare($sql) {}
34: public function executeQueryJFX($sql) {}
35: public function executeQueryQuickJFX($sql) {}
36: public function disconnect() {}
37: public function updateSQL($frm, $txttbl, $where) {}
38: public function insertSQL($frm, $txttbl) {}
39: public function searchSQL($frm, $tbllist, $where, $OP) {}
40: public function createDatabase() {}
41: public function createTable($sql) {}
42: public function dropTable($tableName) {}
43: public function isRecordExist($sql) {}
44: public function row_fetch_assoc($result) {}
45: public function last_insert_id() {}
46: public function isCacheExpired($filename, $ttl) {}
47: public function fetchQuery($sql = "", $ttl = 0, $filename = "", $key = "id", $issave = false) {}
48: public function insertCache($filename, $key, $data = array(), $tbls = "", $sql = "") {}
49: public function clearCache($filename) {}
50: public function updateCache($filename, $keymap, $data = array(), $where = "", $tbls = "", $sql = "") {}
51: public function deleteCache($filename, $keymap, $where = "", $tbls = "", $sql = "") {}
52: public function updateCacheSQL($filename, $key, $sql, $priority = 1) {}
53: public function executeUpdateCacheSQL($filename) {}
54: }
55: }