}
// all columns end up as text
-function db_createTable($tablename, $ncolumns)
+function db_createTable($tablename)
{
$db = db_getDB();
$sql = "create table \"$tablename\" (\"".$tablename."_id\" INTEGER PRIMARY KEY AUTOINCREMENT";
- for($i=1; $i <= $ncolumns; $i++) {
- $colname = "column_$i";
+ for($i=1; $i < func_num_args(); $i++) {
+ $colname = func_get_arg($i);
$sql .= ", $colname text";
}
$sql .= ")";
+ echo "sql: $sql\n";
$db->query($sql);
}
{
$db = db_getDB();
- $sql = "select * from \"$tablename\" where column_$column like '%$value%'";
+ $sql = "select * from \"$tablename\" where $column like '%$value%'";
$res = $db->query($sql);
$data = $res->fetchAll();
}
+function db_updateData($tablename, $column, $newdata, $wherecol, $wheredata, $exact=true)
+{
+ $db = db_getDB();
+
+ if($exact) $sql = "update \"$tablename\" set $column='$newdata' where $wherecol='$wheredata'";
+ else $sql = "update \"$tablename\" set $column='$newdata' where $wherecol like '$wheredata'";
+ return $db->query($sql);
+}
+
function db_deleteTable($tablename)
{
$db = db_getDB();