refactor per renderlo dinamico (parte 125)
| | |
| | | "name" => $_POST["name"], |
| | | "description" => $_POST["description"] |
| | | ]; |
| | | |
| | | |
| | | var_dump($this->model->insert($data)); |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | 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); |