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
|
<?php
include('connection.php');
include('index.php');
$Requete = "SELECT * FROM imagereduite";
$Resultat = mysql_query($Requete);
while (list($NumImage,$NomImage,$ComImage,$LienImage,$ImageAgra,$NumRubr) = mysql_fetch_array($Resultat))
{
echo'<form name="formulaire" action="photo.php" method="post">
<input name="txt_nom" type="text" value="'.$NomImage.'">
<input name="cache" type="hidden" value="'.$NumImage.'">
<input name="com" type="hidden" value="'.$ComImage.'">
<input name="lien" type="hidden" value="'.$LienImage.'">
<input name="rubr" type="hidden" value="'.$NumRubr.'">
<input type="hidden" name="imagea" value="'.$ImageAgra.'">
<input type="hidden" name="rubr" value="'.$NumRubr.'">
<input name="suite" type="hidden" value="1">
<input name="modifier" type="submit" value="Modification ou Suppression">
</form>';
}
if ($_POST['suite'] == 1)
{
$numero = $_POST['cache'];
$commentaire = $_POST['com'];
$lien = $_POST['lien'];
$agrandie = $_POST['imagea'];
$rubrique = $_POST['rubr'];
$nomimage = $_POST['txt_nom'];
$RequeteSelect = ("SELECT * FROM imagereduite WHERE NumeroImage = '".$numero."'");
$ResultatReq = mysql_query($RequeteSelect);
?>
<form name="update" method="post" action="photo.php">
Numero Image : <input type="text" name="numimage" value="<?php echo $numero;?>"><br><br>
Nom Image : <input type="text" name="nomimage" value="<?php echo $nomimage;?>"><br><br>
Commentaire Image : <input type="text" name="comimage" value="<?php echo $commentaire;?>"><br><br>
Lien Image : <input type="text" name="lienimage" value="<?php echo $lien;?>"><br><br>
Image Agrandie : <input type="text" name="image" value="<?php echo $agrandie;?>"><br><br>
Numero Rubrique: <input type="text" name="num" value="<?php echo $rubrique;?>"><br><br>
<input type="submit" name="bt_modif" value ="Modifier">
<input name="update" type="hidden" value ="2">
</form>
<form name="Delete" action="photo.php" method="post">
<input type="submit" value="Suppression" />
<input type="text" value="<?php echo $numero;?>" name="suppr" />
</form>
<?php
}
if ($_POST['update'] == 2)
{
$num = $_POST['numimage'];
$nom = $_POST['nomimage'];
$commentaire = $_POST['comimage'];
$lien = $_POST['lienimage'];
$agrandi = $_POST['image'];
$numero = $_POST['num'];
$ReqUpdate = "UPDATE imagereduite SET NomImage = '".$nom."', CommentaireImage ='".$commentaire."', LienImage = '".$lien."', ImageAgrandie = '".$agrandi."', NumeroRubrique = '".$numero."' WHERE NumeroImage = '".$num."'";
$ResultatUpdate = mysql_query($ReqUpdate);
echo 'Votre modification a bien été prise en compte';
}
if (isset ($_POST['suppr']))
{
$num = $_POST['suppr'];
$DeleteImage = "DELETE FROM imagereduite WHERE NumeroImage = '".$num."'";
$ResultatImage = mysql_query($DeleteImage);
echo 'Votre suppression a bien été prise en compte';
} |
Partager