PHP MySQLi扩展面向过程连接数据库代码示例
<?php
//PHP MySQLi扩展面向过程连接数据库代码示例
/*------------------------------------------------------ */
//-- 数据库配置
/*------------------------------------------------------ */
$db_host = '127.0.0.1';
$db_user = 'root';
$db_password = 'root';
$db_database = 'study';
$db_port = '3306';
$db_charset = 'utf8';
$db_link = FALSE;
//连接数据库
@$db_link = mysqli_connect($db_host, $db_user, $db_password, $db_database, $db_port);
if (!$db_link) {
die('数据库连接失败,<br>错误信息: ' . mysqli_connect_error() . '<br>错误代码: ' . mysqli_connect_errno());
}
//设置字符集
mysqli_query($db_link, 'SET NAMES ' . $db_charset);
/*------------------------------------------------------ */
//-- 增删改查
/*------------------------------------------------------ */
//查询数据
$sql = 'SELECT * FROM `students` WHERE 1';
$res = mysqli_query($db_link, $sql);
$list = array();
while ($row = mysqli_fetch_assoc($res)) {
$list[] = $row;
}
//添加数据
$sql = 'INSERT INTO `students` (`sname`,`ssex`,`sbirthday`,`class`) VALUES ("小明","男","2018-11-05","123")';
$result = mysqli_query($db_link, $sql);
if ($result) {
echo "<script>alert('添加数据成功');</script>";
} else {
echo "<script>alert('添加数据失败');</script>";
}
//修改数据
$sql = 'UPDATE `students` SET `class`=456 WHERE `class`= 95033';
$result = mysqli_query($db_link, $sql);
if ($result) {
echo "<script>alert('修改数据成功');</script>";
} else {
echo "<script>alert('修改数据失败');</script>";
}
//删除数据
$sql = 'DELETE FROM `students` WHERE `sname`="小明" ';
$result = mysqli_query($db_link, $sql);
if ($result) {
echo "<script>alert('删除数据成功');</script>";
} else {
echo "<script>alert('删除数据失败');</script>";
}
