How to use PHP and UniApp to implement batch import of data

How to use PHP and UniApp to implement batch import of data

Importing data is one of the problems often encountered in daily development. By combining PHP and UniApp, we can easily implement the batch import function of data. In this article, I will introduce the specific implementation steps and provide corresponding code examples.

1. Preparation
   First, we need to prepare the server-side PHP environment and UniApp development environment. Make sure the PHP version meets the requirements and the relevant extensions have been installed. In addition, we also need to set up the UniApp development environment and create related projects.
2. Create database and data table
   Before starting to write code, we need to create the corresponding database and data table. You can use tools such as phpMyAdmin to manage the database and create a suitable data table.
3. Writing back-end code (PHP)
   Next, let’s write the back-end PHP code. This code will handle the import logic of the data. The following is a simple code example:

<?php
  // 连接数据库
  $conn = new mysqli("localhost", "username", "password", "database_name");

  // 处理上传文件
  $file = $_FILES['file'];
  $temp = $file['tmp_name'];
  $filename = $file['name'];

  // 打开上传文件并读取数据
  $handle = fopen($temp, "r");
  $data = fgetcsv($handle);

  // 导入数据
  while (($data = fgetcsv($handle)) !== false) {
    $name = $data[0];
    $age = $data[1];
    $email = $data[2];

    // 将数据插入数据库
    mysqli_query($conn, "INSERT INTO `table_name` (`name`, `age`, `email`) VALUES ('$name', $age, '$email')");
  }

  // 关闭文件处理器
  fclose($handle);

  // 关闭数据库连接
  mysqli_close($conn);

  // 返回导入成功信息
  echo "数据导入成功";
?>

4. Writing front-end code (UniApp)
   Now, let’s write the front-end code of UniApp for uploading files and calling the back-end API. data import. The following is a simple code example:

<template>
  <view>
    <input type="file" @change="handleUpload" />
    <button @click="importData">导入数据</button>
  </view>
</template>

<script>
  export default {
    methods: {
      handleUpload(event) {
        this.file = event.target.files[0];
      },
      importData() {
        let formData = new FormData();
        formData.append('file', this.file);

        // 调用后端API导入数据
        uni.request({
          url: 'http://localhost/import.php',
          method: 'POST',
          data: formData,
          success(res) {
            console.log('数据导入成功');
            uni.showToast({
              title: '数据导入成功',
              icon: 'success',
              duration: 2000
            });
          },
          fail(res) {
            console.log('数据导入失败');
            uni.showToast({
              title: '数据导入失败',
              icon: 'none',
              duration: 2000
            });
          }
        });
      }
    }
  }
</script>

5. Test results
   After completing the above steps, we can test the data import in UniApp. First, select the file you want to import in UniApp and click the "Import Data" button. UniApp will send the selected file to the back-end PHP API for processing. If everything goes well, the backend will insert the data into the database and return a successful import message, and UniApp will display a success prompt box.

Summary
Through the above steps, we can easily use PHP and UniApp to import data in batches. Applying this function to specific projects can greatly improve development efficiency and user experience. I hope this article is helpful to everyone, thank you for reading!

The above is the detailed content of How to use PHP and UniApp to implement batch import of data. For more information, please follow other related articles on the PHP Chinese website!