Friday, March 8, 2013

Simple connecting to MySQL with PHP

How to connect to MySQL in PHP?
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: