68 lines
1.9 KiB
PHP
Executable File
68 lines
1.9 KiB
PHP
Executable File
<?php
|
|
session_start();
|
|
$idcateg=$HTTP_POST_VARS["idcateg"];
|
|
$idfamille=$HTTP_POST_VARS["idfamille"];
|
|
$idprod=$HTTP_POST_VARS["idprod"];
|
|
$idprix=$HTTP_POST_VARS["idprix"];
|
|
$prix=$HTTP_POST_VARS["prix"];
|
|
$qteprod=$HTTP_POST_VARS["qteprod"];
|
|
$marge=$HTTP_POST_VARS["marge"];
|
|
$action=$HTTP_POST_VARS["action"];
|
|
?>
|
|
<html>
|
|
<head>
|
|
</head>
|
|
|
|
<body>
|
|
|
|
<div align="center">
|
|
<table border=1>
|
|
<tr>
|
|
<td colspan=2 align="center">
|
|
<h1>Site Marchand Airtria</h1>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan=2 align="center">
|
|
<br><br><h1>Gestion des produits</h1>
|
|
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<?php
|
|
|
|
require("../connexion.php");
|
|
$conn = mysql_connect($host, $user, $password);
|
|
mysql_select_db($bdd) or die("Impossible d'ouvrir la base de donnee $bdd");
|
|
|
|
if ($action=='supprimer')
|
|
{
|
|
$requete4 = "delete from prix where idprix='$idprix'";
|
|
$result4=mysql_query($requete4) or die ("Erreur SQL :$requete<br>".mysql_error()."...");
|
|
print "Prix supprimé<br>";
|
|
} else {
|
|
|
|
|
|
|
|
$requete3 = "update prix set
|
|
prix='$prix',
|
|
qteprod='$qteprod',
|
|
marge='$marge'
|
|
where
|
|
idprix='$idprix'";
|
|
$result3=mysql_query($requete3) or die ("Erreur SQL :$requete<br>".mysql_error()."...");
|
|
|
|
?>
|
|
<br><br>
|
|
Prix num <?php print $idprix ?> modifié.
|
|
<br>
|
|
<br>
|
|
|
|
<?php
|
|
}
|
|
?>
|
|
<a href="detprod.php?loguer=oui&idprod=<?php print $idprod?>&idfamille=<?php print $idfamille?>&idcateg=<?php print $idcateg?>">Retour</a>
|
|
</div>
|
|
</body>
|
|
</html>
|