Backend DevelopmentPHP ProblemWhat 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?
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!
ACID vs BASE Database: Differences and when to use each.Mar 26, 2025 pm 04:19 PMThe article compares ACID and BASE database models, detailing their characteristics and appropriate use cases. ACID prioritizes data integrity and consistency, suitable for financial and e-commerce applications, while BASE focuses on availability and
PHP Secure File Uploads: Preventing file-related vulnerabilities.Mar 26, 2025 pm 04:18 PMThe article discusses securing PHP file uploads to prevent vulnerabilities like code injection. It focuses on file type validation, secure storage, and error handling to enhance application security.
PHP Input Validation: Best practices.Mar 26, 2025 pm 04:17 PMArticle discusses best practices for PHP input validation to enhance security, focusing on techniques like using built-in functions, whitelist approach, and server-side validation.
PHP API Rate Limiting: Implementation strategies.Mar 26, 2025 pm 04:16 PMThe article discusses strategies for implementing API rate limiting in PHP, including algorithms like Token Bucket and Leaky Bucket, and using libraries like symfony/rate-limiter. It also covers monitoring, dynamically adjusting rate limits, and hand
PHP Password Hashing: password_hash and password_verify.Mar 26, 2025 pm 04:15 PMThe article discusses the benefits of using password_hash and password_verify in PHP for securing passwords. The main argument is that these functions enhance password protection through automatic salt generation, strong hashing algorithms, and secur
OWASP Top 10 PHP: Describe and mitigate common vulnerabilities.Mar 26, 2025 pm 04:13 PMThe article discusses OWASP Top 10 vulnerabilities in PHP and mitigation strategies. Key issues include injection, broken authentication, and XSS, with recommended tools for monitoring and securing PHP applications.
PHP XSS Prevention: How to protect against XSS.Mar 26, 2025 pm 04:12 PMThe article discusses strategies to prevent XSS attacks in PHP, focusing on input sanitization, output encoding, and using security-enhancing libraries and frameworks.
PHP Interface vs Abstract Class: When to use each.Mar 26, 2025 pm 04:11 PMThe article discusses the use of interfaces and abstract classes in PHP, focusing on when to use each. Interfaces define a contract without implementation, suitable for unrelated classes and multiple inheritance. Abstract classes provide common funct
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
SublimeText3 Linux new version
SublimeText3 Linux latest version
Dreamweaver CS6
Visual web development tools
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
