File:
0.00.0a/base/nats.db.inc.php (
View as Code)
1: 2:
3: function ss($s) // safestring
4: {
5: return mysql_escape_string($s);
6: }
7:
8: class TNATS_DB
9: {
10: var $connected=false;
11: var $sql=0;
12:
13: function Connect()
14: {
15: global $fnCfg;
16: $this->sql=mysql_connect($fnCfg['db.server'],$fnCfg['db.username'],$fnCfg['db.password'])
17: or die("Cannot connect to MySQL server");
18: mysql_select_db($fnCfg['db.database'])
19: or die("Cannot select MySQL database");
20: $this->connected=true;
21: return $this->sql;
22: }
23:
24: function Disconnect()
25: {
26: mysql_close($this->sql);
27: $this->sql=0;
28: $this->connected=false;
29: }
30:
31: function Query($query)
32: {
33: if (!$this->connected) return -1;
34: return mysql_query($query,$this->sql);
35: }
36:
37: function Free($result)
38: {
39: mysql_free_result($result);
40: }
41:
42: function Fetch_Array($result)
43: {
44: return mysql_fetch_array($result);
45: }
46:
47: function Affected_Rows()
48: {
49: return mysql_affected_rows();
50: }
51:
52: function Insert_Id()
53: {
54: return mysql_insert_id();
55: }
56:
57: function Num_Rows($result)
58: {
59: return mysql_num_rows($result);
60: }
61:
62: }