1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| if (isset($_POST)) {
$CatName = $_POST['editCategoriesName'];
$CatStatus = $_POST['editCategoriesStatus'];
$CatID = $_POST['editCategoriesId'];
$SousCatName = $_POST['editSousCategoriesName'];
$SousCatId = $_POST['editSousCategoriesId'];
$NewSousCatName = $_POST['NewsousCategoriesName'];
/* UPDATE CATEGORIE OK */
/*
$sth = $connect->prepare("UPDATE categories SET categories_nom = ?, categories_active = ? WHERE categories_id = ? AND categories_statut = 1");
$sth->bind_param('sss',$CatName,$CatStatus,$CatID);
$sth->execute();
*/
/* UPDATE SOUS CATEGORIE NOK */
/*
$sth2 = $connect->prepare("UPDATE souscategories SET souscategories_nom = ? WHERE souscategories_id = ?"); //ok
$sth2->bind_param('ss',$SousCatName,$SousCatId);//ok
foreach ($_POST['editSousCategoriesName'] as $id => $value) {
$sth2->execute(array($id, $value));
}
// var_dump($sth2);
*/
/* AJOUT NOUVELLE SOUS CATEGORIE NOK */
$sth3 = $connect->prepare("INSERT INTO souscategories (categories_id, categories_nom, souscategories_nom) VALUES (?, ?, ?)");
$sth3->bindParam(1, $CatID);
$sth3->bindParam(2, $CatName);
$sth3->bindParam(3, $NewSousCatName);
$sth3->execute(array($CatID, $CatName, $NewSousCatName));
// var_dump($sth3); |
Partager