LISTE DEROULANTE EN PHP

mallsoul Messages postés 147 Statut Membre -  
mallsoul Messages postés 147 Statut Membre -
Bonjour,jai commencé un site en php,jai besoin de recuperer dan une liste deroulante le "nom" et "prenom" d'une table qui est situé dan ma base de données,je sai pa comment faire. ma table s'appelle" prospect",et il ya plusieur champs dedan dont "nom","prenom","contact",mais jai besoin de faire ressortir les"nom" et les "prenom" dans une liste deroulante
A voir également:

4 réponses

Réponse 1 / 4
avion-f16 Messages postés 20367 Statut Contributeur 4 509
  
<?php
mysql_connect('','','');
mysql_select_db('');

$sql = 'SELECT id, nom, prenom FROM prospect ORDER BY nom, prenom ASC';
$req = mysql_query($sql) or die(mysql_error());

echo '<select name="personne">'."\n";
while($personne = mysql_fetch_assoc($req)) {
    echo "\t".'<option value="'.$personne['id'].'">'.$personne['nom'].' '.$personne['prenom'].'</option>'."\n";
}
echo '</select>';
mysql_close();
?>
0
Réponse 2 / 4
mallsoul Messages postés 147 Statut Membre 8
 
merci bocou,en fait je sai pa où mettre le code que vou me donnez.voici ma page html:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" >
<head>
<title>BIENVENUE SUR LA PAGE DES FORMULAIRES</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" media="screen" type="text/css" title="Exemple" href="recherche.css" />
<script src="recherche.js" type="text/javascript"></script>
<style type="text/css">
<!--
.Style2 {
font-style: italic;
font-family: "Times New Roman", Times, serif;
font-weight: bold;
}
.Style3 {font-weight: bold}
.Style4 {font-family: "Times New Roman", Times, serif}
-->
</style>


</head>

<body>

<!-- L'en-tête -->

<div id="en_tete">

</div>

<!-- Les menus -->



<!-- Le corps -->


<form NAME="form1" NAME="form1" method="POST" action="saisir_notes.html" target="_top" style="border-style: solid; border-width: 0px">
<center>
<p><img src="images/wiiselogo.JPG" alt="" width="757" height="86" /></p>
<form id="form1" method="post" action="">
<p>
<label><span class="Style3"> <span class="Style4">
<marquee width="760" scrollamount="3" bgcolor="#33CCFF">
<em>BIENVENUE DANS LE FORMULAIRE DE RECHERCHE DU CANDIDAT</em>
</marquee>
</span> </span></label>
</p>
</form>
<table border="0" width="60%" id="table1" bgcolor="#D3DCF8" style="color: #000010; font-family: Arial; font-size: 90%">

<tr>
<td colspan="3" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" bgcolor="#A8B8F0" align="center" height="35" >
<span class="Style2">VEUILLEZ CHOISIR LE CANDIDAT ICI, MERCI</span> </td>

</tr>

<tr>
<td width="220" align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid"> </td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>





<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span class="Style2">CHOISIR ICI :</span></td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">

<select NAME="nom_candidat" id="nom_candidat">
<OPTGROUP label="VOUS RECHERCHEZ: ">
<option selected> </option>
<option > </option>
</select> <span style="background-color: #FF0000; color:#FFFFFF" id="alert_se_xe"></span></td>


</tr>
<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>


<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span class="Style2">LE CANDIDAT SELECTIONNE EST</span> :</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid"><input type="text" NAME="" id="nom_candidat" size="50"><span style="background-color: #FF0000; color:#FFFFFF" id="alert_nom"></span></td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>


<tr>
<td style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid"> 
</td>
<td width="157" align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid"><input type="submit" value="SAISIE DES NOTES >>>" NAME="B1" href="saisir_notes.html" onclick="return validation(fo_rm);"></td>
<td width="208" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid"><input type="reset" value="ANNULER" NAME="B2"></td>
</tr>
<tr>
<td style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" colspan="3" bgcolor="#A8B8F0"> 

</td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>

<tr>
<td align="right" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
</td>
<td colspan="2" align="left" style="BORDER-RIGHT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid">
<span style="background-color: #FF0000; color:#FFFFFF" id="alert_pa_ys"></span> </td>
</tr>



</table>
</center>
</form>

</body>
</html>
0
Réponse 3 / 4
avion-f16 Messages postés 20367 Statut Contributeur 4 509
 
T'as appris à coder où ?
Avant de vouloir faire des choses dont tu en es incapable, apprends au moins les bases !
-> https://openclassrooms.com/fr/
0
Réponse 4 / 4
mallsoul Messages postés 147 Statut Membre 8
 
MERCI.jai pu insere le code.merci pour ton cou de main
0

Discussions similaires

Suppression listes déroulantes
Archa -
Sam -

5 réponses
Supprimer liste déroulante Excel
SamAlex -
b@bd -

8 réponses
Effacer le contenue d'une cellule avec liste déroulante
lebutters -
lebutters -

7 réponses
Effacer liste déroulante
gabrielle -
jmps -

3 réponses
Supprimer Liste déroulante
Good -
Good -

2 réponses