Backend Development
PHP Tutorial
How to use PHP and Vue to develop a quick search function for warehouse management
How to use PHP and Vue to develop a quick search function for warehouse management
How to use PHP and Vue to develop the fast search function of warehouse management
In a modern warehouse management system, the fast search function is crucial. It can help users quickly find the required warehouse information and improve work efficiency. This article will introduce how to use PHP and Vue to develop the fast search function in the warehouse management system, and provide specific code examples.
- Development environment preparation
Before you begin, make sure you have installed the following software:
- PHP server environment (such as Apache or Nginx )
- MySQL database
- Vue.js development environment
- Create database and data table
First, we A data table needs to be created to store warehouse information. Execute the following SQL statement in the MySQL database:
CREATE DATABASE IF NOT EXISTS `repository_management`;
USE `repository_management`;
CREATE TABLE `repositories` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`description` TEXT,
`location` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `repositories` (`name`, `description`, `location`) VALUES
('仓库A', '这是仓库A的描述', '地点A'),
('仓库B', '这是仓库B的描述', '地点B'),
('仓库C', '这是仓库C的描述', '地点C'); The above code creates a database named repository_management and creates a data named repositories in it table with some sample data inserted.
- Back-end development
Next, we will use PHP to develop the back-end API to provide warehouse data and search functions. Create a file called api.php and place it in the server's web root directory.
<?php
header('Content-Type: application/json');
// 连接数据库
$servername = 'localhost';
$username = '数据库用户名';
$password = '数据库密码';
$dbname = 'repository_management';
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die('连接失败: ' . $conn->connect_error);
}
// 获取仓库列表
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
$sql = 'SELECT * FROM `repositories`';
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$repositories = array();
while ($row = $result->fetch_assoc()) {
$repositories[] = $row;
}
echo json_encode($repositories);
} else {
echo '[]';
}
}
// 搜索仓库
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$searchTerm = $_POST['term'];
$sql = "SELECT * FROM `repositories` WHERE `name` LIKE '%$searchTerm%'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$repositories = array();
while ($row = $result->fetch_assoc()) {
$repositories[] = $row;
}
echo json_encode($repositories);
} else {
echo '[]';
}
}
$conn->close();In the above code, we first establish a connection with the database, and then define two interfaces: getting the warehouse list and searching the warehouse. The Get Warehouse List interface obtains all warehouse data from the database by executing the SQL statement SELECT * FROM repositories, and returns the result as data in JSON format. The search warehouse interface performs fuzzy search by obtaining the search keywords passed from the front end, executing the SQL statement `SELECT * FROM `repositories` WHERE `name` LIKE '%$searchTerm%', and returning the results as Data in JSON format.
Please remember to replace Database Username and Database Password in the code with your own actual database username and password.
- Front-end development
Next, we will use Vue.js to develop the front-end page to display warehouse information and search functions. Create a file called index.html and place it in the server's web root directory.
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<title>仓库管理系统</title>
<script src="https://cdn.jsdelivr.net/npm/vue"></script>
</head>
<body>
<div id="app">
<h1 id="仓库管理系统">仓库管理系统</h1>
<input type="text" v-model="searchTerm" placeholder="输入关键字搜索仓库">
<ul>
<li v-for="repository in repositories">{{ repository.name }}（{{ repository.location }}）</li>
</ul>
</div>
<script>
new Vue({
el: '#app',
data: {
repositories: [],
searchTerm: ''
},
mounted: function () {
this.getRepositories();
},
methods: {
getRepositories: function () {
fetch('api.php')
.then(function(response) {
return response.json();
})
.then(function(repositories) {
this.repositories = repositories;
}.bind(this))
.catch(function(error) {
console.log(error);
});
},
searchRepositories: function () {
fetch('api.php', {
method: 'POST',
headers: {
'Content-Type': 'application/x-www-form-urlencoded'
},
body: 'term=' + this.searchTerm
})
.then(function(response) {
return response.json();
})
.then(function(repositories) {
this.repositories = repositories;
}.bind(this))
.catch(function(error) {
console.log(error);
});
}
},
watch: {
searchTerm: function () {
this.searchRepositories();
}
}
});
</script>
</body>
</html>In the above code, we created a Vue instance and defined two variables in the data attribute: repositories (used to store warehouse data) and searchTerm (used to store search keywords). In the mounted life cycle hook, we call the getRepositories method to get the warehouse data from the backend and assign it to the repositories variable. The getRepositories method uses the fetch function to send a GET request.
In the template, we used the v-for directive to loop through the repositories variables and display the name and location of each repository on the page. The v-model directive is used in the input box to bidirectionally bind the input content to the searchTerm variable. When the content of the input box changes, the searchTerm in the watch attribute monitors the change and automatically calls the searchRepositories method to send a POST request to search for warehouse data.
- Run and test
After saving the above code, start your web server and open the index.html file in the browser the address of. You will see a page with input boxes and a list of repositories. After entering the keyword in the input box, the page will display warehouse information related to the keyword in real time.
The above is the entire process of using PHP and Vue to develop the quick search function of warehouse management. By realizing the cooperation between the back-end API and the front-end page, we can quickly search the warehouse and clarify their location and description information. Such a function is very practical and easy to implement, and can greatly improve the efficiency of warehouse management.
The above is the detailed content of How to use PHP and Vue to develop a quick search function for warehouse management. 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
1378
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.
How can you prevent a class from being extended or a method from being overridden in PHP? (final keyword)
Apr 08, 2025 am 12:03 AM
In PHP, the final keyword is used to prevent classes from being inherited and methods being overwritten. 1) When marking the class as final, the class cannot be inherited. 2) When marking the method as final, the method cannot be rewritten by the subclass. Using final keywords ensures the stability and security of your code.
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.
How to use function intercept vue
Apr 08, 2025 am 06:51 AM
Function interception in Vue is a technique used to limit the number of times a function is called within a specified time period and prevent performance problems. The implementation method is: import the lodash library: import { debounce } from 'lodash'; Use the debounce function to create an intercept function: const debouncedFunction = debounce(() => { / Logical / }, 500); Call the intercept function, and the control function is called at most once in 500 milliseconds.
What does vue multi-page development mean?
Apr 07, 2025 pm 11:57 PM
Vue multi-page development is a way to build applications using the Vue.js framework, where the application is divided into separate pages: Code Maintenance: Splitting the application into multiple pages can make the code easier to manage and maintain. Modularity: Each page can be used as a separate module for easy reuse and replacement. Simple routing: Navigation between pages can be managed through simple routing configuration. SEO Optimization: Each page has its own URL, which helps SEO.
How to use vue pagination
Apr 08, 2025 am 06:45 AM
Pagination is a technology that splits large data sets into small pages to improve performance and user experience. In Vue, you can use the following built-in method to paging: Calculate the total number of pages: totalPages() traversal page number: v-for directive to set the current page: currentPage Get the current page data: currentPageData()
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.
How to use foreach loop in vue
Apr 08, 2025 am 06:33 AM
The foreach loop in Vue.js uses the v-for directive, which allows developers to iterate through each element in an array or object and perform specific operations on each element. The syntax is as follows: <template> <ul> <li v-for="item in items>>{{ item }}</li> </ul> </template>&am
