corso https://vola.udemy.com/course/php-mvc-from-scratch/learn/lecture/40931984#overview
filippo.bertilotti
2024-05-21 fc5ee7f51fda1855c792fbedba17021aa982ce3f
aggiunto codice per aggiungere dati al database tramite il form precedentemente creato (parte 124)
3 files modified
21 ■■■■■ changed files
src/App/Controllers/products.php 9 ●●●●● patch | view | raw | blame | history
src/Framework/Model.php 10 ●●●●● patch | view | raw | blame | history
views/Products/new.php 2 ●●● patch | view | raw | blame | history
src/App/Controllers/products.php
@@ -36,4 +36,13 @@
        ]);
        echo $this->viewer->render("Products/new.php");
    }
    public function create() {
        $data = [
            "name" => $_POST["name"],
            "description" => $_POST["description"]
        ];
        var_dump($this->model->insert($data));
    }
}
src/Framework/Model.php
@@ -34,6 +34,16 @@
            $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();
        }
    }
views/Products/new.php
@@ -1,6 +1,6 @@
<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">