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
| $pdo2 = conn_pdo();
$r = array();
$r[0] = $pdo2->prepare("UPDATE plat SET plat_order='0'");
$r[1] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['entree1_id'])."','".utf8_decode($_POST['entree1l2_id'])."','1','1') ON DUPLICATE KEY UPDATE plat_order='1'");
$r[2] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['entree2_id'])."','".utf8_decode($_POST['entree2l2_id'])."','1','2') ON DUPLICATE KEY UPDATE plat_order='2'");
$r[3] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['entree3_id'])."','".utf8_decode($_POST['entree3l2_id'])."','1','3') ON DUPLICATE KEY UPDATE plat_order='3'");
$r[4] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['plat1_id'])."','".utf8_decode($_POST['plat1l2_id'])."','2','1') ON DUPLICATE KEY UPDATE plat_order='1'");
$r[5] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['plat2_id'])."','".utf8_decode($_POST['plat2l2_id'])."','2','2') ON DUPLICATE KEY UPDATE plat_order='2'");
$r[6] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['plat3_id'])."','".utf8_decode($_POST['plat3l2_id'])."','2','3') ON DUPLICATE KEY UPDATE plat_order='3'");
$r[7] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_type,plat_order) VALUES ('".utf8_decode($_POST['platc1_id'])."','5','1') ON DUPLICATE KEY UPDATE plat_order='1'");
$r[8] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_type,plat_order) VALUES ('".utf8_decode($_POST['platc2_id'])."','5','2') ON DUPLICATE KEY UPDATE plat_order='2'");
$r[9] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_type,plat_order) VALUES ('".utf8_decode($_POST['platc3_id'])."','5','3') ON DUPLICATE KEY UPDATE plat_order='3'");
$r[10] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['dessert1_id'])."','".utf8_decode($_POST['dessert1l2_id'])."','3','1') ON DUPLICATE KEY UPDATE plat_order='1'");
$r[11] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['dessert2_id'])."','".utf8_decode($_POST['dessert2l2_id'])."','3','2') ON DUPLICATE KEY UPDATE plat_order='2'");
$r[12] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['dessert3_id'])."','".utf8_decode($_POST['dessert3l2_id'])."','3','3') ON DUPLICATE KEY UPDATE plat_order='3'");
$r[13] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['dessert4_id'])."','".utf8_decode($_POST['dessert4l2_id'])."','3','4') ON DUPLICATE KEY UPDATE plat_order='4'");
$r[14] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['dessert5_id'])."','".utf8_decode($_POST['dessert5l2_id'])."','3','5') ON DUPLICATE KEY UPDATE plat_order='5'");
$r[15] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['fromage1_id'])."','".utf8_decode($_POST['fromage1l2_id'])."','4','1') ON DUPLICATE KEY UPDATE plat_order='1'");
$r[16] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['fromage2_id'])."','".utf8_decode($_POST['fromage2l2_id'])."','4','2') ON DUPLICATE KEY UPDATE plat_order='2'");
$r[17] = $pdo2->prepare("INSERT INTO plat (plat_lib,plat_lib2,plat_type,plat_order) VALUES ('".utf8_decode($_POST['fromage3_id'])."','".utf8_decode($_POST['fromage3l2_id'])."','4','3') ON DUPLICATE KEY UPDATE plat_order='3'");
foreach ($r as $val){
$val->execute();
$val->closeCursor();
} |
Partager