$select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); for($nb=0;$nb<$total;$nb++) { $row = mysql_fetch_array($result); $id[$nb] = $row ["id"]; $email[$nb] = $row ["email"]; $pseudo[$nb] = $row ["pseudo"]; $pass[$nb] = $row ["pass"]; $ville[$nb] = $row ["ville"]; }
///1ier ligne: les titre du tableau echo "\"; echo \"---- \"; echo \""; echo "ID"; echo ", \"; echo \""; echo "PSEUDO"; echo ", \"; echo \""; echo "EMAIL"; echo ", \"; echo \""; echo "PASS"; echo ", \"; echo \""; echo "VILLE"; echo ", \"; echo \"\"; ///boucle qui génére une ligne par réponse trouvé for($nb=0;$nb<$total;$nb++) { echo \"---- \"; echo \""; echo "$id[$nb]"; echo ", \"; echo \""; echo "$pseudo[$nb]"; echo ", \"; echo \""; echo "$email[$nb]"; echo ", \"; echo \""; echo "$pass[$nb]"; echo ", \"; echo \""; echo "$ville[$nb]"; echo ", \"; echo \"\"; } echo " ";
<?php // Connexiion a l abase de données mysql_connect("xxx", "xxx", "xxx") or die(mysql_error()); mysql_select_db("membre") or die(mysql_error()); //Recup du formulaire $pseudo=$_REQUEST['pseudo']; $email=$_REQUEST['email']; $pass=$_REQUEST['pass']; $ville=$_REQUEST['ville']; //insertion dans la base de données mysql_query("INSERT INTO membre VALUES('','$email','$pseudo','$pass','$ville');"); //on réafiche les données $select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); ///1ier ligne: les titre du tableau echo "\"; echo \"---- \"; echo \""; echo "id"; echo ", \"; echo \""; echo "pseudo"; echo ", \"; echo \""; echo "email"; echo ", \"; echo \""; echo "pass"; echo ", \"; echo \""; echo "ville"; echo ", \"; echo \"\"; ///boucle qui génère une ligne par réponse for($nb=0;$nb<$total;$nb++) { $row = mysql_fetch_array($result); $id = $row [\"id\"]; $email = $row [\"email\"]; $pseudo = $row [\"pseudo\"]; $pass = $row [\"pass\"]; $ville = $row [\"ville\"]; echo \"---- \"; echo \""; echo "$id"; echo ", \"; echo \""; echo "$pseudo"; echo ", \"; echo \""; echo "$email"; echo ", \"; echo \""; echo "$pass"; echo ", \"; echo \""; echo "$ville"; echo ", \"; echo \"\"; } echo " "; //Fermeture de la base de données mysql_close(); ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php // Make a MySQL Connection mysql_connect("xxxx", "xxxx", "xxxxx") or die(mysql_error()); mysql_select_db("membre") or die(mysql_error()); $result = mysql_query("SELECT * FROM membre") or die(mysql_error()); $select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); for($nb=0;$nb<$total;$nb++) { $row = mysql_fetch_array($result); $id[$nb] = $row ["id"]; $email[$nb] = $row ["email"]; $pseudo[$nb] = $row ["pseudo"]; $pass[$nb] = $row ["pass"]; $ville[$nb] = $row ["ville"]; } ///1ier ligne: les titre du tableau echo "\"; echo \"---- \"; echo \""; echo "id"; echo ", \"; echo \""; echo "pseudo"; echo ", \"; echo \""; echo "email"; echo ", \"; echo \""; echo "pass"; echo ", \"; echo \""; echo "ville"; echo ", \"; echo \"\"; ///boucle qui génére une ligne par réponse trouvé for($nb=0;$nb<$total;$nb++) { echo \"---- \"; echo \""; echo "$id[$nb]"; echo ", \"; echo \""; echo "$pseudo[$nb]"; echo ", \"; echo \""; echo "$email[$nb]"; echo ", \"; echo \""; echo "$pass[$nb]"; echo ", \"; echo \""; echo "$ville[$nb]"; echo ", \"; echo \"\"; } echo " "; ?>
$select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); for($nb=0;$nb<$total;$nb++) { $row = mysql_fetch_array($result); $id = $row ["id"]; $email = $row ["email"]; $pseudo = $row ["pseudo"]; $pass = $row ["pass"]; $ville = $row ["ville"]; echo "<tr>"; echo "<td>"; echo "$id"; echo "</td>"; echo "<td>"; echo "$pseudo"; echo "</td>"; echo "<td>"; echo "$email"; echo "</td>"; echo "<td>"; echo "$pass"; echo "</td>"; echo "<td>"; echo "$ville"; echo "</td>"; echo "</tr>"; } echo "</table>";
$result = mysql_query("SELECT * FROM membre") or die(mysql_error());
<?php // Make a MySQL Connection mysql_connect("XXX", "XXX", "XXX") or die(mysql_error()); mysql_select_db("membre") or die(mysql_error()); $select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); for($nb=0;$nb<$total;$nb++) { $row = mysql_fetch_array($result); $id = $row ["id"]; $email = $row ["email"]; $pseudo = $row ["pseudo"]; $pass = $row ["pass"]; $ville = $row ["ville"]; } ///1ier ligne: les titre du tableau echo "\"; echo \"---- \"; echo \""; echo "id"; echo ", \"; echo \""; echo "pseudo"; echo ", \"; echo \""; echo "email"; echo ", \"; echo \""; echo "pass"; echo ", \"; echo \""; echo "ville"; echo ", \"; echo \"\"; ///boucle qui génére une ligne par réponse trouvé for($nb=0;$nb<$total;$nb++) { echo \"---- \"; echo \""; echo "$id"; echo ", \"; echo \""; echo "$pseudo"; echo ", \"; echo \""; echo "$email"; echo ", \"; echo \""; echo "$pass"; echo ", \"; echo \""; echo "$ville"; echo ", \"; echo \"\"; } echo " "; ?>
<?php mysql_connect("xxx", "xxx", "xxx"); // Connexion à MySQL mysql_select_db("xxx"); // Sélection de la base devile.coding // On ajoute une entrée avec mysql_query REQUETTE mysql_query("INSERT INTO membre VALUES( '$id' ,'$email' ,'$pseudo' ,'$pass' ,'$passs' ,'$ville');"); // On ajoute une entrée avec mysql_query REQUETTE mysql_close(); //on ferme conexion sql ?> RECUPERE LES INFOS <?php // Make a MySQL Connection mysql_connect("xxx", "xxx", "xxx") or die(mysql_error()); mysql_select_db("membre") or die(mysql_error()); $result = mysql_query("SELECT * FROM membre") or die(mysql_error()); $select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); for($nb=0;$nb<$total;$nb++) { $row = mysql_fetch_assoc($result); echo "<tr>" ; $id[$nb] = $row ["id"]; $email[$nb] = $row ["email"]; $pseudo[$nb] = $row ["pseudo"]; $pass[$nb] = $row ["pass"]; $ville[$nb] = $row ["ville"]; echo "</tr>"; } ///1ier ligne: les titre du tableau echo "\"; echo \"---- \"; echo \""; echo "id"; echo ", \"; echo \""; echo "pseudo"; echo ", \"; echo \""; echo "email"; echo ", \"; echo \""; echo "pass"; echo ", \"; echo \""; echo "ville"; echo ", \"; echo \"\"; ///boucle qui génére une ligne par réponse trouvé for($nb=0;$nb<$total;$nb++) { echo \"---- \"; echo \""; echo "$id"; echo ", \"; echo \""; echo "$pseudo"; echo ", \"; echo \""; echo "$email"; echo ", \"; echo \""; echo "$pass"; echo ", \"; echo \""; echo "$ville"; echo ", \"; echo \"\"; } echo " "; ?>
<?php // Make a MySQL Connection mysql_connect("xxx", "xxx", "xxx") or die(mysql_error()); mysql_select_db("membre") or die(mysql_error()); // On ajoute une entrée avec mysql_query REQUETTE mysql_query("INSERT INTO membre VALUES( '$id' ,'$email' ,'$pseudo' ,'$pass' ,'$passs' ,'$ville');"); RECUPERE LES INFOS $select = "SELECT * FROM membre"; $result= mysql_query($select); $total = mysql_num_rows($result); ///1ier ligne: les titre du tableau echo "\"; echo \"---- \"; echo \""; echo "id"; echo ", \"; echo \""; echo "pseudo"; echo ", \"; echo \""; echo "email"; echo ", \"; echo \""; echo "pass"; echo ", \"; echo \""; echo "ville"; echo ", \"; echo \"\"; ///boucle qui génére une ligne par réponse trouvé for($nb=0;$nb<$total;$nb++) { echo \"---- \"; echo \""; echo "$id"; echo ", \"; echo \""; echo "$pseudo"; echo ", \"; echo \""; echo "$email"; echo ", \"; echo \""; echo "$pass"; echo ", \"; echo \""; echo "$ville"; echo ", \"; echo \"\"; } echo " "; ?>