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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
| <?php
session_start();
// appel du fichier des fonctions
include_once'mes_fonctions.php';
$nomexp=$_POST['nomexp'];
$prenomexp=$_POST['prenomexp'];
$telexp=$_POST['telexp'];
$paysexp=$_POST['paysexp'];
$villeexp=$_POST['villeexp'];
$rueexp=$_POST['rueexp'];
$nomdest=$_POST['nomdest'];
$prenomdest=$_POST['prenomdest'];
$teldest=$_POST['teldest'];
$paysdest=$_POST['paysdest'];
$villedest=$_POST['villedest'];
$ruedest=$_POST['ruedest'];
$qte1=$_POST['qte1']; $qte2=$_POST['qte2']; $qte3=$_POST['qte3']; $qte4=$_POST['qte4']; $qte5=$_POST['qte5']; $qte6=$_POST['qte6'];
$desi1=$_POST['desi1']; $desi2=$_POST['desi2']; $desi3=$_POST['desi3']; $desi4=$_POST['desi4']; $desi5=$_POST['desi5']; $desi6=$_POST['desi6'];
$pd1=$_POST['pd1']; $pd2=$_POST['pd2']; $pd3=$_POST['pd3']; $pd4=$_POST['pd4']; $pd5=$_POST['pd5']; $pd6=$_POST['pd6'];
$prix1=$_POST['prix1']; $prix2=$_POST['prix2']; $prix3=$_POST['prix3']; $prix4=$_POST['prix4']; $prix5=$_POST['prix5']; $prix6=$_POST['prix6'];
$_SESSION['dateexpedition']=$_POST['dateexpedition'];
$_SESSION['heureexpedition']=$_POST['heureexpedition'];
$dateexp=$_SESSION['dateexpedition'];
$heureexpedition=$_SESSION['heureexpedition'];
$_SESSION['statut']=$_POST['statut'];
$statut=$_SESSION['statut'];
$_SESSION['typepay']=$_POST['typepay'];
$typepayment=$_SESSION['typepay'];
// se connecte a la bd.
connection_bd(projetcourier);
// insert l'expediteur.
$sql = " insert into EXPEDITEURS values ('', '$nomexp', '$prenomexp', '$telexp', '$paysexp', '$villeexp', '$rueexp') ";
$rep=requette_sql($sql);
mysql_close();
// recupere le code du dernier expediteur.
connection_bd(projetcourier);
$sql = " select code_exp from EXPEDITEURS ";
$rep=requette_sql($sql);
mysql_close();
while($ligne=mysql_fetch_array($rep))
{
$codeexpediteur=$ligne['code_exp'];
}
// insert le destinataire
connection_bd(projetcourier);
$sql = " insert into DESTINATAIRES values ('', '$nomdest', '$prenomdest', '$teldest', '$paysdest', '$villedest', '$ruedest') ";
$rep=requette_sql($sql);
mysql_close();
// recupere le code du dernier destinataire.
connection_bd(projetcourier);
$sql = " select * from DESTINATAIRES ";
$rep=requette_sql($sql);
mysql_close();
while($ligne=mysql_fetch_array($rep))
{
$codedestinataire=$ligne['code_dest'];
}
// enregistre l'expedition
connection_bd(projetcourier);
$sql = " insert into EXPEDITIONS values ('', '$codeexpediteur', '$codedestinataire', NULL, '$dateexp', '$heureexpedition', '$statut', '$typepayment') ";
$rep=requette_sql($sql);
// recupere le code de la derniere expedition.
$sql = " select * from EXPEDITIONS ";
$rep=requette_sql($sql);
$ligne=mysql_fetch_array($rep);
while($ligne=mysql_fetch_array($rep))
{
$codeexpedition=$ligne['code_expedition'];
} |
Partager