走向成功：PHP和Vue开发脑图功能的迅猛发展趋势

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建数据表
$sql = "CREATE TABLE MindMap (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
parent_id INT(6) UNSIGNED,
content VARCHAR(200) NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "脑图节点表创建成功！";
} else {
    echo "创建脑图节点表失败: " . $conn->error;
}

$conn->close();
?>

<template>
  <div class="mindmap-node">
    <div class="content">{{ nodeContent }}</div>
    <ul v-if="node.children && node.children.length > 0">
      <li v-for="(child, index) in node.children" :key="index">
        <MindMapNode :node="child"></MindMapNode>
      </li>
    </ul>
  </div>
</template>

<script>
export default {
  name: 'MindMapNode',
  props: {
    node: {
      type: Object,
      required: true
    }
  },
  data() {
    return {
      nodeContent: ''
    }
  },
  mounted() {
    this.nodeContent = this.node.content
  }
}
</script>

<template>
  <div class="form">
    <input type="text" v-model="nodeContent" placeholder="输入节点内容">
    <button @click="addNode">添加节点</button>
  </div>
</template>

<script>
export default {
  name: 'AddNode',
  data() {
    return {
      nodeContent: ''
    }
  },
  methods: {
    addNode() {
      // 发送Ajax请求，将脑图节点内容发送给后端PHP脚本进行处理
      axios.post('/api/add-node', { content: this.nodeContent })
        .then(response => {
          console.log(response.data)
        })
        .catch(error => {
          console.log(error)
        })
    }
  }
}
</script>