Initialize Repo: First Commit

2 files changed, 49 insertions, 0 deletions

diff --git a/bootstrap/database/Connection.php b/bootstrap/database/Connection.php
new file mode 100644
index 0000000..deec2c6
--- /dev/null
+++ b/bootstrap/database/Connection.php
@@ -0,0 +1,18 @@
+<?php
+
+class Connection
+{
+    public static function make($config)
+    {
+        try {
+            return new PDO(
+                $config['connection'].';dbname='.$config['name'],
+                $config['username'],
+                $config['password'],
+                $config['options']
+            );
+        } catch (PDOException $e) {
+            error_log($e->getMessage());
+        }
+    }
+}
diff --git a/bootstrap/database/QueryBuilder.php b/bootstrap/database/QueryBuilder.php
new file mode 100644
index 0000000..a814ed3
--- /dev/null
+++ b/bootstrap/database/QueryBuilder.php
@@ -0,0 +1,31 @@
+<?php
+
+class QueryBuilder
+{
+    protected $pdo;
+
+    public function __construct($pdo)
+    {
+        $this->pdo = $pdo;
+    }
+
+    public function selectAll($table, $intoClass)
+    {
+        $statement = $this->pdo->prepare("select * from {$table}");
+        $statement->execute();
+        return $statement->fetchAll(PDO::FETCH_CLASS, $intoClass);
+    }
+
+    public function insert($table, $data)
+    {
+        $sql = sprintf(
+            'insert into %s (%s) values (%s)',
+            $table,
+            implode(', ', array_keys($data)),
+            ':' . implode(', :', array_keys($data))
+        );
+
+        $statment = $this->pdo->prepare($sql);
+        $statment->execute($data);
+    }
+}