php连接mysql
版本区别
php7之前是mysql连接,之后是mysqli连接
连接步骤
- 链接数据库
- 判断是否连接成功
- 设置字符集
- 选择数据库
- 准备sql语句
- 发送sql语句
- 处理结果集
- 关闭数据库(释放资源)
<?php
$link = mysqli_connect('localhost','root','mysql');
if(!$link){
exit('数据库连接失败');
}else{
echo '数据库连接成功...';
}
mysqli_set_charset($link, 'utf8');
mysqli_select_db($link, 'phpsql');
$sql = 'select * from goods where gid <3';
$sql1 = 'insert into goods (gname,price,num)values("冰淇淋",12.5,999)';
$obj = mysqli_query($link , $sql);
$obj1 = mysqli_query($link , $sql1);
//var_dump($obj);
$res = mysqli_fetch_assoc($obj); //查询关联数组
/*
E:\PHP\www\phpsql.php:28:
array (size=4)
'gid' => string '1' (length=1)
'gname' => string '果冻' (length=6)
'price' => string '15' (length=2)
'num' => string '99' (length=2)
*/
//$res = mysqli_fetch_row($obj); //索引数组 每次读取一行
//$res = mysqli_fetch_array($obj); //既带索引又带数组
//$res = mysqli_num_rows($obj); //结果有几条
//$res = mysqli_affected_rows($link); //查询有几条
$resq = mysqli_insert_id($link); //在第几行插入
var_dump($resq);
mysqli_close($link);
数据库信息示例:
//query.php
<?php
$link = mysqli_connect('localhost','root','mysql');
if(!$link){
echo('数据库连接失败');
}else{
echo('数据库连接成功....<br />');
}
mysqli_set_charset($link,'utf8');
mysqli_select_db($link,'phpsql');
$sql = "select count(*) as count from goods";
$obj = mysqli_query($link,$sql);
var_dump($_GET);
// 分页
$page = empty($_GET['page']) ? 1 : $_GET['page'];
$pageRes = mysqli_fetch_assoc($obj);
//var_dump($pageRes['count']);
$count = $pageRes['count'];
// 每页显示5条
$num = 5;
$pageCount = ceil($count