X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/a89937ec79577fd78af6fe40450ca53dd2d3604f..f988982ad609256e3bbbb8a41ca7c7b0b3b4fb74:/database.inc.php diff --git a/database.inc.php b/database.inc.php index 2183358..464126b 100644 --- a/database.inc.php +++ b/database.inc.php @@ -22,13 +22,24 @@ class DB return $stmt; } + function _value($val, &$params) + { + $params[] = $val; + return '?'; + } + function insert($table, $row) { + $params = []; + $cols = []; + foreach ($row as $col => $val) { + $cols[] = $this->_value($val, $params); + } $sql = sprintf('INSERT INTO %s (%s) VALUES (%s)', '"'.$table.'"', implode(', ', array_keys($row)), - implode(', ', array_fill(0, count($row), '?')) + implode(', ', $cols) ); - return $this->query($sql, array_values($row)); + return $this->query($sql, $params); } }