<?php
//Connexion à partir de la base
$bdd=mysql_connect('localhost','login','');
mysql_select_db ('test', $bdd);
if (!$bdd){
die('<p>Impossible de se connecter:'.mysql_error().'</p>');
}
define("bdcms",5);
mysql_select_db('test',$bdd);
if (!bdcms){
die('<p>Impossible d\'utiliser la base de données:'.mysql_error().'</p>');
}
$sqlquery="select id,nom,prenom from membre order by nom";
$sqlqueryresult=mysql_query($sqlquery);
$sqlquery1="select id_categorie,libelle from categorie order by libelle";
$sqlqueryresult1=mysql_query($sqlquery1);
$sqlquery2="select reference,designation from produit order by reference";
$sqlqueryresult2=mysql_query($sqlquery2);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Gestion des stocks</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<link href="css/template.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php include('../marcel/entete.php'); ?>
<?php include('../marcel/menu.php'); ?>
<!--La partie principale-->
<div class="main">
<!--Message d'erreur-->
<div class="err">
<?php
if (isset($erreur)) echo '<br /><br />',$erreur;
?>
<!--La boîte de connection-->
<div class="box">
<h1>Bordereau d'entrée en stock</h1>
<form action="entree_stock.php" method="post">
<div class="field">
Date de saisie: <input type="text" name="date_saisie" size="10" maxlength="10" value="<?php if (isset($_POST['date_saisie'])) echo htmlentities(trim($_POST['date_saisie'])); ?>"><br />
</div>
<div class="field">
Date facture: <input type="text" name="date_mouvement" size="10" maxlength="10" value="<?php if (isset($_POST['date_mouvement'])) echo htmlentities(trim($_POST['date_mouvement'])); ?>"><br />
</div>
<div class="field">
Nom et prénom utilisateur :
<select name="p_nom" size="1" id="p_nom">
<?php
while($row=mysql_fetch_array($sqlqueryresult,MYSQL_ASSOC)){
echo"<option value='".$row['id']."'>".$row['nom']." ".$row['prenom']."</option>";
}
?>
</select>
</div>
<div class="field">
Réference produit:<select name="p_reference" size="1" id="p_reference" >
<?php
while ($row=mysql_fetch_array($sqlqueryresult2,MYSQL_ASSOC)){
echo"<option value='".$row['reference']."'>".$row['reference']." ".$row['designation']."</option>";
}
?>
</select>
</div>
<div class="field">
Catégorie: <select name="categorie" size="1" id="categorie" >
<?php
while ($row=mysql_fetch_array($sqlqueryresult1,MYSQL_ASSOC)){
echo"<option value='".$row['id_categorie']."'>".$row['libelle']."</option>";
}
?>
</select>
</div>
<div class="field">
Quantité : <input type="text" name="quantite" value="<?php if (isset($_POST['quantite'])) echo htmlentities(trim($_POST['quantite'])); ?>"><br />
</div>
<div class="field">
Prix unitaire : <input type="text" name="prix_unitaire" value="<?php if (isset($_POST['prix_unitaire'])) echo htmlentities(trim($_POST['prix_unitaire'])); ?>"><br />
</div>
<div class="buttons">
<input class="button"type="submit" name="enregistrer" value="Enregistrer">
<input class="button" type="reset" />
</div>
<input name="id" type="hidden" value="" />
</form>
</div>
</div>
<?php
// on teste si le visiteur a soumis le formulaire
if (isset($_POST['enregistrer']) && $_POST['enregistrer'] == 'Enregistrer') {
// on teste l'existence de nos variables. On teste également si elles ne sont pas vides
if ((isset($_POST['date_saisie']) && !empty($_POST['date_saisie'])) && (isset($_POST['date_mouvement']) &&
!empty($_POST['date_mouvement']))&&(isset($_POST['p_nom']) &&!empty($_POST['p_nom']))&&(isset($_POST['p_reference']) &&!empty($_POST['p_reference']))&&(isset($_POST['categorie'])&&!empty($_POST['categorie']))&&(isset($_POST['quantite'])&&!empty($_POST['quantite']))&&(isset($_POST['prix_unitaire'])&&!empty($_POST['prix_unitaire']))){
// Connexion à la base de données
$base = mysql_connect ('localhost', 'login', '');
$bdcm=mysql_select_db ('test', $base);
// on recherche si ce produit existe déjà dans la base de données
$sql = 'SELECT count(*) FROM entree_stock WHERE id_entree_stock="'.mysql_escape_string($_POST['id']).'"';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
$data = mysql_fetch_array($req);
if ($data[0] == 0) {
$sql = 'INSERT INTO entree_stock VALUES(" ","'.mysql_escape_string($_POST['date_saisie']).'","'.mysql_escape_string($_POST['date_mouvement']).'","'.mysql_escape_string($_POST['p_nom']).'","'.mysql_escape_string($_POST['p_reference']).'","'.mysql_escape_string($_POST['categorie']).'","'.mysql_escape_string($_POST['quantite']).'","'.mysql_escape_string($_POST['prix_unitaire']).'","'.mysql_escape_string($_POST['prix_unitaire']).'")';
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br />'.mysql_error());
mysql_query("UPDATE entree_stock SET prix_total=(quantite*prix_unitaire)");
// on recherche si ce produit existe déjà dans la base de données
$tse = 'SELECT count(*) FROM stock WHERE code_produit="'.mysql_escape_string($_POST['p_reference']).'"';
$mam = mysql_query($tse) or die('Erreur SQL !<br />'.$tse.'<br />'.mysql_error(
));
$tata = mysql_fetch_array($mam);
if ($tata[0] == 0) {
$tse = 'INSERT INTO stock VALUES("'.mysql_escape_string($_POST['p_reference']).'","'.mysql_escape_string($_POST['date_saisie']).'","'.mysql_escape_string($_POST['categorie']).'","'.mysql_escape_string($_POST['quantite']).'","'.mysql_escape_string($_POST['prix_unitaire']).'","'.mysql_escape_string($_POST['prix_total']).'")';
mysql_query($tse) or die('Erreur SQL !'.$tse.'<br />'.mysql_error());
mysql_query("UPDATE stock SET prix_total=(quantite*prix_unitaire)");
session_start();
$_SESSION['login'] = $_POST['login'];
header('Location:entree_stock.php');
exit();
}
}
}
}
?>
<p>Retour au menu:<a href=membre.php>Retour au menu</a></p>
<!--Le pied de page-->
</div>
<?php include('../marcel/pied_de_page.php'); ?>
</body>
</html>Du moins elles s'affichent:0000-00-00 que faire dans ce cas.
0000-00-00
