PHP connects to the database and dynamically displays database records

Home

Backend Development

PHP Tutorial

PHP connects to the database and dynamically displays database records_PHP tutorial

Jul 13, 2016 pm 05:16 PM

mysql php No introduce getting Started beginner dynamic Example database article show Record connect

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

代码如下

复制代码

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

// some code

Copy code

代码如下

复制代码

<?php
mysql_connect("localhost","root","");
mysql_select_db("cinema");
$_sql="select * from `t_hall`";
mysql_query("set names utf8");//编码设置为utf8
$query=mysql_query($_sql);
echo "<table align='center' border='1' cellspacing='0' width='550' >";
echo "<tr><td>影厅编号</td><td>大厅名</td><td>座位行</td><td>座位列</td></tr>";
while($row=mysql_fetch_array($query))
{
//从数据库查询出来的字段
//将数据放到html的表格中

echo "<tr onclick='GetText()'><td>{$row['HID']}</td><td>{$row['HHall']}</td><td>{$row['HSeatline']}</td><td>{$row['HSeatrow']}</td></tr>";
}
echo "</table>";
?>

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

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