From 6f90bfb985ab89d709f98171019c266bafde16ab Mon Sep 17 00:00:00 2001
From: filippo.bertilotti <filippobertilotti@gmail.com>
Date: Tue, 21 May 2024 12:43:09 +0200
Subject: [PATCH] refactor per renderlo dinamico (parte 125)
---
src/App/Controllers/products.php | 2 +-
src/Framework/Model.php | 7 ++++++-
2 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/src/App/Controllers/products.php b/src/App/Controllers/products.php
index fa9253f..2ef6737 100644
--- a/src/App/Controllers/products.php
+++ b/src/App/Controllers/products.php
@@ -42,7 +42,7 @@
"name" => $_POST["name"],
"description" => $_POST["description"]
];
-
+
var_dump($this->model->insert($data));
}
}
\ No newline at end of file
diff --git a/src/Framework/Model.php b/src/Framework/Model.php
index 5ed7a6a..4649c03 100644
--- a/src/Framework/Model.php
+++ b/src/Framework/Model.php
@@ -36,7 +36,12 @@
}
public function insert(array $data) : bool {
- $sql = "INSERT INTO product (name, description) VALUES (?,?)";
+ $columns = implode(", " , array_keys($data));
+ $placeholders = implode(", ", array_fill(0, count($data), "?"));
+
+ $sql = "INSERT INTO {$this->getTable()} ($columns) VALUES ($placeholders)";
+ exit($sql);
+
$conn = $this->database->getConnection();
$stmt = $conn->prepare($sql);
$stmt->bindValue(1, $data["name"], PDO::PARAM_STR);
--
Gitblit v1.8.0