php7.0mysql函数_php7.0以上mysql工具函数

/**

连接数据库

@return resource

/

function connect(){

$mysqli=new mysqli('localhost', 'root', '', 'shopimooc');

if($mysqli->connect_errno>0){

echo "连接错误";

echo $mysqli->connect_error;

exit;

}

$mysqli->query("SET NAMES UTF8");

return $mysqli ;

}

$con=connect();

//得到指定一条记录

/function fetchOne($sql,$result_type=MYSQL_ASSOC){

$result=mysql_query($sql);

$row=mysql_fetch_array($result,$result_type);

return $row;

}

*/

function fetchOne($query,$type="assoc"){

global $con;

$query=mysqli_query($con,$query);

if(!in_array($type,array("assoc","array","row")))

{

die("mysqli_query error");

}

$funcname="mysqlifetch".$type;

return $funcname($query);

}

/function insert($table,$array){

$keys=join(",",array_keys($array));

$vals="'".join("','",array_values($array))."'";

$sql="insert {$table}($keys) values({$vals})";

mysql_query($sql);

return mysql_insert_id();

}/

function insert($table,$array){

global $con;

$keys=join(",",array_keys($array));

$vals="'".join("','",array_values($array))."'";

$sql="insert {$table}($keys) values({$vals})";

mysqli_query($con,$sql);

return mysqli_insert_id($con);

}

/function update($table,$array,$where=null){

foreach($array as $key=>$val){

if($str==null){

$sep="";

}else{

$sep=",";

}

$str.=$sep.$key."='".$val."'";

}

$sql="update {$table} set {$str} ".($where==null?null:" where ".$where);

$result=mysql_query($sql);

//var_dump($result);

//var_dump(mysql_affected_rows());exit;

if($result){

return mysql_affected_rows();

}else{

return false;

}

}/

function update($table,$array,$where=null){

global $con;

foreach($array as $key=>$val){

if($str==null){//报错str未被定义

$sep="";

}else{

$sep=",";

}

$str.=$sep.$key."='".$val."'";

}

$sql="update {$table} set {$str} ".($where==null?null:" where ".$where);

$result=mysqli_query($con,$sql);

//var_dump($result);

//var_dump(mysql_affected_rows());exit;

if($result){

return mysqli_affected_rows($con);

}else{

return false;

}

}

/function delete($table,$where=null){

$where=$where==null?null:" where ".$where;

$sql="delete from {$table} {$where}";

mysql_query($sql);

return mysql_affected_rows();

}/

function delete($table,$where=null){

global $con;

$where=$where==null?null:" where ".$where;

$sql="delete from {$table} {$where}";

mysqli_query($con,$sql);

return mysqli_affected_rows($con);

}

/function fetchAll($sql,$result_type=MYSQL_ASSOC){

$result=mysql_query($sql);

while(@$row=mysql_fetch_array($result,$result_type)){

$rows[]=$row;

}

return $rows;

}/

function fetchAll($sql,$type="assoc"){

global $con;

$query=mysqli_query($con,$sql);

if(!in_array($type,array("assoc",'array',"row"))){

die("mysqli_query error");

}

$funcname="mysqlifetch".$type;

while(@$row=$funcname($query)){

$rows[]=$row;

}

return $rows;

}

/*

function getResultNum($sql){

$result=mysql_query($sql);

return mysql_num_rows($result);

}

/

function getResultNum($sql){

global $con;

$result=mysqli_query($con,$sql);

return mysqli_num_rows($result);

}

/

function getInsertId(){

return mysql_insert_id();

}

*/

function getInsertId(){

global $con;

return mysqli_insert_id($con);

}

打开App，阅读手记