phpcms创建表单自我介绍

<form action="submit.php" method="post">
    <label for="name">姓名：</label>
    <input type="text" id="name" name="name" required><br><br>
    
    <label for="introduction">自我介绍：</label><br>
    <textarea id="introduction" name="introduction" rows="4" cols="50" required></textarea><br><br>
    
    <input type="submit" value="提交">
</form>

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

// 检查连接
if ($db->connect_error) {
    die("连接失败: " . $db->connect_error);
}

// 获取表单数据
$name = $_POST['name'];
$introduction = $_POST['introduction'];

// 插入数据到数据库
$sql = "INSERT INTO introductions (name, introduction) VALUES (?, ?)";
$stmt = $db->prepare($sql);
$stmt->bind_param("ss", $name, $introduction);
$stmt->execute();

echo "提交成功！";

// 关闭连接
$stmt->close();
$db->close();
?>