Sujet Précédent Sujet Suivant

LISTE DEROULANTE EN PHP

Fermé
mallsoul Messages postés 110 Date d'inscription lundi 25 mai 2009 Statut Membre Dernière intervention 25 mai 2013 - 4 nov. 2009 à 13:05
mallsoul Messages postés 110 Date d'inscription lundi 25 mai 2009 Statut Membre Dernière intervention 25 mai 2013 - 5 nov. 2009 à 10:14
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 19246 Date d'inscription dimanche 17 février 2008 Statut Contributeur Dernière intervention 21 avril 2024 4 498
4 nov. 2009 à 13:11 
<?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 110 Date d'inscription lundi 25 mai 2009 Statut Membre Dernière intervention 25 mai 2013 8
4 nov. 2009 à 13:27
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 19246 Date d'inscription dimanche 17 février 2008 Statut Contributeur Dernière intervention 21 avril 2024 4 498
4 nov. 2009 à 14:22
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 110 Date d'inscription lundi 25 mai 2009 Statut Membre Dernière intervention 25 mai 2013 8
5 nov. 2009 à 10:14
MERCI.jai pu insere le code.merci pour ton cou de main
0

Discussions similaires

Suppression listes déroulantes
Archa -
Sam -

5 réponses
ALERT en php
snoopy -
appkech -

14 réponses
Accéder à la liste de numéros de téléphone en 07
cbhr -
syma 59 -

41 réponses
Annuaire inversé liste rouge
caro2lille -
gwendolyne72 -

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

8 réponses