include('connexion_db.php'); $categorie=$_GET[categorie]; $erreur=$_GET[erreur]; $nom=$_POST[nom]; $prenom=$_POST[prenom]; $adresse=$_POST[adresse]; $ville=$_POST[ville]; $email=$_POST[email]; $tel=$_POST[tel]; $gsm=$_POST[gsm]; $km=$_POST[km]; $d_jour=$_POST[d_jour]; $d_mois=$_POST[d_mois]; $d_annee=$_POST[d_annee]; $d_heure=$_POST[d_heure]; $r_jour=$_POST[r_jour]; $r_mois=$_POST[r_mois]; $r_annee=$_POST[r_annee]; $r_heure=$_POST[r_heure]; // RECUP BDD DES INFOS SUR LE VEHICULE $query00z = "SELECT * FROM utilitaires WHERE categorie='$categorie'"; $result00z = mysqli_query($connect,$query00z); $carburant= mysqli_result($result00z,$z,"carburant"); $query00y = "SELECT * FROM carburant WHERE id='$carburant'"; $result00y = mysqli_query($connect,$query00y); $carbu= mysqli_result($result00y,$y,"typecarbu"); $places= mysqli_result($result00z,$z,"places"); $peage= mysqli_result($result00z,$z,"peage"); $opt1= mysqli_result($result00z,$z,"option1"); $query00x = "SELECT * FROM options WHERE id='$opt1'"; $result00x = mysqli_query($connect,$query00x); $op1= mysqli_result($result00x,$x,"opt"); $opt2= mysqli_result($result00z,$z,"option2"); $query00w = "SELECT * FROM options WHERE id='$opt2'"; $result00w = mysqli_query($connect,$query00w); $op2= mysqli_result($result00w,$w,"opt"); $opt3= mysqli_result($result00z,$z,"option3"); $query00v = "SELECT * FROM options WHERE id='$opt3'"; $result00v = mysqli_query($connect,$query00v); $op3= mysqli_result($result00v,$v,"opt"); $sup1= mysqli_result($result00z,$z,"supp1"); $query00s = "SELECT * FROM supplements WHERE id='$sup1'"; $result00s = mysqli_query($connect,$query00s); $supp1= mysqli_result($result00s,$s,"suppl"); $sup2= mysqli_result($result00z,$z,"supp2"); $query00t = "SELECT * FROM supplements WHERE id='$sup2'"; $result00t = mysqli_query($connect,$query00t); $supp2= mysqli_result($result00t,$t,"suppl"); $sup3= mysqli_result($result00z,$z,"supp3"); $query00u = "SELECT * FROM supplements WHERE id='$sup3'"; $result00u = mysqli_query($connect,$query00u); $supp3= mysqli_result($result00u,$u,"suppl"); $img1= mysqli_result($result00z,$z,"image1"); $img2= mysqli_result($result00z,$z,"image2"); $img3= mysqli_result($result00z,$z,"image3"); // RECUP BDD DES TARIFS SUR LE VEHICULE $query00a = "SELECT * FROM tarifs ORDER BY id DESC LIMIT 1"; $result00a = mysqli_query($connect,$query00a); $nb00a = mysqli_num_rows($result00a); if ($nb00a==0) {} else { $a1= mysqli_result($result00a,$u,"a1"); $a2 = mysqli_result($result00a,$u,"a2"); $a3 = mysqli_result($result00a,$u,"a3"); $a4 = mysqli_result($result00a,$u,"a4"); $a5 = mysqli_result($result00a,$u,"a5"); $a6 = mysqli_result($result00a,$u,"a6"); $a7 = mysqli_result($result00a,$u,"a7"); $a8 = mysqli_result($result00a,$u,"a8"); $b1 = mysqli_result($result00a,$u,"b1"); $b2 = mysqli_result($result00a,$u,"b2"); $b3 = mysqli_result($result00a,$u,"b3"); $b4 = mysqli_result($result00a,$u,"b4"); $b5 = mysqli_result($result00a,$u,"b5"); $b6 = mysqli_result($result00a,$u,"b6"); $b7 = mysqli_result($result00a,$u,"b7"); $b8 = mysqli_result($result00a,$u,"b8"); $c1 = mysqli_result($result00a,$u,"c1"); $c2 = mysqli_result($result00a,$u,"c2"); $c3 = mysqli_result($result00a,$u,"c3"); $c4 = mysqli_result($result00a,$u,"c4"); $c5 = mysqli_result($result00a,$u,"c5"); $c6 = mysqli_result($result00a,$u,"c6"); $c7 = mysqli_result($result00a,$u,"c7"); $c8= mysqli_result($result00a,$u,"c8"); $d1 = mysqli_result($result00a,$u,"d1"); $d2 = mysqli_result($result00a,$u,"d2"); $d3 = mysqli_result($result00a,$u,"d3"); $d4 = mysqli_result($result00a,$u,"d4"); $d5 = mysqli_result($result00a,$u,"d5"); $d6 = mysqli_result($result00a,$u,"d6"); $d7 = mysqli_result($result00a,$u,"d7"); $d8= mysqli_result($result00a,$u,"d8"); $e1 = mysqli_result($result00a,$u,"e1"); $e2 = mysqli_result($result00a,$u,"e2"); $e3= mysqli_result($result00a,$u,"e3"); $e4= mysqli_result($result00a,$u,"e4"); $e5 = mysqli_result($result00a,$u,"e5"); $e6= mysqli_result($result00a,$u,"e6"); $e7 = mysqli_result($result00a,$u,"e7"); $d7 = mysqli_result($result00a,$u,"d7"); $d8= mysqli_result($result00a,$u,"d8"); $d9 = mysqli_result($result00a,$u,"d9"); $e8 = mysqli_result($result00a,$u,"e8"); $f1= mysqli_result($result00a,$u,"f1"); $f2 = mysqli_result($result00a,$u,"f2"); $f3 = mysqli_result($result00a,$u,"f3"); $f4= mysqli_result($result00a,$u,"f4"); $f5 = mysqli_result($result00a,$u,"f5"); $f6 = mysqli_result($result00a,$u,"f6"); $f7= mysqli_result($result00a,$u,"f7"); $f8 = mysqli_result($result00a,$u,"f8"); $t3_1 = mysqli_result($result00a,$u,"t3_1"); $t3_2= mysqli_result($result00a,$u,"t3_2"); $t3_3 = mysqli_result($result00a,$u,"t3_3"); $t3_4 = mysqli_result($result00a,$u,"t3_4"); $t3_5= mysqli_result($result00a,$u,"t3_5"); $t3_6 = mysqli_result($result00a,$u,"t3_6"); $t3_7 = mysqli_result($result00a,$u,"t3_7"); $t4_1= mysqli_result($result00a,$u,"t4_1"); $t4_2 = mysqli_result($result00a,$u,"t4_2"); $t4_3 = mysqli_result($result00a,$u,"t4_3"); $t4_4= mysqli_result($result00a,$u,"t4_4"); $t4_5 = mysqli_result($result00a,$u,"t4_5"); $t4_6 = mysqli_result($result00a,$u,"t4_6"); $t4_7= mysqli_result($result00a,$u,"t4_7"); $t5_1 = mysqli_result($result00a,$u,"t5_1"); $t5_2 = mysqli_result($result00a,$u,"t5_2"); $t5_3= mysqli_result($result00a,$u,"t5_3"); $t5_4 = mysqli_result($result00a,$u,"t5_4"); $t5_5 = mysqli_result($result00a,$u,"t5_5"); $t5_6= mysqli_result($result00a,$u,"t5_6"); $t5_7 = mysqli_result($result00a,$u,"t5_7"); $t8_1 = mysqli_result($result00a,$u,"t8_1"); $t8_2= mysqli_result($result00a,$u,"t8_2"); $t8_3 = mysqli_result($result00a,$u,"t8_3"); $t8_4 = mysqli_result($result00a,$u,"t8_4"); $t8_5= mysqli_result($result00a,$u,"t8_5"); $t8_6 = mysqli_result($result00a,$u,"t8_6"); $t8_7 = mysqli_result($result00a,$u,"t8_7"); $t10_1= mysqli_result($result00a,$u,"t10_1"); $t10_2 = mysqli_result($result00a,$u,"t10_2"); $t10_3 = mysqli_result($result00a,$u,"t10_3"); $t10_4= mysqli_result($result00a,$u,"t10_4"); $t10_5 = mysqli_result($result00a,$u,"t10_5"); $t10_6 = mysqli_result($result00a,$u,"t10_6"); $t10_7= mysqli_result($result00a,$u,"t10_7"); $t17_1 = mysqli_result($result00a,$u,"t17_1"); $t17_2 = mysqli_result($result00a,$u,"t17_2"); $t17_3= mysqli_result($result00a,$u,"t17_3"); $t17_4 = mysqli_result($result00a,$u,"t17_4"); $t17_5 = mysqli_result($result00a,$u,"t17_5"); $t17_6= mysqli_result($result00a,$u,"t17_6"); $t17_7 = mysqli_result($result00a,$u,"t17_7"); $t20_1 = mysqli_result($result00a,$u,"t20_1"); $t20_2= mysqli_result($result00a,$u,"t20_2"); $t20_3= mysqli_result($result00a,$u,"t20_3"); $t20_4 = mysqli_result($result00a,$u,"t20_4"); $t20_5= mysqli_result($result00a,$u,"t20_5"); $t20_6= mysqli_result($result00a,$u,"t20_6"); $t20_7 = mysqli_result($result00a,$u,"t20_7"); $t2t3_1= mysqli_result($result00a,$u,"t2t3_1"); $t2t3_2= mysqli_result($result00a,$u,"t2t3_2"); $t2t3_3 = mysqli_result($result00a,$u,"t2t3_3"); $t2t3_4= mysqli_result($result00a,$u,"t2t3_4"); $t2t3_5= mysqli_result($result00a,$u,"t2t3_5"); $t2t3_6 = mysqli_result($result00a,$u,"t2t3_6"); $t2t3_7= mysqli_result($result00a,$u,"t2t3_7"); $t3tt5_1= mysqli_result($result00a,$u,"t3tt5_1"); $t3tt5_2= mysqli_result($result00a,$u,"t3tt5_2"); $t3tt5_3 = mysqli_result($result00a,$u,"t3tt5_3"); $t3tt5_4= mysqli_result($result00a,$u,"t3tt5_4"); $t3tt5_5= mysqli_result($result00a,$u,"t3tt5_5"); $t3tt5_6 = mysqli_result($result00a,$u,"t3tt5_6"); $t3tt5_7= mysqli_result($result00a,$u,"t3tt5_7"); $pv1= mysqli_result($result00a,$u,"pv1"); $pv2= mysqli_result($result00a,$u,"pv2"); $pv3 = mysqli_result($result00a,$u,"pv3"); $pv4= mysqli_result($result00a,$u,"pv4"); $pv5= mysqli_result($result00a,$u,"pv5"); $pv6 = mysqli_result($result00a,$u,"pv6"); $pv7= mysqli_result($result00a,$u,"pv7"); $cat=$categorie; $cat=urldecode($cat); if ($cat=='3m3') { $t1= mysqli_result($result00a,$u,"t3_1"); $t2 = mysqli_result($result00a,$u,"t3_2"); $t3 = mysqli_result($result00a,$u,"t3_3"); $t4 = mysqli_result($result00a,$u,"t3_4"); $t5 = mysqli_result($result00a,$u,"t3_5"); $t6 = mysqli_result($result00a,$u,"t3_6"); $t7 = mysqli_result($result00a,$u,"t3_7"); $t8 = mysqli_result($result00a,$u,"t3_8"); } if ($cat=='4m3') { $t1= mysqli_result($result00a,$u,"t4_1"); $t2 = mysqli_result($result00a,$u,"t4_2"); $t3 = mysqli_result($result00a,$u,"t4_3"); $t4 = mysqli_result($result00a,$u,"t4_4"); $t5 = mysqli_result($result00a,$u,"t4_5"); $t6 = mysqli_result($result00a,$u,"t4_6"); $t7 = mysqli_result($result00a,$u,"t4_7"); $t8 = mysqli_result($result00a,$u,"t4_8"); } if ($cat=='5m3') { $t1= mysqli_result($result00a,$u,"t5_1"); $t2 = mysqli_result($result00a,$u,"t5_2"); $t3 = mysqli_result($result00a,$u,"t5_3"); $t4 = mysqli_result($result00a,$u,"t5_4"); $t5 = mysqli_result($result00a,$u,"t5_5"); $t6 = mysqli_result($result00a,$u,"t5_6"); $t7 = mysqli_result($result00a,$u,"t5_7"); $t8 = mysqli_result($result00a,$u,"t5_8"); } if ($cat=='8m3') { $t1= mysqli_result($result00a,$u,"t8_1"); $t2 = mysqli_result($result00a,$u,"t8_2"); $t3 = mysqli_result($result00a,$u,"t8_3"); $t4 = mysqli_result($result00a,$u,"t8_4"); $t5 = mysqli_result($result00a,$u,"t8_5"); $t6 = mysqli_result($result00a,$u,"t8_6"); $t7 = mysqli_result($result00a,$u,"t8_7"); $t8 = mysqli_result($result00a,$u,"t8_8"); } if ($cat=='10m3') { $t1= mysqli_result($result00a,$u,"t10_1"); $t2 = mysqli_result($result00a,$u,"t10_2"); $t3 = mysqli_result($result00a,$u,"t10_3"); $t4 = mysqli_result($result00a,$u,"t10_4"); $t5 = mysqli_result($result00a,$u,"t10_5"); $t6 = mysqli_result($result00a,$u,"t10_6"); $t7 = mysqli_result($result00a,$u,"t10_7"); $t8 = mysqli_result($result00a,$u,"t10_8"); } if ($cat=='17m3') { $t1= mysqli_result($result00a,$u,"t17_1"); $t2 = mysqli_result($result00a,$u,"t17_2"); $t3 = mysqli_result($result00a,$u,"t17_3"); $t4 = mysqli_result($result00a,$u,"t17_4"); $t5 = mysqli_result($result00a,$u,"t17_5"); $t6 = mysqli_result($result00a,$u,"t17_6"); $t7 = mysqli_result($result00a,$u,"t17_7"); $t8 = mysqli_result($result00a,$u,"t17_8"); } if ($cat=='20m3') { $t1= mysqli_result($result00a,$u,"t20_1"); $t2 = mysqli_result($result00a,$u,"t20_2"); $t3 = mysqli_result($result00a,$u,"t20_3"); $t4 = mysqli_result($result00a,$u,"t20_4"); $t5 = mysqli_result($result00a,$u,"t20_5"); $t6 = mysqli_result($result00a,$u,"t20_6"); $t7 = mysqli_result($result00a,$u,"t20_7"); $t8 = mysqli_result($result00a,$u,"t20_8"); } if ($cat=='23m3') { $t1= mysqli_result($result00a,$u,"t2t3_1"); $t2 = mysqli_result($result00a,$u,"t2t3_2"); $t3 = mysqli_result($result00a,$u,"t2t3_3"); $t4 = mysqli_result($result00a,$u,"t2t3_4"); $t5 = mysqli_result($result00a,$u,"t2t3_5"); $t6 = mysqli_result($result00a,$u,"t2t3_6"); $t7 = mysqli_result($result00a,$u,"t2t3_7"); $t8 = mysqli_result($result00a,$u,"t2t3_8"); } if ($cat=='Benne') { $t1= mysqli_result($result00a,$u,"t3tt5_1"); $t2 = mysqli_result($result00a,$u,"t3tt5_2"); $t3 = mysqli_result($result00a,$u,"t3tt5_3"); $t4 = mysqli_result($result00a,$u,"t3tt5_4"); $t5 = mysqli_result($result00a,$u,"t3tt5_5"); $t6 = mysqli_result($result00a,$u,"t3tt5_6"); $t7 = mysqli_result($result00a,$u,"t3tt5_7"); $t8 = mysqli_result($result00a,$u,"t3tt5_8"); } if ($cat=='PV') { $t1= mysqli_result($result00a,$u,"pv1"); $t2 = mysqli_result($result00a,$u,"pv2"); $t3 = mysqli_result($result00a,$u,"pv3"); $t4 = mysqli_result($result00a,$u,"pv4"); $t5 = mysqli_result($result00a,$u,"pv5"); $t6 = mysqli_result($result00a,$u,"pv6"); $t7 = mysqli_result($result00a,$u,"pv7"); } } ?>