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