PHP链接数据库的步骤
<?php
//1链接数据库
$link = @mysqli_connect('localhost','root','123456');
//2判断错误
if (mysqli_connect_errno($link)) {
echo mysqli_connect_error($link);exit;
}
//3选择数据库
mysqli_select_db($link,'demo');
//4选择字符集
mysqli_set_charset($link,'utf8');
//5准备sql语句
//查询语句
$sql = "SELECT name FROM users";
//增删改语句
$sql = "INSERT INTO users(id,name) VALUES(NULL,'jake')";
//6发送sql语句
$result = mysqli_query($link,$sql);
//7处理结果集
//取得查询结果集的总数(查询)
mysqli_num_rows($result);
//返回影响的行数(增删改)
mysqli_affected_rows($result);
//8关闭数据库
mysqli_close($link);
?>