Connection between PHP and MySQL

First, make sure that the lamp environment is fully configured; otherwise, slam me!

Then, log on to phpMyAdmin using the MySQL password, and enter http: // 127.0.0.1/phpMyAdmin in the browser.

After login, it is like this:

First, create a database for testing.

If you are lazy, you can create it directly in phpMyAdmin.

I created a books database with an item table:

Next, we will implement a function: connect to the database and print out the table content.

Connect to database

<?php$db_host='localhost';$db_user='root';$db_pass='1';$db_name='books';$conn=mysql_connect($db_host,$db_user,$db_pass)mysql_select_db($db_name,$conn);mysql_query("set names 'utf8'");if(!$conn) echo "failed!"; else echo "success!";?>

If the connection is normal, the browser displays seccess!

Create list. php

<?php        include("conn.php");        $sql="select * from items";        $query=mysql_query($sql);echo "<table border=1><tr><td>Id</td><td>Name</td></tr>";while($row = mysql_fetch_array($query)){        $id=$row["id"];        $name=$row["name"]; echo "<tr><td>".$id."</td><td>".$name."</td></tr>";}echo "</table>";mysql_close();?>

Enter http: // 127.0.0.1/test1/list. php In the browser

Close the job.