How to query database data with ajax php
With the development of the Internet and mobile applications, the demand for dynamic pages and real-time query data is getting higher and higher. AJAX (Asynchronous JavaScript and XML) is a technology that helps developers achieve asynchronous data transmission and dynamic page updates. This article will introduce how to use AJAX and PHP to query data from the database and present it on the front end.
First, we need to create a simple database to store data. Here we take the "students" table as an example, which contains three fields: "id", "name" and "age" to store basic information of students.
After establishing the database, we need to use PHP to connect to the database and write query statements. The following is a simple query operation code:
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接是否成功
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT * FROM students";
$result = $conn->query($sql);
// 处理查询结果
if ($result->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
echo "学生ID: " . $row["id"]. " - 姓名: " . $row["name"]. " - 年龄: " . $row["age"]. "<br>";
}
} else {
echo "0 结果";
}
$conn->close();
?>The above code uses mysqli to connect to the MySQL database, performs a simple query operation, and outputs the query results to the front-end page. In actual development, it may be necessary to customize the content to be queried, as well as operations such as filtering and sorting.
Next, we need to use AJAX technology to asynchronously request server-side data and present the results on the front-end page. The following is the code for a simple AJAX query operation:
<html>
<head>
<script>
function showData(str) {
if (str=="") {
document.getElementById("result").innerHTML="";
return;
}
var xmlhttp=new XMLHttpRequest();
xmlhttp.onreadystatechange=function() {
if (this.readyState==4 && this.status==200) {
document.getElementById("result").innerHTML=this.responseText;
}
}
xmlhttp.open("GET","getdata.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>
<body>
<form>
<select name="students" onchange="showData(this.value)">
<option value="">请选择一个学生:</option>
<option value="1">小明</option>
<option value="2">小红</option>
<option value="3">小刚</option>
</select>
</form>
<br>
<div id="result"><b>这里会显示查询到的学生信息</b></div>
</body>
</html>The above code first defines a showData function for sending asynchronous requests and accepting data returned by the server. After selecting a student in the selection box, call the showData function and pass in the ID of the selected student as a parameter.
AJAX request uses the XMLHttpRequest object, specifies the URL address and parameters of the GET request through the open method, and sends the request through the send method. When the request returns a 200 status code, the query is successful, the onreadystatechange function is called, and the data returned by the server is used as the value of the responseText attribute to display the data on the front-end page. If the request fails, the failure status code and error information can be obtained through the status attribute.
Finally, we need to write a PHP script that accepts query requests and queries data from the database. The following is the code of a simple PHP script:
<?php
$q = $_GET['q'];
$con = mysqli_connect('localhost','username','password','myDB');
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}
mysqli_select_db($con,"students");
$sql="SELECT * FROM students WHERE id = '".$q."'";
$result = mysqli_query($con,$sql);
echo "<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Age</th>
</tr>";
while($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>The above code first reads the parameters passed in the AJAX request, then connects to the MySQL database, executes a query statement with where conditions, and converts the query results to Return to the front-end page in the form of an HTML table.
To sum up, the combination of AJAX and PHP to query database data and present it on the front end is a common dynamic web development requirement. By using these technologies appropriately, we can quickly implement a complete dynamic page.
The above is the detailed content of How to query database data with ajax php. For more information, please follow other related articles on the PHP Chinese website!
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
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to Implement message queues (RabbitMQ, Redis) in PHP?
Mar 10, 2025 pm 06:15 PM
This article details implementing message queues in PHP using RabbitMQ and Redis. It compares their architectures (AMQP vs. in-memory), features, and reliability mechanisms (confirmations, transactions, persistence). Best practices for design, error
What Are the Latest PHP Coding Standards and Best Practices?
Mar 10, 2025 pm 06:16 PM
This article examines current PHP coding standards and best practices, focusing on PSR recommendations (PSR-1, PSR-2, PSR-4, PSR-12). It emphasizes improving code readability and maintainability through consistent styling, meaningful naming, and eff
How Do I Work with PHP Extensions and PECL?
Mar 10, 2025 pm 06:12 PM
This article details installing and troubleshooting PHP extensions, focusing on PECL. It covers installation steps (finding, downloading/compiling, enabling, restarting the server), troubleshooting techniques (checking logs, verifying installation,
How to Use Reflection to Analyze and Manipulate PHP Code?
Mar 10, 2025 pm 06:12 PM
This article explains PHP's Reflection API, enabling runtime inspection and manipulation of classes, methods, and properties. It details common use cases (documentation generation, ORMs, dependency injection) and cautions against performance overhea
PHP 8 JIT (Just-In-Time) Compilation: How it improves performance.
Mar 25, 2025 am 10:37 AM
PHP 8's JIT compilation enhances performance by compiling frequently executed code into machine code, benefiting applications with heavy computations and reducing execution times.
How Do I Stay Up-to-Date with the PHP Ecosystem and Community?
Mar 10, 2025 pm 06:16 PM
This article explores strategies for staying current in the PHP ecosystem. It emphasizes utilizing official channels, community forums, conferences, and open-source contributions. The author highlights best resources for learning new features and a
How to Use Asynchronous Tasks in PHP for Non-Blocking Operations?
Mar 10, 2025 pm 04:21 PM
This article explores asynchronous task execution in PHP to enhance web application responsiveness. It details methods like message queues, asynchronous frameworks (ReactPHP, Swoole), and background processes, emphasizing best practices for efficien
How to Use Memory Optimization Techniques in PHP?
Mar 10, 2025 pm 04:23 PM
This article addresses PHP memory optimization. It details techniques like using appropriate data structures, avoiding unnecessary object creation, and employing efficient algorithms. Common memory leak sources (e.g., unclosed connections, global v
