How to connect to MySQL database using PHP
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | <?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 //fetch tha data from the database //close the connection mysql_close($dbhandle); ?> |
MySQL Query Script:
1 2 3 4 5 6 7 8 9 10 11 12 13 | 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'); |