issue: database insert method to keep array values

[minimedit.git] / database.inc.php

diff --git a/database.inc.php b/database.inc.php
index 6e040d46d8cba08d3a9cef90d9cbba5637f0b2ac..464126b3fad1370fe17f6e32dd4863a92dd759a5 100644 (file)
--- a/database.inc.php
+++ b/database.inc.php
@@ -1,4 +1,45 @@
 <?php
 $dsn = require '.dbconfig.inc.php';
-$options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ];
-$Db = new PDO($dsn, NULL, NULL, $options);
+$Db = new DB($dsn);
+
+class DB
+{
+       public $dbh;
+
+       function __construct($config, $options = [])
+       {
+               $options += [
+                       PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
+                       PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
+               ];
+               $this->dbh = new PDO($config, NULL, NULL, $options);
+       }
+
+       function query($sql, $params = [])
+       {
+               $stmt = $this->dbh->prepare($sql);
+               $stmt->execute($params);
+               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(', ', $cols)
+               );
+               return $this->query($sql, $params);
+       }
+}