#######################
### Mysqli(面向过程) ###
#######################
// localhost数据库服务器(host) root数据库用户名(user) password数据库密码(password) database数据库名(database)
$conn = mysqli_connect('localhost', 'root', 'password', 'database'); // 连接数据库
// 连接数据库错误提示
if (mysqli_connect_errno($conn)) {
die("连接 MySQL 失败: " . mysqli_connect_error());
}
mysqli_query($conn, "set names utf8"); // 数据库编码格式
// mysqli_set_charset($conn, "utf8"); // 设置默认客户端字符集。
// mysqli_select_db($conn, 'database_2'); // 更改连接的默认数据库
//查询代码
$sql = "select * from db_table";
$query = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
echo '<pre>';
print_r($row);
}
// 释放结果集 关闭MySQL数据库连接
mysqli_free_result($query);
mysqli_close($conn);
#######################
### Mysqli(面向对象) ###
#######################
$conn = new mysqli('localhost', 'root', 'password', 'database');
if ($conn->connect_errno) {
printf("Connect failed: %s\n", $conn->connect_error);
exit();
}
// 查询代码
$sql = "select * from db_table";
$query = $conn->query($sql, MYSQLI_USE_RESULT);
while ($row = $query->fetch_array()) {
echo '<pre>';
print_r($row);
}
// 释放结果集 关闭MySQL连接
$query->free_result();
$conn->close();
#########################
### PDO连接MySQL数据库 ###
#########################
$serve = 'mysql:host=数据库地址;dbname=数据库名; charset=utf8';
$username = 数据库帐号;
$password = 数据库密码;
$pdo = new PDO($serve, $username, $password);
// $pdo = new PDO('mysql:host=localhost; dbname=数据库名; charset=utf8', '数据库帐号', '数据库密码');
// 插入(新增)数据
$user_id = rand(10000, 99999);
$username = rand(10000, 99999);
$password = rand(10000, 99999);
$login = rand(10000, 99999);
try {
$sql = "INSERT INTO `uco_user` (`user_id`, `username`, `password`, `expiry` ,`login`) VALUES ({$user_id}, '$username', '$password', '" . time() . "', '$login')";
// 成功返回结果条数
$res = $pdo->exec($sql);
} catch (Exception $e) {
$pdo->rollBack();
echo "Failed: " . $e->getMessage();
}
if ($res) {
var_dump('成功插入' . $res . '条数据');
// 插入成功后返回插入数据的ID
var_dump($pdo->lastinsertid());
} else {
var_dump('插入失败');
}
// 更新(修改)数据
try {
$sql = "UPDATE `uco_user` SET `user_id`={$user_id} WHERE `login` = 91903";
// $sql = "UPDATE `uco_user` SET `user_id`={$user_id} WHERE `login` LIKE 91903";
// 成功返回结果条数
$res = $pdo->exec($sql);
} catch (Exception $e) {
$pdo->rollBack();
echo "Failed: " . $e->getMessage();
}
if ($res) {
// 更新条数
var_dump('成功更新' . $res . '条数据');;
} else {
var_dump('更新失败');
}
// 删除数据
try {
$sql = "DELETE FROM `uco_user` WHERE `login` = 58834";
// $sql = "DELETE FROM `uco_user` WHERE `login` LIKE 58834";
$res = $pdo->exec($sql);
} catch (Exception $e) {
$pdo->rollBack();
echo "Failed: " . $e->getMessage();
}
if ($res) {
// 删除条数
var_dump('成功删除' . $res . '条数据');
} else {
var_dump('删除失败');
}
// 查询数据
try {
$sql = "SELECT * FROM `uco_user` WHERE `login` = 91903";
//$sql = "SELECT * FROM `uco_user` WHERE `login` LIKE 91903";
$res = $pdo->query($sql);
$data = [];
while ($row = $res->fetchAll(PDO::FETCH_ASSOC)) {
// while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
$data = $row;
}
} catch (Exception $e) {
$pdo->rollBack();
echo "Failed: " . $e->getMessage();
}
echo '<pre>';
var_dump($data);