PHP and Mysql connection_PHP tutorial

After logging in, it will look like this:

First we create a database for testing.

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

I created a books database with an item table in it:

Next, implement a function: connect to the database and print out the contents of the table.

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!";
?>

$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 will display seccess!

Create list.php

[php]
include("conn.php");
         $sql="select * from items";
          $query=mysql_query($sql);
echo "

";
while($row = mysql_fetch_array($query))
{
         $id=$row["id"];
         $name=$row["name"];
echo "";
}
echo "

Id	Name
".$id."	".$name."

";
mysql_close();
?>

          include("conn.php");
          $sql="select * from items";
          $query=mysql_query($sql);
echo "

";
while($row = mysql_fetch_array($query))
{
         $id=$row["id"];
          $name=$row["name"];
echo "";
}
echo "

Id	Name
".$id."	".$name."

";
mysql_close();
?>

Finish and call it a day.

http://www.bkjia.com/PHPjc/477590.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/477590.htmlTechArticleAfter logging in, it looks like this: First, let's create a database for testing. If you are lazy, just create it directly in phpMyAdmin. I created a books database with...