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
| $mysql_host = "hote";
$mysql_database = "bdd";
$mysql_user = "injall";
$mysql_password = "XXXXXX";
mysql_connect ($mysql_host,$mysql_user,$mysql_password) or die ('ERREUR '.mysql_error());
if (mysql_connect ($mysql_host,$mysql_user,$mysql_password)) {
echo ' ';
}
else {
echo 'connexion impossible...'.mysql_error();
}
$mavriable = $_GET['donnees'];
$reponse = $bdd->prepare('SELECT * FROM ma_table WHERE pseudo = :pseudo');
$reponse->execute(array($pseudo)); //ligne ou apparement il y as l erreur
while ($donnees = $reponse->fetch())
{
echo $donnees['pseudo'] . ' et ' . $donnees['donnes1'] . ', et ' . $donnees['donnes2'] . ' et ' . $donnees['donnes3'] . '<br />';
}
$reponse->closeCursor();
?> |