$req=mysql_query($sql);//or die('Erreur SQL!<br>' .sql.'<br>'.mysql_error());
$req=mysql_query($sql) or die('Erreur SQL!<br>'.$sql.'<br>'.mysql_error());
$sql='SELECT id_direction,nomdirection FROM direction '; $req=mysql_query($sql);//or die('Erreur SQL!<br>' .sql.'<br>'.mysql_error());en dehors du select (au dessus) de la façon suivante.
<?php $sql='SELECT id_direction,nomdirection FROM direction '; $req=mysql_query($sql) or die('Erreur SQL!<br>'.$sql.'<br>'.mysql_error()); ?> <select name="id_direction" classe="texte" id="id_direction"> <option value="0">..select..</option> <?PHP while($row=mysql_fetch_array($req)) { echo'<option value= " '.$row['id_direction'].'"> '.$row['nomdirection'].'</option>'; } ?> </select>
Ceci est du code
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd]"> <html xmlns="[http://www.w3.org/1999/xhtml]"> <!-- DW6 --> <head> <!-- Copyright 2005 Macromedia, Inc. All rights reserved. --> <title>Page d'accueil</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" href="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_travel2.css" type="text/css" /> <script language="JavaScript" type="text/javascript"> <?PHP include('../gestions/mysqlconnec.php');?> //--------------- LOCALIZEABLE GLOBALS--------------- var d=new Date(); monthname= new Array("Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"); //Ensure correct for language. English is "January 1, 2004" var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear(); //--------------- END LOCALIZEABLE --------------- </script> </head> <body bgcolor="#C0DFFD"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr bgcolor="#3366CC"> </tr> <tr bgcolor="#3366CC"> <td height="64" colspan="3" id="tagline" valign="top" align="center"> </td> <td width="100%"> </td> </tr> <tr> <td colspan="7" bgcolor="#003366"><img src="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td> </tr> <tr bgcolor="#CCFF99"> <td colspan="7" id="dateformat" height="25"> <script language="JavaScript" type="text/javascript"> document.write(TODAY); </script> </td> </tr> <tr> <td colspan="7" bgcolor="#003366"><img src="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td> </tr> <tr> <td width="165" valign="top" bgcolor="#E6F3FF"> <table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation"> <tr> <td width="165" height="66"><p align="center"><strong><a href="file:///C|/Users/SOL INFO/Desktop/gestion/enregistrementservice.php">gestion d'un service </a></strong> </p> </tr> <tr> <td width="165"><p><a href="enregistrementformation.php" class="navText">gestion d'une formation </a></p> <p> </p></td> </tr> <tr> <td width="165"><p><a href="enregistrementparticipant.php" class="navText"> gestion des participants </a></p> <p> </p></td> </tr> <tr> <td width="165"><p> </p> <p><a href="enregistremendirection.php" class="navText">gestion des directions</a></p> <p> </p></td> </tr> </table> <div align="center"><strong><a href="pagedaccueil.php">ACCUEIL</a></strong><br /> <br /> <br /> <br /> </div></td> <td width="50"> </td> <td width="305" colspan="2" valign="top"><img src="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="305" height="1" border="0" /><br /> <br /> <br /> <p>Enregistrer service </p> <form name="form1" method="post" action="saveservice.php"> <p> <label></label> </p> <p>Nom service : <label> <input type="text" name="nomservice"/> </label> </p> <table width="200" border="0" align="center"> <tr> <td><label> <input type="submit" name="Submit" value="Enregistrer" /> </label></td> <td><label> <input type="reset" name="Submit2" value="Supprimer" /> </label></td> </tr> </table> <p> </p> </form> <form id="form2" name="form2" method="post" action="testservice.php"> <label> <input type="submit" name="Submit3" value="visualiser" /> </label> </form> </td> <td width="100%"> </td> </tr> </table> </body> </html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <!-- DW6 --> <head> <!-- Copyright 2005 Macromedia, Inc. All rights reserved. --> <title>Page d'accueil</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" href="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_travel2.css" type="text/css" /> <script language="JavaScript" type="text/javascript"> <?PHP include('../gestions/mysqlconnec.php');?> //--------------- LOCALIZEABLE GLOBALS--------------- var d=new Date(); monthname= new Array("Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"); //Ensure correct for language. English is "January 1, 2004" var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear(); //--------------- END LOCALIZEABLE --------------- </script> </head> <body bgcolor="#C0DFFD"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr bgcolor="#3366CC"> </tr> <tr bgcolor="#3366CC"> <td height="64" colspan="3" id="tagline" valign="top" align="center"> </td> <td width="100%"> </td> </tr> <tr> <td colspan="7" bgcolor="#003366"><img src="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td> </tr> <tr bgcolor="#CCFF99"> <td colspan="7" id="dateformat" height="25"> <script language="JavaScript" type="text/javascript"> document.write(TODAY); </script> </td> </tr> <tr> <td colspan="7" bgcolor="#003366"><img src="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td> </tr> <tr> <td width="165" valign="top" bgcolor="#E6F3FF"> <table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation"> <tr> <td width="165" height="66"><p align="center"><strong><a href="file:///C|/Users/SOL INFO/Desktop/gestion/enregistrementservice.php">gestion d'un service </a></strong> </p> </tr> <tr> <td width="165"><p><a href="enregistrementformation.php" class="navText">gestion d'une formation </a></p> <p> </p></td> </tr> <tr> <td width="165"><p><a href="enregistrementparticipant.php" class="navText"> gestion des participants </a></p> <p> </p></td> </tr> <tr> <td width="165"><p> </p> <p><a href="enregistremendirection.php" class="navText">gestion des directions</a></p> <p> </p></td> </tr> </table> <div align="center"><strong><a href="pagedaccueil.php">ACCUEIL</a></strong><br /> <br /> <br /> <br /> </div></td> <td width="50"> </td> <td width="305" colspan="2" valign="top"><img src="file:///C|/Program Files/Macromedia/Dreamweaver 8/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="305" height="1" border="0" /><br /> <br /> <br /> <p>Enregistrer service </p> <form name="form1" method="post" action="saveservice.php"> <p> <label></label> </p> <p>Nom service : <label> <input type="text" name="nomservice"/> </label> </p> <table width="200" border="0" align="center"> <tr> <td><label> <input type="submit" name="Submit" value="Enregistrer" /> </label></td> <td><label> <input type="reset" name="Submit2" value="Supprimer" /> </label></td> </tr> </table> <p> </p> </form> <form id="form2" name="form2" method="post" action="testservice.php"> <label> <input type="submit" name="Submit3" value="visualiser" /> </label> </form> </td> <td width="100%"> </td> </tr> </table> </body> </html>
j'envoie le code alors mais je le met ou?=> Quand tu rédiges une réponse ou un commentaire à ce message, vois tu les icones qui permettent de mettre en Grais (B), Italic(I), Souligné (S)..et la dernière ( <> ).. Cette icone permet de dire que tout ce que tu vas écrire au milieu des 'balises < code > ... < /code > .. c'est du CODE.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question</p> <p>Select direction: <label> <select name="id_direction" classe="texte" id="id_direction"> <option value="0">..select..</option> <?PHP $sql='SELECT * FROM direction LIMIT 0,30 '; $req=mysql_query($sql); //or die('Erreur SQL!<br>' .$sql.'<br>'.mysql_error()); if ($req){ while($row=mysql_fetch_array($req)) { echo'<option value= " '.$row['id_direction'].'"> '.$row['nomdirection'].'</option>'; } }else{ $message = 'Requête invalide : ' . mysql_error() . "n"; $message .= 'Requête complète : ' . $query; } ?> </select> </label> <?Php Echo $message; ?> </p>
Undefined variable: queryoui, remplace les variables par les tiennes :
requete invalide:No database selectedC'est que la connexion à ta BDD n'est pas bonne....Il ne parvient pas à sélectionner la Base de donnée.. (c'est ce qui est écrit en anglais quoi...)
<?php $serveur="localhost"; $user="roor"; $pwd =""; $maBDD = "NomDeMaBase"; //connection au serveur MySQL $idConnexion = mysql_connect($serveur,$user,$pwd) or die('echec connection : '.mysql_error() ); //selection de la base $connexionReussie = mysql_select_db($maBDD) or die('echec selection base : '.mysql_error() ); ?>
<?php /* www/mysite/core/rt.base.php */ define("MY_SERVER", "localhost"); define("MY_USER", "root"); define("MY_PASS", ""); define("MY_BDD", "mybase"); $my = new mysqli(MY_SERVER, MY_USER, MY_PASS, MY_BDD); if($my->connect_errno){ echo '<p class="fatal_error">Pas de connexion à la base de donnée.</p>'; exit(); } ?>
<?php /* www/mysite/enregistrementservice.php */ ?> <!DOCTYPE html> <html> <head> <!-- ... --> </head> <body> <header> <!-- ... --> <?php require_once('core/rt.base.php'); ?> <nav> <!-- ... --> </nav> </header> <section> <!-- ... --> <select name="id_direction" id="id_direction" class="texte"> <option value="0" selected="true">..Select..</option> <?php $query = "SELECT * FROM direction"; if($result = $my->query($query)){ while($o = $result->fetch_assoc()){ echo '<option value="', $o['id_direction'],'">', $o['nomdirection'],'</option>'; } $result->close(); } ?> </select> <!-- ... --> </section> <footer> <!-- ... --> </footer> </body> </html>
je vois rien ka je veut visualiserTu peux traduire ?
$sql='SELECT *FROM service INNER JOIN direction ON direction.id_direction=service.id_direction '; $req=mysql_query($sql)or die('Erreur SQL!<br>' .sql.'<br>'.mysql_error()); if (!$req) { echo "Impossible d'exécuter la requête ($sql) dans la base : " . mysql_error(); exit; } if (mysql_num_rows($req) == 0) { echo "Aucune ligne trouvée, rien à afficher."; exit; }
quand je l'essaie avec une autre pageEt le fichier de connexion est bon sur les autres pages ?