如何使用PHP和Vue实现数据复制功能

CREATE TABLE original_data (
    id INT PRIMARY KEY AUTO_INCREMENT,
    content TEXT
);

CREATE TABLE copied_data (
    id INT PRIMARY KEY AUTO_INCREMENT,
    content TEXT
);

<?php
header('Content-Type: application/json');

$pdo = new PDO('mysql:host=localhost;dbname=your_database_name;charset=utf8', 'your_username', 'your_password');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $content = $_POST['content'];

    $insertSql = "INSERT INTO copied_data (content) VALUES (:content)";
    $statement = $pdo->prepare($insertSql);
    $statement->bindParam(':content', $content);
    $statement->execute();

    $result = ['success' => true];
} else {
    $result = ['success' => false, 'message' => 'Invalid request method'];
}

echo json_encode($result);
?>

<template>
  <div>
    <textarea v-model="originalData"></textarea>
    <button @click="copyData">复制</button>
  </div>
</template>

<script>
import axios from 'axios';

export default {
  data() {
    return {
      originalData: '',
    };
  },
  methods: {
    copyData() {
      axios.post('/api/copy_data.php', { content: this.originalData })
        .then(response => {
          if (response.data.success) {
            alert('复制成功！');
          } else {
            alert('复制失败，请重试。');
          }
        })
        .catch(error => {
          console.error(error);
          alert('服务器错误，请稍后再试。');
        });
    },
  },
};
</script>

import Vue from 'vue';
import App from './App.vue';

Vue.config.productionTip = false;

new Vue({
  render: h => h(App),
}).$mount('#app');