<?php
$servername = "localhost:3305"; //数据库地址
$username = "root"; //数据库name
$password =""; //密码
$dbname ="myDB"; //要链接的数据库
$conn = new mysqli($servername,$username,$password,$dbname);
// 面向对象的链接数据方法
if($conn ->connect_error)
{
die('链接失败:' . $conn ->connect_error);
}
// 插入数据
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Mary', 'Moe', 'mary@example.com');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Julie', 'Dooley', 'julie@example.com')";
if($conn ->multi_query($sql) === TRUE)
{
//判断 为true时 新纪录插入成功
echo "新纪录插入成功";
}else
{
echo "ERROR" . $sql . "<br>".$conn ->error;
}
?>
PHP链接插入数据
最新推荐文章于 2024-04-22 18:15:02 发布