Home > Article > Backend Development > What should I do if the database table cannot be displayed on the php page?

What should I do if the database table cannot be displayed on the php page?

藏色散人Original: 2022-01-24 09:12:223859browse

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 &#39;utf8&#39;");
    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=&#39;text-align:left;&#39; border=&#39;1&#39;>
         <tr><th>id</th><th>名字</th><th>年龄</th><th>性别</th></tr>
    <?php
    //引用conn.php文件
        require &#39;conn.php&#39;;
        //查询数据表中的数据
         $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[&#39;id&#39;];
                $name = $sql_arr[&#39;name&#39;];
                $age = $sql_arr[&#39;age&#39;];
                $sex = $sql_arr[&#39;sex&#39;];
                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:

What should I do if the database table cannot be displayed on the php page?

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!

php mysql 循环数据库

Statement：

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

Previous article：What should I do if the php test page cannot come out?Next article：What should I do if the php test page cannot come out?

See more

What should I do if the database table cannot be displayed on the php page?

Related articles