web

<?php

echo '<pre>';
echo $_SERVER["SERVER_NAME"];
echo ' : ';
echo $_SERVER["SERVER_ADDR"];
echo ':';
echo $_SERVER["SERVER_PORT"];
echo '</pre><p>';

$username = "root";
$password = "";
$hostname = "127.0.0.1";

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
 or die("Unable to connect to MySQL");
echo "MySQL Ok<p>";
echo "SELECT id, nom,annee FROM autos<p>";

//select a database to work with
$selected = mysql_select_db("exemple",$dbhandle)
  or die("Could not select examples");

//execute the SQL query and return records
$result = mysql_query("SELECT id, nom,annee FROM autos");

//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {
   echo "ID:".$row{'id'}." Nom:".$row{'nom'}."Annee: ". //display the results
   $row{'annee'}."<br>";
}
//close the connection
mysql_close($dbhandle);
?>