" />
$message ="la collection " . $resultatscollections['nom_collection'] . " a été ";
$message= "la collection " . $_POST['nom_collection'] . " a été ";
if (isset($_POST["action"])) { $action = $_POST["action"]; }
Modifier
$_POST['nom_collection']
if (isset($_POST['collection_id'])) { $collection_id=$_POST['collection_id']; } a la ligne $req_collections = mysql_query("select* FROM collections WHERE collection_id='$collection_id'"); je te redonne le nouveau code des 2 pages: (avec surement beaucoup de fautes get/post) <code> //action.php <? $action=$_POST['action']; //initialisation $message="la collection " . $_POST['nom_collection'] . " a été "; if ($action =="modifier") { $requeteMYSQL="UPDATE ... $message .=" modifiée."; } if ($action =="ajouter") { $requeteMYSQL= "INSERT INTO .. $message .=" ajoutée."; } if ($action =="supprimer") { $requeteMYSQL= "DELETE FROM ... $message .=" supprimée."; } $message .=" Merci de votre collaboration."; //alimentation de la base $connexion=mysql_connect('localhost', 'root',''); mysql_select_db('db', $connexion); ?> <html><head></head> <? //message de confirmation echo $message; ?> </html>
//formulaire.php <? $connexion = mysql_connect('localhost', 'root', ''); mysql_select_db('bd', $connexion); if (isset($_POST['collection_id'])) { $collection_id=$_POST['collection_id']; } if (isset($_GET["action"])) { $action = $_GET["action"]; } $req_collections = mysql_query("select* FROM collections WHERE collection_id='$collection_id'"); $req_univers = mysql_query("select* FROM univers "); $univers_id['univers_id']=""; mysql_close($connexion); ?> <html><head></head> <? //recuperer les donnees $resultatscollections =mysql_fetch_array($req_collections); //insertion des donnees ?> <form action="actions_collections.php" method="post"> " /> nom de la collection : "> "> </form></html>
Modifier
if (isset($_POST['collection_id'])) { $collection_id= $_POST['collection_id']; }
if (isset($_GET['collection_id'])) { $collection_id=$_GET['collection_id']; }
</gras>" />
" /> ou " />
if (isset($_GET["var"])) { $var = $_GET["var"]; } else if (isset($_POST["var"])) { $var = $_POST["var"]; }
if ($action =="modifier") { $requeteMYSQL="UPDATE collections SET nom_collection='$nom_collection', univers_id='$univers_id' WHERE collection_id='$collection_id'"; $message .=" modifiée."; }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<form action="actions_collections.php" method="post"> " /> " /> " /> nom de la collection : "> "> </form>
$collection_id = $_POST["collection_id"]; $univers_id = $_POST["univers_id"];
$req_collections = mysql_query("select* FROM collections WHERE collection_id='$collection_id'");
//action.php <? $action=$_POST['action']; $collection_id=$_POST['collection_id']; $univers_id=$_POST['univers_id']; $nom_collection=$_POST['nom_collection']; //initialisation $message="la collection " . $_POST['nom_collection'] . " a été "; if ($action =="modifier") { $requeteMYSQL="UPDATE collections SET nom_collection='$nom_collection', univers_id='$univers_id' WHERE collection_id='$collection_id'"; $message .=" modifiée."; } if ($action =="ajouter") { $requeteMYSQL= "INSERT INTO collections VALUES('','$nom_collection', '$univers_id')"; $message .=" ajoutée."; } if ($action =="supprimer") { $requeteMYSQL= "DELETE FROM collections WHERE collection_id='$collection_id'"; $message .=" supprimée."; } $message .=" Merci de votre collaboration."; //alimentation de la base $connexion=mysql_connect('localhost', 'root',''); mysql_select_db('db', $connexion); ?> <html><head></head> <? //message de confirmation echo $message; ?> </html>
<? $connexion = mysql_connect('localhost', 'root', ''); mysql_select_db('bd', $connexion); if (isset($_GET['collection_id'])) { $collection_id=$_GET['collection_id']; } if (isset($_GET["action"])) { $action = $_GET["action"]; } $req_collections = mysql_query("select* FROM collections WHERE collection_id='$collection_id'"); $req_univers = mysql_query("select* FROM univers "); $univers_id['univers_id']=""; mysql_close($connexion); ?> <html><head></head> <? //recuperer les donnees $resultatscollections =mysql_fetch_array($req_collections); //insertion des donnees ?> <form action="actions_collections.php" method="post">S " /> " /> " /> " /> nom de la collection : "> univers : <select name="univers"> <? //affichage des univers $selection=""; for($n=0;$n<mysql_num_rows($req_univers);$n++) { $resultatsunivers =mysql_fetch_array($req_univers); $selection=""; if($resultatsunivers['univers_id'] == $resultatscollections['univers_id']) { $selection = " selected"; } else { $selection=""; } echo"<option value='" . $resultatsunivers['univers_id'] ."'" . $selection . ">" . $resultatsunivers['nom_univers'] ."</option>"; } ?> </select> "> </form></html>
if (isset($_GET['collection_id'])) { $collection_id=$_GET['collection_id']; }
if (isset($_GET['collection_id'])) { $collection_id=$_GET['collection_id']; } else $collection_id = 0;
" />
$connexion=mysql_connect('localhost', 'root',''); mysql_select_db('db', $connexion); mysql_query($requeteMYSQL) or die ("Erreur MySQL : " . mysql_error()); //Envoie des infos à la base mysql_close($connexion); // fermeture de la connection