voici mon code:
<html?gt;
<head>
<title>brigade</title>
</head>
<body><font face="arial">
<?php
include(‘f_oracle2.php’);
$table="brigade";
ora_on();
if (!$conn)
{
echo"<center><h4>Impossible de se connecter à la base de données.</h4></center>";
exit;
};
echo “<table align=‘center’><tr><td>
<H2>Table brigade</H2>
<li><A HREF=‘unit_brg.php?task=1’>Ajouter des brigades</A></li><br>
<li><A HREF=‘unit_brg.php?task=2’>Recherche des brigades</A></li>
</td></tr></table>
<hr color=’#000000’>”;
if (isset($_GET[‘task’]))
switch($_GET[‘task’])
{
case 1: // ajouter une entrée dans la base
if (isset($_POST[‘add’]))
{
$code_brg=$_POST['code_brg'];
$code_unit=$_POST['code_unit'];
$desig_brg=$_POST['desig_brg'];
$adr_brg=$_POST['adr_brg'];
$tel_brg=$_POST['tel_brg'];
$fax_brg=$_POST['fax_brg'];
$lb_unit=$_POST['lb_unit'];
$adr_unit=$_POST['adr_unit'];
$tel_unit=$_POST['tel_unit'];
$fax_unit=$_POST['fax_unit'];
$req="INSERT INTO unite VALUES ('$code_unit','$lb_unit','$adr_unit','$tel_unit','$fax_unit')";
$res=ora_do( $conn, $req);
if ($res)
{
echo"<center><h4>Entrée ajoutée</h4></center>";
}
else
{
echo"<center><h4>Erreur</h4></center>";
};
$req="INSERT INTO brigade VALUES ('$code_brg','$code_unit','$desig_brg','$adr_brg','$tel_brg','$fax_brg')";
$res=ora_do( $conn, $req);
if ($res)
{
echo"<center><h4>Entrée ajoutée</h4></center>";
}
else
{
echo"<center><h4>Erreur</h4></center>";
};
};
echo"<table width='0%' cellpadding='5' cellspacing='0' border='0' align='center' bgcolor='buttonface'>
<form name='ajouter' action='unit_brg.php?task=1' method='post'>
<tr>
<td colspan='2' align='center'><h2>Ajouter une entrée</h2></td>
</tr>
<tr>
<td align='right'>code_unit</td>
<td>
<select name=\"code_unit\">
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
</select></td>
</tr>
<tr>
<td align='right'>lb_unit</td>
<td><input type='text' name='lb_unit'></td>
</tr>
<tr>
<td align='right'>adr_unit</td>
<td>
<textarea rows='5' name='adr_unit' cols='35'>
</textarea>
</td>
<tr>
<td align='right'>tel_unit</td>
<td><input type='text' name='tel_unit'></td>
</tr>
<tr>
<td align='right'>fax_unit</td>
<td><input type='text' name='fax_unit'></td>
</tr>
<tr>
<td align='right'>code_brigade</td>
<td><input type='text' name='code_brg'></td>
</tr>
<tr>
<td align='right'>desig_brigade</td>
<td><input type='text' name='desig_brg'></td>
</tr>
<tr>
<td align='right'>adr_brigade</td>
<td>
<textarea rows='5' name='adr_brg' cols='35'>
</textarea>
</td>
<tr>
<td align='right'>tel_brigade</td>
<td><input type='text' name='tel_brg'></td>
</tr>
<tr>
<td align='right'>fax_brigade</td>
<td><input type='text' name='fax_brg'></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type='submit' name='add' value='Ajouter'></td>
</tr>
</form>
</table>";
break;
case 2: // recherche dans la base
echo"<table width='0%' cellpadding='5' cellspacing='0' border='0' align='center' bgcolor='buttonface'>
<form name='recherche' action='unit_brg.php?task=2' method='post'>
<tr>
<td colspan='2' align='center'><h2>Rechercher</h2></td>
</tr>
<tr>
<td align='right'>code_unit</td>
<td>
<select name=\"code_unit\">
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
</select></td>
</tr>
<tr>
<td align='right'>lb_unit</td>
<td><input type='text' name='lb_unit'></td>
</tr>
<tr>
<td align='right'>adr_unit</td>
<td>
<textarea rows='5' name='adr_unit' cols='35'>
</textarea>
</td>
<tr>
<td align='right'>tel_unit</td>
<td><input type='text' name='tel_unit'></td>
</tr>
<tr>
<td align='right'>fax_unit</td>
<td><input type='text' name='fax_unit'></td>
</tr>
<tr>
<td align='right'>code_brigade</td>
<td><input type='text' name='code_brg'></td>
</tr>
<tr>
<td align='right'>desig_brigade</td>
<td><input type='text' name='desig_brg'></td>
</tr>
<tr>
<td align='right'>adr_brigade</td>
<td>
<textarea rows='5' name='adr_brg' cols='35'>
</textarea>
</td>
<tr>
<td align='right'>tel_brigade</td>
<td><input type='text' name='tel_brg'></td>
</tr>
<tr>
<td align='right'>fax_brigade</td>
<td><input type='text' name='fax_brg'></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type='submit' name='op2' value='Rechercher'></td>
</tr>
</form>
</table> <br>";
if (isset($_POST['op2']))
{
$req="SELECT * FROM brigade WHERE code_unit LIKE '%$code_unit%'";
if (isset($_POST['code_unit']))
{ $code_unit=$_POST['code_unit'];
$req.="AND code_unit LIKE '%$code_unit%'";
};
if (isset($_POST['code_brg']))
{ $code_brg=$_POST['code_brg'];
$req.="AND code_brg LIKE '%$code_brg%'";
};
$req.=" ORDER BY code_unit";
$req1="SELECT * FROM unite WHERE code_unit LIKE '%$code_unit%'";
if (isset($_POST['lb_unit']))
{ $lb_unit=$_POST['lb_unit'];
$req1.="AND lb_unit LIKE '%$lb_unit%'";
};
$res=ora_req($req);
$res1=ora_req($req1);
//verifier the res
echo"<table width=‘0%’ cellpadding=‘5’ cellspacing=‘2’ border=‘2’ align=‘center’>";
echo"<tr>
<td bgcolor=‘buttonface’ align=‘center’><b>code_unit</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>lb_unit</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>adr_unit</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>tel_unit</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>fax_unit</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>code_brg</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>desig_brg</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>adr_brg</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>tel_brg</b></td>
<td bgcolor=‘buttonface’ align=‘center’><b>fax_brg</b></td>
<td> </td><td> </td></tr>";
do{
ora_fetch_tab($res, $val);
$code_brg= $val[0];
$code_unit= $val[1];
$desig_brg= $val[2];
$adr_brg= $val[3];
$tel_brg = $val[4];
$fax_brg = $val[5];
ora_fetch_tab($res1, $val);
//$code_unit= $val[0];
$lb_unit= $val[1];
$adr_unit= $val[2];
$tel_unit = $val[3];
$fax_unit = $val[4];
echo"<tr><td bgcolor=‘buttonface’>".$code_unit."</td><td bgcolor=‘buttonface’>".$lb_unit."</td>
<td bgcolor=‘buttonface’>".$adr_unit."</td> <td bgcolor=‘buttonface’>".$tel_unit."</td>
<td bgcolor=‘buttonface’>".$fax_unit."</td><td bgcolor=‘buttonface’>".$code_brg."</td>
<td bgcolor=‘buttonface’>".$desig_brg."</td><td bgcolor=‘buttonface’>".$adr_brg."</td>
<td bgcolor=‘buttonface’>".$tel_brg."</td><td bgcolor=‘buttonface’>".$fax_brg."</td>
<td bgcolor=‘buttonface’><A HREF=‘unit_brg.php?task=4&code_unit=$code_unit&lb_unit=$lb_unit&adr_unit=$adr_unit
&tel_unit=$tel_unit&fax_unit=$fax_unit&code_brg=$code_brg&desig_brg=$desig_brg
&adr_brg=$adr_brg&tel_brg=$tel_brg&fax_brg=$fax_brg’>modifier</A></td>
<td bgcolor=‘buttonface’><A HREF=‘unit_brg.php?task=3&code_brg=$code_brg’>supprimer</A></td>
</tr>";
}while (ora_fetch($res,$res1));
echo"</table><br>";
};
break;
case 3: // test de suppression des resultats
$code_brg=$_GET[‘code_brg’];
echo"<table align=‘center’><tr><td>Vous êtes sûr ?<li>
<A HREF=‘unit_brg.php?task=5&code_brg=$code_brg’>OUI<A/></li><li><A HREF=‘java script:history.back();’>Annuler<A/></li>
</td></tr></table>";
break;
case 4: // modifier des resultats
if (isset($_POST['op4']))
{
$code_brg=$_POST['code_brg'];
// $code_unit=$_POST['code_unit'];
$desig_brg=$_POST['desig_brg'];
$adr_brg=$_POST['adr_brg'];
$tel_brg=$_POST['tel_brg'];
$fax_brg=$_POST['fax_brg'];
// $lb_unit=$_POST['lb_unit'];
// $adr_unit=$_POST['adr_unit'];
// $tel_unit=$_POST['tel_unit'];
// $fax_unit=$_POST['fax_unit'];
$req="UPDATE brigade SET
adr_brg='$adr_brg', tel_brg='$tel_brg',fax_brg='$fax_brg' WHERE code_brg ='$code_brg'";
$cur=ora_op($req);
if ($cur)
{
echo"<center><h4>Entrée modifiée</h4></center>";
}
else
{
echo"<center><h4>Erreur</h4></center>";
};
}else
{
$code_brg=$_GET['code_brg'];
$code_unit=$_GET['code_unit'];
$desig_brg=$_GET['desig_brg'];
$adr_brg=$_GET['adr_brg'];
$tel_brg=$_GET['tel_brg'];
$fax_brg=$_GET['fax_brg'];
$lb_unit=$_GET['lb_unit'];
$adr_unit=$_GET['adr_unit'];
$tel_unit=$_GET['tel_unit'];
$fax_unit=$_GET['fax_unit'];
};
echo"<table width='0%' cellpadding='5' cellspacing='0' border='0' align='center' bgcolor='buttonface'>
<form name='modifier' action='unit_brg.php?task=4' method='post'>
<tr>
<td colspan='2' align='center'><h2>Modifier</h2></td>
</tr>
<tr>
<td align='right'>code_unit</td>
<td><input type='text' readonly name='code_unit' value=$code_unit></td>
</tr>
<tr>
<td align='right'>lb_unit</td>
<td><input type='text' name='lb_unit' value=$lb_unit></td>
</tr>
<tr>
<td align='right'>adr_unit</td>
<td>
<textarea rows='5' name='adr_unit' cols='35'>$adr_unit
</textarea>
</td>
<tr>
<td align='right'>tel_unit</td>
<td><input type='text' name='tel_unit' value=$tel_unit></td>
</tr>
<tr>
<td align='right'>fax_unit</td>
<td><input type='text' name='fax_unit' value=$fax_unit></td>
</tr>
<tr>
<td align='right'>code_brigade</td>
<td><input type='text' name='code_brg' value=$code_brg></td>
</tr>
<tr>
<td align='right'>desig_brigade</td>
<td><input type='text' name='desig_brg' value=$desig_brg></td>
</tr>
<tr>
<td align='right'>adr_brigade</td>
<td>
<textarea rows='5' name='adr_brg' cols='35'>$adr_brg
</textarea>
</td>
<tr>
<td align='right'>tel_brigade</td>
<td><input type='text' name='tel_brg' value=$tel_brg></td>
</tr>
<tr>
<td align='right'>fax_brigade</td>
<td><input type='text' name='fax_brg' value=$fax_brg></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<input type='submit' name='op4' value='Modifier'></td>
</tr>
</form>
</table>";
break;
case 5:
$code_brg=$_GET[‘code_brg’];
$req=“DELETE FROM $table WHERE code_brg = ‘$code_brg’”;
$res=ora_op($req);
if ($res)
{
echo"<center><h4>Entrée supprimée</h4></center>";
}
else
{
echo"<center><h4>Erreur</h4></center>";
};
break;
default:
break;
}
ora_off();
?>
</font>
</body>
</html?gt;
:??: le pb est que j ne peux modifier que deux champs pas plus(
$req=“UPDATE brigade SET
adr_brg=’$adr_brg’, tel_brg=’$tel_brg’,fax_brg=’$fax_brg’ WHERE code_brg =’$code_brg’”
ca ne marche pas
mais si j ecris ce code( $req=“UPDATE brigade SET
tel_brg=’$tel_brg’,fax_brg=’$fax_brg’ WHERE code_brg =’$code_brg’”;
le tel_brg et fax_brg sont modifiées :??:
Et l’autre question c’est
que j veux savoir si il ya une fonction pour l’affichage à partir de deux tables(jointure de 02 tables) et merci d’avance.
:’(
