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
|
<?php
// connexion à la base
$db = mysql_connect ('localhost', 'root', '') or die('Erreur de connexion '.mysql_error());
// sélection de la base**
mysql_select_db('auto',$db) or die('Erreur de selection '.mysql_error());
$nom2=$_POST['nom2'];
$ligne = mysql_query("SELECT * FROM cg WHERE nom='$nom2'") ;
if (mysql_num_rows($ligne) > 0) {
while ($champ = mysql_fetch_object($ligne) )
{
echo "$champ->NOrdre";
echo "$champ->wilaya";
echo "$champ->NImmatriculation";
echo "$champ->Date";
echo "$champ->Quittance";
echo "$champ->sex";
echo "$champ->nom";
echo "$champ->prenom";
echo "$champ->DateDeNaissance";
echo "$champ->WilayaDeNaissance";
echo "$champ->profession";
echo "$champ->address ";
echo "$champ->commune";
echo "$champ->phone";
echo "$champ->genre";
echo "$champ->marque";
echo "$champ->Type";
echo "$champ->NType";
echo "$champ->carrosserie";
echo "$champ->Energie";
echo "$champ->Puissance";
echo "$champ->NPlace";
echo "$champ->PoidsTotal";
echo "$champ->PoidsUtil";
echo "$champ->PrecedentN";
echo "$champ->AnneeC" ;
}
} else { echo "Personne inexistant dans la Base de données"; }
mysql_close($db); // on ferme la connexion
?> |
Partager