8 global $BASE_DIR, $DB_HANDLE;
9 if($DB_HANDLE != false) return $DB_HANDLE;
11 $dbobject = new PDO("$DB_URL");
12 } catch(PDOException $exep) {
13 error_log("execpt on db open");
17 $DB_HANDLE = $dbobject;
22 function db_createDB()
24 // theres not much to do yet with only sqlite support
27 // all columns end up as text
28 function db_createTable($tablename)
32 $sql = "create table \"$tablename\" (\"".$tablename."_id\" INTEGER PRIMARY KEY AUTOINCREMENT";
33 for($i=1; $i < func_num_args(); $i++) {
34 $colname = func_get_arg($i);
35 $sql .= ", $colname text";
43 function db_insertData($tablename)
48 $sql = "insert into \"$tablename\" values (NULL";
49 for($i=1; $i < func_num_args(); $i++) {
50 $sql .= ",'".func_get_arg($i)."'";
57 function db_selectData($tablename, $column, $value)
61 $sql = "select * from \"$tablename\" where $column like '%$value%'";
62 $res = $db->query($sql);
63 $data = $res->fetchAll();
68 function db_deleteData($tablename, $column, $value)
72 $sql = "delete from \"$tablename\" where column_$column like '%$value%'";
73 return $db->query($sql);
77 function db_updateData($tablename, $column, $newdata, $wherecol, $wheredata, $exact=true)
81 if($exact) $sql = "update \"$tablename\" set $column='$newdata' where $wherecol='$wheredata'";
82 else $sql = "update \"$tablename\" set $column='$newdata' where $wherecol like '$wheredata'";
83 return $db->query($sql);
86 function db_deleteTable($tablename)
90 $sql = "drop table $tablename";
92 return $db->query($sql);
95 function db_tableExists($tablename)
99 $sql = "select count(*) from sqlite_master where type='table' and name='$tablename'";
100 $res = $db->query($sql);
102 $value = $res->fetchColumn();
104 if($value == 1) return true;
108 function db_getTables()
112 $sql = "select name from sqlite_master where type='table' and name not like 'sqlite_%'";
113 $res = $db->query($sql);
115 return $res->fetchAll();