php7.0以上mysql工具函数

<?php

/**

• 连接数据库
• @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);
}