搜索

---

🗣 Wd提问: php连接mysql 完整示例

🤖 Ai回答:
php
<?php
$servername = localhost;
$username = username;
$password = password;
$dbname = myDB;

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接
if ($conn-connect_error) {
die(连接失败: 、$conn-connect_error);
}
echo 连接成功;

// 使用 sql 创建数据表
$sql = CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
);

if ($conn-query($sql) === TRUE) {
echo 表 MyGuests 创建成功;
} else {
echo 创建表错误: 、$conn-error;
}

// 插入数据
$sql = INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@65.hk');

if ($conn-query($sql) === TRUE) {
echo 新记录插入成功;
} else {
echo Error: 、$sql 、<br 、$conn-error;
}

// 读取数据
$sql = SELECT id, firstname, lastname FROM MyGuests;
$result = $conn-query($sql);

if ($result-num_rows 0) {
// 输出数据
while($row = $result-fetch_assoc()) {
echo id: 、$row[id]、 Name: 、$row[firstname]、 、$row[lastname]、<br;
}
} else {
echo 0 结果;
}

$conn-close();
?

📣 商家广告：

---

---

👍 0 👎

IP地址: 115.25.35.100

搜索次数: 22

提问时间: 2025-11-25 19:46:28