1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
|
<?
// connexion à la base
$db = mysql_connect('sql.toto.com','toto','pwd') or die('Erreur de connexion '.mysql_error());
// sélection de la base
mysql_select_db('toto',$db) or die('Erreur de selection '.mysql_error());
/// Définition des variables
$civilite=$_POST['civilite'];
$cp=$_POST['cp'];
//// Liste des requetes
if ($civilite=="" AND $cp=="" )
{
$reponse = mysql_query("SELECT * FROM membre "." ORDER BY id" );
}
elseif ($civilite=="" )
{
$reponse = mysql_query("SELECT * FROM membre WHERE cp='$cp' "." ORDER BY id" ) ;
}
elseif ($cp=="" )
{
$reponse = mysql_query("SELECT * FROM membre WHERE civilite='$civilite' "." ORDER BY id" );
}
else
{
$reponse = mysql_query("SELECT * FROM membre WHERE civilite='$civilite' AND cp='$cp' "." ORDER BY id" );
}
$resultat = mysql_fetch_array($reponse);
echo $resultat;
?> |
Partager