mysql函数封装_函数封装Mysql

$conn=mysql_connect('localhost','root','257962');

$sql = 'use test';

mysql_query($sql,$conn);

function getAll($sql,$conn){

$res=mysql_query($sql,$conn);

$rs=array();

while($row=mysql_fetch_assoc($res)){

$rs[]=$row;

}

return $rs;

}

$sql='select * from stu';

$stus=getAll($sql,$conn);

//print_r($stus);

function getRow($sql,$conn){

$res= mysql_query($sql,$conn);

$rs=mysql_fetch_assoc($res);

return $rs;

}

$sql='select * from stu';

$stus=getRow($sql,$conn);

//print_r($stus);

function getOne($sql,$conn){

$res=mysql_query($sql,$conn);

$rs=mysql_fetch_row($res);

return $rs[0];

}

$sql='select count(*) from stu';

$stus=getOne($sql,$conn);

print_r($stus);

?>