How to use PHP and Vue to develop QR code management functions for warehouse management

How to use PHP and Vue to develop the QR code management function of warehouse management

Foreword:
With the rapid development of e-commerce, warehouse management has become more and more is becoming more and more important. Quickly and accurately tracking the location and status of goods in the warehouse is key to keeping supply chains running efficiently. As a common means of identifying goods, QR codes have the characteristics of large information storage capacity and easy reading, and are widely used in warehouse management.

This article will introduce how to use PHP and Vue to develop the QR code management function of warehouse management, and give specific code examples.

1. Technical preparation
Before you start, you first need to install the following software and tools:

1. PHP environment (such as XAMPP, WAMP, etc.)
2. Vue .js
3. IDE tools (such as Visual Studio Code)

2. Database design
Before starting development, you need to design a suitable database structure for storage warehouse management and Data related to QR code.

We design a database named "inventory", which contains two tables: a "goods" table used to store goods information, and a "qrcodes" table used to store QR code information.

The goods table contains the following fields:

• id: Goods ID (primary key)
• name: Goods name
• price: Goods price
• quantity: quantity of goods

qrcodes table contains the following fields:

• id: QR code ID (primary key)
• goods_id: Association Goods ID
• qrcode: QR code content

3. Back-end development (using PHP)

1. Connect to database
   Use PHP to connect Database, you can use mysqli or PDO, etc. The following is a sample code:

<?php
$host = "localhost";
$username = "root";
$password = "";
$database = "inventory";

$mysqli = new mysqli($host, $username, $password, $database);
if ($mysqli->connect_errno) {
    die("连接数据库失败：" . $mysqli->connect_error);
}
?>

2. Query goods information
   Write PHP code to query all goods information in the goods table and return data in JSON format. The following is a sample code:

<?php
// 查询所有货物信息
$query = "SELECT * FROM goods";
$result = $mysqli->query($query);

// 将结果转换为JSON格式
$data = [];
while ($row = $result->fetch_assoc()) {
    $data[] = $row;
}
echo json_encode($data);

// 释放资源
$result->free();
$mysqli->close();
?>

3. Add QR code
   Write PHP code, add QR code information to the qrcodes table, and return the generated QR code ID. The following is a sample code:

<?php
// 获取POST请求参数
$qrcode = $_POST['qrcode'];
$goods_id = $_POST['goods_id'];

// 插入二维码信息
$query = "INSERT INTO qrcodes (goods_id, qrcode) VALUES ('$goods_id', '$qrcode')";
$result = $mysqli->query($query);

// 返回生成的二维码ID
echo $mysqli->insert_id;

// 释放资源
$result->free();
$mysqli->close();
?>

4. Front-end development (using Vue.js)

1. Install Vue.js and axios
   In the project directory, pass The following command installs Vue.js and axios:

$ npm install vue
$ npm install axios

2. Create Vue component
   Create a Vue component named "Inventory" to display warehouse management and QR code management Function. The following is a sample code:

<template>
  <div>
    <h1>仓库管理</h1>
    <h2>货物信息</h2>
    <ul>
      <li v-for="item in goods" :key="item.id">
        {{ item.name }} - {{ item.price }} - {{ item.quantity }}
      </li>
    </ul>
    <h2>添加二维码</h2>
    <form @submit.prevent="addQrcode">
      <label for="qrcode">二维码内容：</label>
      <input type="text" v-model="qrcode" required>
      <label for="goods_id">货物ID：</label>
      <input type="text" v-model="goods_id" required>
      <button type="submit">添加</button>
    </form>
  </div>
</template>

<script>
import axios from 'axios';

export default {
  data() {
    return {
      goods: [],
      qrcode: '',
      goods_id: '',
    };
  },
  methods: {
    getGoods() {
      axios.get('/api/goods.php')
        .then(response => {
          this.goods = response.data;
        })
        .catch(error => {
          console.error(error);
        });
    },
    addQrcode() {
      axios.post('/api/qrcodes.php', {
        qrcode: this.qrcode,
        goods_id: this.goods_id,
      })
        .then(response => {
          const qrcodeId = response.data;
          console.log('生成的二维码ID：', qrcodeId);
        })
        .catch(error => {
          console.error(error);
        });
    },
  },
  mounted() {
    this.getGoods();
  },
};
</script>

3. Mount Vue instance
   In the entry file of the project, mount the Vue instance and specify the DOM element to be rendered. The following is a sample code:

<!DOCTYPE html>
<html lang="zh-CN">
<head>
  <meta charset="UTF-8">
  <title>仓库管理</title>
</head>
<body>
  <div id="app"></div>

  <script src="https://cdn.jsdelivr.net/npm/vue"></script>
  <script src="https://cdn.jsdelivr.net/npm/axios"></script>
  <script>
    import Inventory from './components/Inventory.vue'

    new Vue({
      el: '#app',
      components: { Inventory },
      template: '<Inventory />',
    });
  </script>
</body>
</html>

5. Run and test

1. Start the PHP development server
   Run the following command in the project directory to start the PHP development server:

$ php -S localhost:8000

2. Start the front-end development server
   Run the following command in the project directory to start the front-end development server:

$ npm run serve

3. In the browser Visit
   and access "http://localhost:8080" in the browser to view and test the QR code management function of warehouse management.

Summary:
This article introduces how to use PHP and Vue to develop the QR code management function of warehouse management, and gives specific code examples. In this way, we can quickly implement the functions of cargo information management and QR code generation and association in the warehouse, improving the efficiency and accuracy of warehouse management. I hope this article will be helpful to everyone when developing a warehouse management system.

The above is the detailed content of How to use PHP and Vue to develop QR code management functions for warehouse management. For more information, please follow other related articles on the PHP Chinese website!