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 tourisme 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"); $portes= mysqli_result($result00z,$z,"portes"); $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"); $cat=$categorie; if ($cat=='A') { $t1= mysqli_result($result00a,$u,"a1"); $t2 = mysqli_result($result00a,$u,"a2"); $t3 = mysqli_result($result00a,$u,"a3"); $t4 = mysqli_result($result00a,$u,"a4"); $t5 = mysqli_result($result00a,$u,"a5"); $t6 = mysqli_result($result00a,$u,"a6"); $t7 = mysqli_result($result00a,$u,"a7"); $t8 = mysqli_result($result00a,$u,"a8"); } if ($cat=='B') { $t1= mysqli_result($result00a,$u,"b1"); $t2 = mysqli_result($result00a,$u,"b2"); $t3 = mysqli_result($result00a,$u,"b3"); $t4 = mysqli_result($result00a,$u,"b4"); $t5 = mysqli_result($result00a,$u,"b5"); $t6 = mysqli_result($result00a,$u,"b6"); $t7 = mysqli_result($result00a,$u,"b7"); $t8 = mysqli_result($result00a,$u,"b8"); } if ($cat=='C') { $t1= mysqli_result($result00a,$u,"c1"); $t2 = mysqli_result($result00a,$u,"c2"); $t3 = mysqli_result($result00a,$u,"c3"); $t4 = mysqli_result($result00a,$u,"c4"); $t5 = mysqli_result($result00a,$u,"c5"); $t6 = mysqli_result($result00a,$u,"c6"); $t7 = mysqli_result($result00a,$u,"c7"); $t8 = mysqli_result($result00a,$u,"c8"); } if ($cat=='D') { $t1= mysqli_result($result00a,$u,"d1"); $t2 = mysqli_result($result00a,$u,"d2"); $t3 = mysqli_result($result00a,$u,"d3"); $t4 = mysqli_result($result00a,$u,"d4"); $t5 = mysqli_result($result00a,$u,"d5"); $t6 = mysqli_result($result00a,$u,"d6"); $t7 = mysqli_result($result00a,$u,"d7"); $t8 = mysqli_result($result00a,$u,"d8"); } if ($cat=='E') { $t1= mysqli_result($result00a,$u,"e1"); $t2 = mysqli_result($result00a,$u,"e2"); $t3 = mysqli_result($result00a,$u,"e3"); $t4 = mysqli_result($result00a,$u,"e4"); $t5 = mysqli_result($result00a,$u,"e5"); $t6 = mysqli_result($result00a,$u,"e6"); $t7 = mysqli_result($result00a,$u,"e7"); $t8 = mysqli_result($result00a,$u,"e8"); } if ($cat=='F') { $t1= mysqli_result($result00a,$u,"f1"); $t2 = mysqli_result($result00a,$u,"f2"); $t3 = mysqli_result($result00a,$u,"f3"); $t4 = mysqli_result($result00a,$u,"f4"); $t5 = mysqli_result($result00a,$u,"f5"); $t6 = mysqli_result($result00a,$u,"f6"); $t7 = mysqli_result($result00a,$u,"f7"); $t8 = mysqli_result($result00a,$u,"f8"); } } ?>