PHP connects to the database and dynamically displays database records_PHP tutorial

WBOY
Release: 2016-07-13 17:16:11
Original
814 people have browsed it

This article will introduce a good introductory example of PHP mysql to PHP beginners. We connect to the database and display the record examples in the database. Friends can refer to it.

Connect to a MySQL database

Before you can access and process data in the database, you must create a connection to the database.

In PHP, this task is accomplished through the mysql_connect() function.

Grammar

mysql_connect(servername,username,password);

In the example below, we store the connection in a variable ($con) for later use in the script. If the connection fails, the "die" part will be executed:

// some code
The code is as follows
 代码如下 复制代码

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

// some code

?>

Copy code

 代码如下 复制代码


mysql_connect("localhost","root","");
mysql_select_db("cinema");
$_sql="select * from `t_hall`";
mysql_query("set names utf8");//编码设置为utf8
$query=mysql_query($_sql);
echo "

";
echo "";
while($row=mysql_fetch_array($query))
{
//从数据库查询出来的字段
//将数据放到html的表格中

echo "

";
}
echo "
影厅编号大厅名座位行座位列
{$row['HID']}{$row['HHall']}{$row['HSeatline']}{$row['HSeatrow']}
";
?>

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

?>

After having the above foundation, we can query the database and display it
The code is as follows Copy code

mysql_connect("localhost","root","");
mysql_select_db("cinema");
$_sql="select * from `t_hall`";
mysql_query("set names utf8");//Encoding is set to utf8
$query=mysql_query($_sql);
echo "";
echo "";
}
echo "
A theater numberHall nameSeat rowSeat row";
while($row=mysql_fetch_array($query))
{
//Fields queried from the database
//Put the data into the html table echo "
{$row['HID']}{$row['HHall']}< /td>{$row['HSeatline']}{$row['HSeatrow']}
";
?>
http://www.bkjia.com/PHPjc/628663.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/628663.htmlTechArticleThis article will introduce a good php mysql entry example for php beginners. We connect to the database and display the database Friends can refer to the record examples in . Connect to a...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template