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
| $ID_med = $_POST['ID_medicament'];
$nom = $_POST["Nom"]; echo "$nom";
$num_lot = $_POST["num_lot"]; echo "$num_lot";
$date_fab = $_POST["date_fabrication"];
$date_per = $_POST["date_peremption"];
$prix_session = $_POST['prix_session']; echo "$prix_session";
$prix_public = $_POST['prix_public'];
$code_barre = $_POST['code_barre'];
$forme_pharma = $_POST['forme_pharmaceutique'];
$stock = $_POST['qte_en_stock'];
$stock_mini = $_POST['stock_mini'];
if ( (isset($_POST["ajouter"])) && ($_POST["ajouter"]=="Ajouter") )
{echo "Bonjour";}
echo "$nom,\"$num_lot\",\"$date_fab\",\"$date_per\",\"$prix_session\",\"$prix_public\",\"$code_barre\",\"$forme_pharma\",\"$stock\",\"$stock_mini\"";
if ($id = mysql_connect("localhost","root","")){
if ($id_db = mysql_select_db("raby")){
echo "Connexion a la base reussie";
$query = "INSERT INTO raby.medicament(ID_medicament,Nom,num_lot,date_fabrication,date_peremption,prix_session,prix_public,code_barre,forme_pharmaceutique,qte_en_stock,stock_mini)
values(NULL,'$nom','$num_lot','$date_fab','$date_per','$prix_session','$prix_public','$code_barre','$forme_pharma','$stock,$stock_mini')";
if ($result = mysql_query($query))
{echo "Enregistrement réussi.";}
else
Die ("Echec de l'enregistrement");
}
}
?> |
Partager