How to query database data types via Ajax and PHP
In web development, it is very common to use Ajax and PHP technology to query the database. Through Ajax, you can use PHP code to query the database without refreshing the entire page, thereby achieving a more efficient dynamic page interaction effect. Before querying the database with Ajax and PHP, it is important to understand the data types. This article will introduce how to query database data types through Ajax and PHP.
1. Query string type data
The string type is one of the most common data types in the database. The following takes the user name query of the user table as an example to show how to use Ajax and PHP to query string type data.
HTML part:
<html>
<head>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script>
$(document).ready(function(){
$("#btn").click(function(){
var username=$("#username").val();
$.ajax({
url: "query.php",
type: "post",
data:{username:username},
success:function(data){
$("#result").html(data);
}
});
});
});
</script>
</head>
<body>
<input type="text" id="username" name="username">
<input type="button" id="btn" value="查询">
<div id="result"></div>
</body>
</html>In the HTML code, enter the user name you want to query in the input box, click the query button, and send the entered user name to the query.php file through Ajax Perform a query, and the query results are returned through the success function and displayed on the page.
PHP part:
<?php
$conn=mysqli_connect("localhost","root","password","test_database");
mysqli_query($conn,"set names utf8");
$username=$_POST['username'];
$sql="select * from user where username like '%".$username."%'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)){
while($row=mysqli_fetch_array($result)){
echo "用户名：".$row['username']."<br/>";
}
}else{
echo "该用户不存在";
}
}
mysqli_close($conn);
?>In the PHP code, first connect to the database, then receive the query keyword sent through $_POST, and then store the query results in the $result array. And retrieve the data one by one through the mysqli_fetch_array function.
2. Query numeric type data
Numeric type data is usually used to store numerical types, such as integers, floating point, etc. The following takes querying the price of a product table as an example to show how to use Ajax and PHP to query numeric data.
HTML part:
<html>
<head>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script>
$(document).ready(function(){
$("#btn").click(function(){
var price=$("#price").val();
$.ajax({
url: "query.php",
type: "post",
data:{price:price},
success:function(data){
$("#result").html(data);
}
});
});
});
</script>
</head>
<body>
<input type="text" id="price" name="price">
<input type="button" id="btn" value="查询">
<div id="result"></div>
</body>
</html>In the HTML code, enter the price of the product you want to query in the input box, click the query button, and send the entered price to the query.php file through Ajax. Query, the query results are returned through the success function and displayed on the page.
PHP part:
<?php
$conn=mysqli_connect("localhost","root","password","test_database");
mysqli_query($conn,"set names utf8");
$price=$_POST['price'];
$sql="select * from goods where price='".$price."'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)){
while($row=mysqli_fetch_array($result)){
echo "商品名称：".$row['name']."<br/>";
}
}else{
echo "该价格对应的商品不存在";
}
}
mysqli_close($conn);
?>In the PHP code, first connect to the database, then receive the query keyword sent through $_POST, and then store the query results in the $result array. And retrieve the data one by one through the mysqli_fetch_array function.
3. Query date type data
The date type is another common data type in the database. The following takes querying the order time of the order table as an example to show how to use Ajax and PHP to query date type data.
HTML part:
<html>
<head>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script>
$(document).ready(function(){
$("#btn").click(function(){
var date=$("#date").val();
$.ajax({
url: "query.php",
type: "post",
data:{date:date},
success:function(data){
$("#result").html(data);
}
});
});
});
</script>
</head>
<body>
<input type="text" id="date" name="date">
<input type="button" id="btn" value="查询">
<div id="result"></div>
</body>
</html>In the HTML code, enter the order date you want to query in the input box, click the query button, and send the entered date to the query.php file through Ajax Query is performed in the query, and the query results are returned through the success function and displayed on the page.
PHP part:
<?php
$conn=mysqli_connect("localhost","root","password","test_database");
mysqli_query($conn,"set names utf8");
$date=$_POST['date'];
$sql="select * from order where order_date='".$date."'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)){
while($row=mysqli_fetch_array($result)){
echo "订单号：".$row['order_id']."<br/>";
}
}else{
echo "该日期没有订单";
}
}
mysqli_close($conn);
?>In the PHP code, first connect to the database, then receive the query keyword sent through $_POST, and then store the query results in the $result array. And retrieve the data one by one through the mysqli_fetch_array function.
To sum up, this article introduces how to use Ajax and PHP technology to query database data types from three aspects: strings, numbers and dates. For web developers, mastering this technology is very necessary. I hope this article can be helpful to readers.
The above is the detailed content of How to query database data types via Ajax and 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
1377
52
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.
PHP Secure File Uploads: Preventing file-related vulnerabilities.
Mar 26, 2025 pm 04:18 PM
The 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.
OWASP Top 10 PHP: Describe and mitigate common vulnerabilities.
Mar 26, 2025 pm 04:13 PM
The 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 Encryption: Symmetric vs. asymmetric encryption.
Mar 25, 2025 pm 03:12 PM
The article discusses symmetric and asymmetric encryption in PHP, comparing their suitability, performance, and security differences. Symmetric encryption is faster and suited for bulk data, while asymmetric is used for secure key exchange.
PHP Authentication & Authorization: Secure implementation.
Mar 25, 2025 pm 03:06 PM
The article discusses implementing robust authentication and authorization in PHP to prevent unauthorized access, detailing best practices and recommending security-enhancing tools.
How do you retrieve data from a database using PHP?
Mar 20, 2025 pm 04:57 PM
Article discusses retrieving data from databases using PHP, covering steps, security measures, optimization techniques, and common errors with solutions.Character count: 159
PHP API Rate Limiting: Implementation strategies.
Mar 26, 2025 pm 04:16 PM
The 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 CSRF Protection: How to prevent CSRF attacks.
Mar 25, 2025 pm 03:05 PM
The article discusses strategies to prevent CSRF attacks in PHP, including using CSRF tokens, Same-Site cookies, and proper session management.
