<form action="submit.php" method="post">
<p>姓名: <input type="text" name="name"></p>
<p>年齡: <input type="number" name="age"></p>
<p>性別: <input type="radio" name="gender" value="male">男
<input type="radio" name="gender" value="female">女</p>
<p>個人愛好: <input type="checkbox" name="hobby" value="reading">閱讀
<input type="checkbox" name="hobby" value="music">音樂
<input type="checkbox" name="hobby" value="sports">運動</p>
<input type="submit" value="提交">
</form>

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
// 創建連接
$conn = new mysqli($servername, $username, $password, $dbname);
// 檢查連接是否成功
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// 處理表單提交
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = $_POST["name"];
$age = $_POST["age"];
$gender = $_POST["gender"];
$hobby = $_POST["hobby"];
// 插入數據到數據庫中
$sql = "INSERT INTO users (name, age, gender, hobby) VALUES ('$name', '$age', '$gender', '$hobby')";
if ($conn->query($sql) === TRUE) {
echo "數據插入成功";
} else {
echo "數據插入失敗: " . $conn->error;
}
}
$conn->close();
?>