aggiunto codice per aggiungere dati al database tramite il form precedentemente creato (parte 124)
| | |
| | | ]); |
| | | echo $this->viewer->render("Products/new.php"); |
| | | } |
| | | |
| | | public function create() { |
| | | $data = [ |
| | | "name" => $_POST["name"], |
| | | "description" => $_POST["description"] |
| | | ]; |
| | | |
| | | var_dump($this->model->insert($data)); |
| | | } |
| | | } |
| | |
| | | $stmt->execute(); |
| | | return $stmt->fetch(PDO::FETCH_ASSOC); |
| | | } |
| | | |
| | | public function insert(array $data) : bool { |
| | | $sql = "INSERT INTO product (name, description) VALUES (?,?)"; |
| | | $conn = $this->database->getConnection(); |
| | | $stmt = $conn->prepare($sql); |
| | | $stmt->bindValue(1, $data["name"], PDO::PARAM_STR); |
| | | $stmt->bindValue(2, $data["description"], PDO::PARAM_STR); |
| | | |
| | | return $stmt->execute(); |
| | | } |
| | | } |
| | | |
| | | |
| | |
| | | <body> |
| | | <h1>New product</h1> |
| | | <method="post"> |
| | | <form method="post" action="/products/create"> |
| | | <label for="name">Name</label> |
| | | <input type="text", id="name", name="name"> |
| | | |