PHP连接mysql

php连接mysql

版本区别

php7之前是mysql连接,之后是mysqli连接

连接步骤

1. 链接数据库
2. 判断是否连接成功
3. 设置字符集
4. 选择数据库
5. 准备sql语句
6. 发送sql语句
7. 处理结果集
8. 关闭数据库(释放资源)

<?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