Home >Backend Development >PHP Problem >What should I do if the database table cannot be displayed on the php page?
The solution to the problem that the database table cannot be displayed on the PHP page: 1. Connect to the database and set the character set; 2. Query the data in the data table; 3. Loop through the data in the data table; 4. Set Just display it in table form.
The operating environment of this article: Windows 7 system, PHP version 7.1, DELL G3 computer
The php page cannot display the database table what to do?
Display the data in the database on the web page in PHP
I have nothing to do recently. I feel that the previous things are okay and I simply read the following, because it is still I'm learning new things, so I don't publish many blogs, maybe it's just my thoughts.
This time I will talk about how to display the data in the mysql database on the web page using php. First, build your own database and add some information in it. If you read this article again, I believe you still know some about mysql. To build a database, you just need to use some create and the like. I won’t go into that here. , everyone can do it by themselves. I will mainly focus on how to display the information in the built database on the web page.
The database I use here is login;
First create a folder, and then create two files in it, one is the file to connect to the database (conn.php), and the other is The file (students.php) that displays the information in the database on the web page. The code in
conn.php is as follows:
<?php //连接想要连接的数据库,localhost是本地服务器,root为数据库的账号,我的密码为0所以是空 $con = mysql_connect("localhost","root",""); //设置字符集,将字符集设置为utf8 的格式,这是大多数的中文都识别的 mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET utf8"); if(!$con){ die(mysql_error()); } //连接数据库test mysql_select_db("test",$con); ?>
The code in students.php is as follows:
<!DOCTYPE html> <html> <head> <title>数据库显示</title> </head> <body> //以表格的形式进行显示 <table style='text-align:left;' border='1'> <tr><th>id</th><th>名字</th><th>年龄</th><th>性别</th></tr> <?php //引用conn.php文件 require 'conn.php'; //查询数据表中的数据 $sql = mysql_query("select * from login"); $datarow = mysql_num_rows($sql); //长度 //循环遍历出数据表中的数据 for($i=0;$i<$datarow;$i++){ $sql_arr = mysql_fetch_assoc($sql); $id = $sql_arr['id']; $name = $sql_arr['name']; $age = $sql_arr['age']; $sex = $sql_arr['sex']; echo "<tr><td>$id</td><td>$name</td><td>$age</td><td>$sex</td></tr>"; } ?> </table> </body> </html>
Enter your URL to view the display of the effect
The rendering after execution is as follows:
At this point we can display it, it is relatively simple and there is no need to say more.
Have you learned it here?
Recommended learning: "PHP Video Tutorial"
The above is the detailed content of What should I do if the database table cannot be displayed on the php page?. For more information, please follow other related articles on the PHP Chinese website!