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
| <?php
$host = "free.fr:3307"; (j'ai aussi essayé "sql.free.fr"
$user = "moncompte";
$password = "monpasswd";
$data_base ="nom_de_la_base";
//connection
if($cxn = mysql_connect($host,$user, $password))
{
echo "La connection a la BDD est OK";
}
else
{echo "<br> Pas de connection possible à la base";
}
//selection de la BDD
mysql_select_db($data_base,$cxn);
$sql = "select PRENOM, NOM from CI";
$result = mysql_query($sql,$cxn);
while($row = mysql_fetch_array($result))
{
echo $row['PRENOM'] . " " . $row['NOM'];
echo "<br />";
}
?> |
Partager