J'aimerai pouvoir effacer une ligne d'une base de données dans la table "requests"
ca ne marche pas snif mais je pense que ca doit être dû au isset
<?php
include "modules/adodb/adodb.inc.php";
include "config/config.php";
// Connexion a la base de donnees
$db = NewADOConnection("oci8");
$cstr = "(DESCRIPTION=(ADDRESS=(PROTOCOL=$PROTOCOL)(HOST=$HOST)(PORT=$PORT))(CONNECT_DATA=(SID=$SID)))";
$db->Connect($cstr, $USER, $PWD);
if (isset($_POST["choice"]) && ($_POST["delete"]) )
{
$choice=$_POST["choice"];
$db->Execute("DELETE FROM requests WHERE idrequest= $choice" );
}
$req = "select distinct processes.heading, processes.idprocess from processes, requests where requests.idprocess=processes.idprocess order by processes.heading ASC ";
$res=$db->Execute($req);
?>
<table>
<td>
<tr>
<td><label for="pros2">Veuillez sélectionner le <font COLOR="#39C0F"><em>processus</em></font> concerné :</label></td>
<td><select name="pros2" id="id_pros2" onChange="submit()">
<option>-- Choisissez --</option>
<?php
while ($data=$res->FetchRow()){
?>
<option value="<?php echo $data[1]?>" <?php if($_POST['pros2']==$data[1]){echo "selected";} ?>><?php echo $data[0]?></option>
<?php
}
?>
</select>
</td>
</tr>
</td>
<br>
<br>
<?php
if(isset($_POST['pros2'])&& $_POST['pros2']!="")
{
$req = "select distinct procedures.heading, procedures.idprocedure from procedures, requests where requests.idprocess='".$_POST['pros2']."' and procedures.idprocedure=requests.idprocedure order by procedures.heading ASC" ;
$res=$db->Execute($req);
?>
<td>
<tr>
<td><label>Veuillez sélectionner la <font COLOR="#39C0F"><em>procédure</em></font> concernée :</label></td>
<td><select name="prod2" id="id_prod2" onChange="submit()">
<option>-- Choisissez --</option>
<?php
while ($data=$res->FetchRow()){
?>
<option value="<?php echo $data[1]?>" <?php if($_POST['prod2']==$data[1]){echo "selected";} ?>><?php echo $data[0]?></option>
<?php
}
?>
</select>
</td>
</tr>
</td>
<?php
}
?>
<br>
<br>
<?php
if(isset($_POST['prod2']) && $_POST['prod2']!="")
{
$req = "SELECT * FROM requests WHERE idprocedure= '".$_POST['prod2']."' ORDER BY idrequest ASC " ;
$res=$db->Execute($req);
?>
<br>
<br>
<table cellspacing=2 BORDER=1 bordercolor="#0099FF" cellpadding=2>
<tr>
<td valign="middle" align "center" width="300">Date</td>
<td valign="middle" align "center" width="300">Page</td>
<td valign="middle" align "center" width="300">Chapitre</td>
<td valign="middle" align "center" width="300">Paragraphe</td>
<td valign="middle" align "center" width="300">Libellé</td>
<td valign="middle" align "center" width="300">Supprimer</td>
</tr>
<?php
while ($data=$res->FetchRow()){
?>
<br>
<tr>
<td valign="middle" align "center" width="300" value="<?php echo $data[0]?>" ><?php echo $data[5]?><?php echo $data[6]?><?php echo $data[7]?></td>
<td valign="middle" align "center" width="300" value="<?php echo $data[0]?>" ><?php echo $data[1]?></td>
<td valign="middle" align "center" width="300" value="<?php echo $data[0]?>" ><?php echo $data[2]?></td>
<td valign="middle" align "center" width="300" value="<?php echo $data[0]?>" ><?php echo $data[3]?></td>
<td valign="middle" align "center" width="300" value="<?php echo $data[0]?>" ><?php echo $data[4]?></td>
<td><input type="radio" name="choice" value="<?php echo $data[0]?>"></td>
</tr>
<?php
}
?>
</select>
<?php
}
?>
</table>
</form>
<br>
<br>
<tr>
<td><center><input type="submit" name="delete" value="Supprimer le processus"><center></td>
</tr>
</html>
bbk91
CDLT
Configuration: Windows XP
Internet Explorer 6.0