It's simple.
$username = "root";
$password = "password";
$host = "localhost";
$dbhandle = mysql_connect($host, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL";
$selected = mysql_select_db("dbName", $dbhandle)
or die("There is no database");
$result = mysql_query("SELECT model FROM cars");
while($row = mysql_fetch_array($result))
{
echo "MODEL: ".$row['model'];
}
mysql_close($dbhandle);
That is all. Simple?
Newer and better way to connect:
$db = new PDO( 'mysql:host=localhost; dbname=MyDbName; charset=utf8', 'username', 'password' );
$statement = $db -> query('SELECT model FROM cars');
foreach($statement as $row)
{
echo $row['model'];
}
No comments:
Post a Comment