How to use PHP and Vue to implement data search function
In modern web development, data search function has become a very common and essential function. PHP and Vue are two very popular technologies. If you combine their powerful capabilities, you can quickly implement an efficient data search function.
This article will introduce how to use PHP and Vue to implement the data search function through specific code examples. We will take a simple student information management system as an example. There is a student information table in the system, which contains information such as the student's name, age, and gender. We need to implement a search form so that users can search for student information by entering keywords.
First, we need to create a PHP backend interface to handle the search function. We can use PHP's database operation extensions, such as PDO or mysqli, to connect to the database and perform query operations. The following is a code example using PDO extension:
<?php
// 连接数据库
$dsn = "mysql:host=localhost;dbname=database";
$username = "username";
$password = "password";
$dbh = new PDO($dsn, $username, $password);
// 处理搜索请求
$keyword = $_GET["keyword"];
// 查询语句
$sql = "SELECT * FROM student WHERE name LIKE :keyword";
// 使用预处理语句防止 SQL 注入
$stmt = $dbh->prepare($sql);
$stmt->bindValue(':keyword', '%' . $keyword . '%');
// 执行查询
$stmt->execute();
// 获取结果集
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
// 返回 JSON 格式的结果
echo json_encode($results);
?>In the above code, we first establish a connection with the database, and then obtain the keywords entered by the user from the front end. Next, we use prepared statements to prevent SQL injection and execute the query, returning the query results to the front end in JSON format.
Next, we need to use Vue on the front end to handle the search function. The following is a code example using Vue:
<!DOCTYPE html>
<html>
<head>
<title>数据搜索功能示例</title>
<!-- 引入 Vue.js -->
<script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
</head>
<body>
<div id="app">
<input type="text" v-model="keyword" placeholder="请输入关键字">
<button @click="search">搜索</button>
<ul>
<li v-for="student in students" :key="student.id">{{ student.name }}</li>
</ul>
</div>
<script>
new Vue({
el: "#app",
data() {
return {
keyword: "",
students: []
}
},
methods: {
search() {
// 发送 Ajax 请求到后端接口
fetch('search.php?keyword=' + this.keyword)
.then(response => response.json())
.then(data => {
this.students = data;
})
.catch(error => {
console.error(error);
});
}
}
});
</script>
</body>
</html>In the above code, we first introduced Vue.js and created a Vue instance. Two variables, keyword and students, are defined in data of the instance, which are used to save the keywords and query results entered by the user respectively. In the search method, we use the fetch method to send an Ajax request to the backend interface, and assign the returned data to the students variable.
Through the above code examples of PHP and Vue, we have implemented a simple data search function. After the user enters the keyword in the input box and clicks the search button, the matching student information can be obtained from the backend and displayed on the page.
The above is just a simple example. In actual development, the code can be further optimized and expanded according to specific needs. I hope this article can help you understand how to use PHP and Vue to implement data search functions!
The above is the detailed content of How to implement data search function using PHP and Vue. For more information, please follow other related articles on the PHP Chinese website!
vue中props可以传递函数吗Jun 16, 2022 am 10:39 AMvue中props可以传递函数；vue中可以将字符串、数组、数字和对象作为props传递，props主要用于组件的传值，目的为了接收外面传过来的数据，语法为“export default {methods: {myFunction() {// ...}}};”。
聊聊vue指令中的修饰符，常用事件修饰符总结May 09, 2022 am 11:07 AM本篇文章带大家聊聊vue指令中的修饰符，对比一下vue中的指令修饰符和dom事件中的event对象，介绍一下常用的事件修饰符，希望对大家有所帮助！
如何覆盖组件库样式？React和Vue项目的解决方法浅析May 16, 2022 am 11:15 AM如何覆盖组件库样式？下面本篇文章给大家介绍一下React和Vue项目中优雅地覆盖组件库样式的方法，希望对大家有所帮助！
react与vue的虚拟dom有什么区别Apr 22, 2022 am 11:11 AMreact与vue的虚拟dom没有区别；react和vue的虚拟dom都是用js对象来模拟真实DOM，用虚拟DOM的diff来最小化更新真实DOM，可以减小不必要的性能损耗，按颗粒度分为不同的类型比较同层级dom节点，进行增、删、移的操作。
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
Atom editor mac version download
The most popular open source editor
Dreamweaver Mac version
Visual web development tools
Dreamweaver CS6
Visual web development tools
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
