PHP与MySQL数据库交互（PDOMySQLi）

PHP与MySQL数据库交互（PDO/MySQLi）

代码示例：PDO用户注册

php

<?php

$dsn = "mysql:host=localhost;dbname=test;charset=utf8mb4";

$pdo = new PDO($dsn, "

if ($_SERVER["REQUEST_METHOD"] == "POST") {

$stmt = $pdo->prepare("INSERT INTO users (name, email) VALUES (?, ?)");

$stmt->execute([$_POST['name'], $_POST['email']]);

echo "注册成功！";

}

?>

<form method="post">

<input type="text" name="name" placeholder="用户名">

<input type="email" name="email" placeholder="邮箱">

<button type="submit">注册</button>

</form>