Simple PHP – MySQL Database Connection Code

 

  

Step:1

Create php page Copy this code

<?php
$username = "your_name";
$password = "your_password";
$hostname = "localhost"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
 or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";

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

//execute the SQL query and return records
$result = mysql_query("SELECT id, model,year FROM cars");

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

Step:2

Save this file connection_db.php

Step:3

To create 'examples' database on your MySQL server you should run the following script:

CREATE DATABASE `examples`; USE `examples`; CREATE TABLE `cars` (    `id` int UNIQUE NOT NULL,    `name` varchar(40),    `year` varchar(50),    PRIMARY KEY(id) ); INSERT INTO cars VALUES(1,'Mercedes','2000'); INSERT INTO cars VALUES(2,'BMW','2004'); INSERT INTO cars VALUES(3,'Audi','2001');