X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/ed1cd294e32647b117688b25a465889e4664fe03..2d7b510a9d33a552b024e1db00212658f21afce6:/database.inc.php diff --git a/database.inc.php b/database.inc.php index b2244b9..d6da853 100644 --- a/database.inc.php +++ b/database.inc.php @@ -29,6 +29,9 @@ class DB $params = array_merge($params, $val); return $sql; } + elseif (is_bool($val)) { + return $val ? 'TRUE' : 'FALSE'; + } $params[] = $val; return '?'; @@ -42,7 +45,7 @@ class DB foreach ($row as $col => $val) { $cols[] = $this->_value($val, $params); } - $sql = sprintf('INSERT INTO %s (%s) VALUES (%s) RETURNING *', + $sql = sprintf('INSERT INTO %s (%s) VALUES (%s)', '"'.$table.'"', implode(', ', array_keys($row)), implode(', ', $cols) @@ -64,6 +67,7 @@ class DB $sql .= ' ' . $filter; } } + $sql .= ' RETURNING *'; return $this->query($sql, $params); } }