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
|
$pdo2 = conn_pdo();
$pdo2->exec("UPDATE plat SET plat_order='0'");
$sql = "
INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order)
VALUES
('".utf8_decode(str_replace("'", "\'", $_POST['entree1_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['entree1l2_id']))."','1','1')
,('".utf8_decode(str_replace("'", "\'", $_POST['entree2_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['entree2l2_id']))."','1','2')
,('".utf8_decode(str_replace("'", "\'", $_POST['entree3_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['entree3l2_id']))."','1','3')
,('".utf8_decode(str_replace("'", "\'", $_POST['plat1_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['plat1l2_id']))."','2','1')
,('".utf8_decode(str_replace("'", "\'", $_POST['plat2_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['plat2l2_id']))."','2','2')
,('".utf8_decode(str_replace("'", "\'", $_POST['plat3_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['plat3l2_id']))."','2','3')
,('".utf8_decode(str_replace("'", "\'", $_POST['platc1_id']))."','','5','1')
,('".utf8_decode(str_replace("'", "\'", $_POST['platc2_id']))."','','5','2')
,('".utf8_decode(str_replace("'", "\'", $_POST['platc3_id']))."','','5','3')
,('".utf8_decode(str_replace("'", "\'", $_POST['dessert1_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['dessert1l2_id']))."','3','1')
,('".utf8_decode(str_replace("'", "\'", $_POST['dessert2_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['dessert2l2_id']))."','3','2')
,('".utf8_decode(str_replace("'", "\'", $_POST['dessert3_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['dessert3l2_id']))."','3','3')
,('".utf8_decode(str_replace("'", "\'", $_POST['dessert4_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['dessert4l2_id']))."','3','4')
,('".utf8_decode(str_replace("'", "\'", $_POST['dessert5_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['dessert5l2_id']))."','3','5')
,('".utf8_decode(str_replace("'", "\'", $_POST['fromage1_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['fromage1l2_id']))."','4','1')
,('".utf8_decode(str_replace("'", "\'", $_POST['fromage2_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['fromage2l2_id']))."','4','2')
,('".utf8_decode(str_replace("'", "\'", $_POST['fromage3_id']))."','".utf8_decode(str_replace("'", "\'", $_POST['fromage3l2_id']))."','4','3')
ON DUPLICATE KEY UPDATE plat_order=VALUES(plat_order);";
$pdo2->exec($sql); |
Partager