$servername = "localhost";$username = "username";$password = "password";$dbname = "myDBPDO";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // 设置 PDO 错误模式为异常
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// 预处理 SQL 并绑定参数
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, email)
VALUES (:firstname, :lastname, :email)"); $stmt->bindParam(':firstname', $firstname); $stmt->bindParam(':lastname', $lastname); $stmt->bindParam(':email', $email);
// 插入行
$firstname = "John"; $lastname = "Doe"; $email = "john@example.com"; $stmt->execute();
// 插入其他行
$firstname = "Mary"; $lastname = "Moe"; $email = "mary@example.com"; $stmt->execute();
// 插入其他行
$firstname = "Julie"; $lastname = "Dooley"; $email = "julie@example.com"; $stmt->execute();
echo "新记录插入成功";}catch(PDOException $e){
echo "Error: " . $e->getMessage();}$conn = null;
-
您身边的网站建设推广专家
专注营销型网站建设 . 搜索引擎全网覆盖推广 . 打造移动互联网
全国咨询热线
