Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<? echo "Liste des rats trouvés dans la base de données: "; echo " "; echo " "; echo ""; $db = mysql_connect('localhost', 'root', 'pouet'); mysql_select_db('oye',$db); // suppression if(isset($_POST['sub_form'])) {$sql "DELETE FROM rat WHERE id_rat ".$_POST['supp']; $res = mysql_query($sql) or die (mysql_error()); echo "rat supprimé"; } echo " "; echo " "; $SQL = 'SELECT * FROM rat'; $req = mysql_query($SQL) or die('Erreur SQL ! '.$SQL.' '.mysql_error()); echo "<form method="post" action="{$_SERVER['PHP_SELF']}">"; while($data = mysql_fetch_assoc($req)) { echo "Identifiant : "." " ; echo "Nom : "."" ; echo "Sexe : "."" ; echo "Poids : "."" ; echo "Age : "."" ; echo "Couleur : ".""; echo ""." "; } // modifier if(isset($_POST['sub_form2'])) {$sql2 "UPDATE rat SET nom_rat '".$data['nom_rat']."', sexe_rat = '".$data['sexe_rat']."', poids_rat = '".$data['poids_rat']."', age_rat = '".$data['age_rat']."', couleur_rat = '".$data['couleur_rat']."' WHERE id_rat = ".$_POST['supp']; $res2 = mysql_query($sql2) or die (mysql_error()); echo "rat modifié"; } echo ""; echo ""; echo "</form>"; echo "ajout d un rat"; echo "</form>"; ?>
while($data = mysql_fetch_assoc($req)) { echo "Identifiant : "." " ; echo "Nom : "."" ; echo "Sexe : "."" ; echo "Poids : "."" ; echo "Age : "."" ; echo "Couleur : ".""; echo ""." "; } // modifier if(isset($_POST['sub_form2'])) {$sql2 "UPDATE rat SET nom_rat '".$POST['nom']."', sexe_rat = '".$POST['sexe']."', poids_rat = '".$POST['poids']."', age_rat = '".$POST['age']."', couleur_rat = '".$POST['couleur']."' WHERE id_rat = ".$_POST['supp']; $res2 = mysql_query($sql2) or die (mysql_error()); echo "rat modifié"; }
<? echo "Liste des rats trouvés dans la base de données: "; echo " "; echo " "; echo ""; $db = mysql_connect('localhost', 'root', 'pouet'); mysql_select_db('oye',$db); // suppression if(isset($_POST['sub_form'])) {$sql "DELETE FROM rat WHERE id_rat ".$_POST['supp']; $res = mysql_query($sql) or die (mysql_error()); echo "rat supprimé"; } // modifier if(isset($_POST['sub_form2'])) {$sql2 "UPDATE rat SET nom_rat '".$_POST['nom']."', sexe_rat = '".$_POST['sexe']."', poids_rat = '".$_POST['poids']."', age_rat = '".$_POST['age']."', couleur_rat = '".$_POST['couleur']."' WHERE id_rat = ".$_POST['supp']; $res2 = mysql_query($sql2) or die (mysql_error()); echo "rat modifié"; } echo " "; echo " "; $SQL = 'SELECT * FROM rat'; $req = mysql_query($SQL) or die('Erreur SQL ! '.$SQL.' '.mysql_error()); echo "<form method="post" action="{$_SERVER['PHP_SELF']}">"; while($data = mysql_fetch_assoc($req)) { echo "Identifiant : "." " ; echo "Nom : "."" ; echo "Sexe : "."" ; echo "Poids : "."" ; echo "Age : "."" ; echo "Couleur : ".""; echo ""." "; } echo ""; echo ""; echo "</form>"; echo "ajout d un rat"; echo "</form>"; ?>