How to use PHP and Vue to implement data search function
How to use PHP and Vue to implement data search function
In modern web development, many applications need to have data search function, so that users can easily search according to specific conditions to find the required data. This article will introduce how to use PHP and Vue to implement data search functions, and provide specific code examples.
1. Preparation
Before starting to write code, we first need to set up a development environment. Make sure you have the following tools and software installed:
- PHP: A popular server-side programming language used to handle requests and responses for data.
- Vue.js: A JavaScript framework for building user interfaces that can achieve dynamic updates and interactive effects.
- Database: You can choose any relational database, such as MySQL, PostgreSQL, etc.
2. Create database and table
Create a table in the database to store the data you need to find. Suppose we have a table called "products" with the following fields:
- id: the unique identifier of the product
- name: the name of the product
- price: Product price
- category: Product category
3. Back-end programming (PHP)
First, we need to write PHP code to handle data query requests. Create a file named "search.php" and add the following code:
<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydatabase";
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
// 获取查询条件
$searchTerm = $_GET['searchTerm'];
// 构建SQL查询语句
$sql = "SELECT * FROM products WHERE name LIKE '%$searchTerm%'";
$result = $conn->query($sql);
// 返回结果
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$data[] = $row;
}
echo json_encode($data);
} else {
echo "0 结果";
}
$conn->close();
?>The above code first connects to the database, then obtains the query conditions passed by the front end, constructs a SQL query statement, and converts the results into JSON format is returned to the front end. The "LIKE" operator is used here for fuzzy matching to allow users to enter partial keywords for query.
4. Front-end Programming (Vue.js)
Next, we need to write Vue.js code to handle user interface interaction and send query requests to the backend. In the HTML file, add the following code:
<!DOCTYPE html>
<html>
<head>
<script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
<script src="https://cdn.jsdelivr.net/npm/axios/dist/axios.min.js"></script>
</head>
<body>
<div id="app">
<input type="text" v-model="searchTerm">
<button @click="search">搜索</button>
<ul>
<li v-for="product in products">{{ product.name }}, 价格：{{ product.price }}</li>
</ul>
</div>
<script>
new Vue({
el: '#app',
data: {
searchTerm: '',
products: []
},
methods: {
search: function() {
axios.get('search.php', {
params: {
searchTerm: this.searchTerm
}
})
.then(function(response) {
this.products = response.data;
}.bind(this))
.catch(function(error) {
console.log(error);
});
}
}
});
</script>
</body>
</html>The above code uses the Vue.js framework to create an interface containing an input box, a button, and a list displaying query results. When the user clicks the button, the "search" method in the Vue instance will be called. In this method, the Axios library is used to send a GET request to the "search.php" file on the backend, and the query conditions are passed as parameters.
5. Test function
Now, we have completed the back-end and front-end coding work. Open the HTML file in the browser, enter the product name you want to find, and click the search button. The backend will return data that meets the conditions and display it on the interface.
6. Summary
This article introduces how to use PHP and Vue to implement the data search function, and provides detailed code examples. In this way, users can easily find the data they need based on specific conditions, and this function can be applied in various applications. Hope this article is helpful to you!
The above is the detailed content of How to use PHP and Vue to implement data search function. 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
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
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
1387
52
How to add functions to buttons for vue
Apr 08, 2025 am 08:51 AM
You can add a function to the Vue button by binding the button in the HTML template to a method. Define the method and write function logic in the Vue instance.
The Future of PHP: Adaptations and Innovations
Apr 11, 2025 am 12:01 AM
The future of PHP will be achieved by adapting to new technology trends and introducing innovative features: 1) Adapting to cloud computing, containerization and microservice architectures, supporting Docker and Kubernetes; 2) introducing JIT compilers and enumeration types to improve performance and data processing efficiency; 3) Continuously optimize performance and promote best practices.
PHP vs. Python: Understanding the Differences
Apr 11, 2025 am 12:15 AM
PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.
PHP and Python: Comparing Two Popular Programming Languages
Apr 14, 2025 am 12:13 AM
PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
How to jump a tag to vue
Apr 08, 2025 am 09:24 AM
The methods to implement the jump of a tag in Vue include: using the a tag in the HTML template to specify the href attribute. Use the router-link component of Vue routing. Use this.$router.push() method in JavaScript. Parameters can be passed through the query parameter and routes are configured in the router options for dynamic jumps.
PHP's Current Status: A Look at Web Development Trends
Apr 13, 2025 am 12:20 AM
PHP remains important in modern web development, especially in content management and e-commerce platforms. 1) PHP has a rich ecosystem and strong framework support, such as Laravel and Symfony. 2) Performance optimization can be achieved through OPcache and Nginx. 3) PHP8.0 introduces JIT compiler to improve performance. 4) Cloud-native applications are deployed through Docker and Kubernetes to improve flexibility and scalability.
How to jump to the div of vue
Apr 08, 2025 am 09:18 AM
There are two ways to jump div elements in Vue: use Vue Router and add router-link component. Add the @click event listener and call this.$router.push() method to jump.
How to pass parameters for vue function
Apr 08, 2025 am 07:36 AM
There are two main ways to pass parameters to Vue.js functions: pass data using slots or bind a function with bind, and provide parameters: pass parameters using slots: pass data in component templates, accessed within components and used as parameters of the function. Pass parameters using bind binding: bind function in Vue.js instance and provide function parameters.
