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
|
//Connection
$connection=mysql_connect("localhost","root","");
//Selcetion dela base de donnee
$base=mysql_select_db("dispatch");
$commande=explode("\n",$_POST['commande']);
$date = date("Y-m-d");
$today = date('j-m-y-H-i-s');
$codebare = '*'.$today.'*';
foreach($commande as $index=>$value){
//Ecriture de la requete
$sql = "INSERT INTO retour VALUES (NULL, '".
$value."', CURRENT_TIMESTAMP, '".
$_POST['dispatcheur']."',' ".
$_POST['preparateur']."', '".
$_POST['service']."', '".
$date."', '".
$_POST['zone']."')";
//Execution de la requete
$resultat=mysql_query($sql);
}
?> |
Partager