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 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
|
<html>
<HEAD>
<TITLE>Zone Nationnale</TITLE>
<link rel="stylesheet" type="text/css" href="z_nat.css">
</HEAD>
<Form method="POST" action="z_nat.php">
<div id="cadre1">
<table align=center>
<TR>
<TD>Num Zone</TD>
<TD>
<input type=texte size=10 name="num">
</TD>
<TD>Libelle Zone</TD>
<TD>
<input type=texte size=10 name="libelle">
</TD>
</TR>
</table>
</div>
<div id="cadre2">
<table align=center border="1" cellcpacing="0" cellpading="0">
<?php
if (@$_POST['action']=="selection")
{if (($_POST['num']=="") && ($_POST['libelle']==""))
{
mysql_connect("127.0.0.1","root","") or die("erreur de connexion au serveur!!");
mysql_select_db("gestfact") or die ("\n erreue de connexion a la base!!");
$result=mysql_query('select * from zones_nationales')or die(mysql_error());
if (!(mysql_fetch_row($result)))
{
echo "Aucune valeur trouvee";
}
else
{
?>
<TR>
<TH>Code Zone</TH>
<TH>Libelle Zone</TH>
</TR>
<?
while($row=mysql_fetch_row($result))
{
$numero=$row[0];
$nom=$row[1];
echo "<TR>
<TD>$numero</TD>
<TD>$nom</TD>
</TR>";
}
}
}
mysql_close();
}
else
{
if (@$_POST['action']=="modification")
{
if ($_POST['num']=="")
{
echo "modification impossible : veuillez entrer le numéro de la zone";
}
else
{
mysql_connect("127.0.0.1","root","") or die("erreur de connexion au serveur!!");
mysql_select_db("gestfact") or die ("\n erreue de connexion a la base!!");
$result=mysql_query('update zones_nationales set libelle_zone="'.$_POST['libelle'].'" where num_zone="'.$_POST['num'].'"')or die(mysql_error());
if($result==1)
{ echo "modification effectuée avec succées";}
else { echo "modification impossible!!!";}
}
}
?>
</table>
</div>
<div id="cadre3">
<table align=center>
<TR>
<TD>
<button type=submit name="action" value=selection><img src="C:\atteindre.gif></boutton>
</TD>
<TD>
<button type=submit name="action" value=selection><img src="C:\modifier.gif></boutton>
</TD> </TR>
</table>
</div>
</form>
</html> |
Partager