函数封装Mysql

<?php

$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);

 

 

?>