<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2017/10/9
* Time: 9:58
*/
//require_once "../include.php";
//require_once "../configs/configs.php";
function connect()
{
$mysqli = new mysqli('localhost', 'root', '', 'shopimooc');
//var_dump($mysqli);
if ($mysqli->connect_error > 0) {
echo "连接错误";
echo $mysqli->connect_error;
exit;
}
$mysqli->query("SET NAMES UTF8"); //设置数据库字符集
return $mysqli;
}
function insert($table,$array)
{
$conn=connect();
$keys="".join(",",array_keys($array));
$vals="'".join("','",array_values($array))."'";
$sql="INSERT INTO {$table} ({$keys})VALUES ({$vals})";
if ($conn->query($sql) === TRUE) {
return null;
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
return $sql;
}
}
function update($table,$array,$where=null)
{
$sql="update {$table} set cName='{$array}' ".($where==null?null:" where ").$where;
// 如果没有传入判断条件,即为空,这里 $where==null? 为1 传入条件 即非空,那么执行传入的where 语句
//update shop_admin set username= "king" where id=1
//可以参照这句话 表达式1是否为真,如果为真,执行表达式2,要么执行表达式3 因为$where 为条件,例如id=1
//所以是"where".$where
mysqli_query(connect(),$sql);
return mysqli_affected_rows(connect());
}
function delete($table,$where)
{
$where= $where==null?null:" where ".$where;
$sql ="delete from {$table}{$where}";
mysqli_query($sql);
return mysqli_affected_rows();
}
/*查找操作,查找一条记录*/
function fetchOne($sql,$result_type=MYSQLI_ASSOC){
$result=mysqli_query(connect(),$sql);
if ($result->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
return $row;
}
} else {
echo "0 个结果";
}
}
/*查找操作,获取所有记录*/
function fetchAll($sql,$result_type=MYSQLI_ASSOC){
//$result_type = MYSQL_ASSOC这个返回的数组是以数据表中的字段为键的而MYSQL_NUM是以数字为键搜索的
$conn=connect();
$result=$conn->query($sql);
if ($result->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
$rows[]=$row;
}
} else {
echo "0 个结果";
}
return $rows;
}
/*获取记录条数*/
function getResultNum($sql){
$conn=connect();
$result=$conn->query($sql);
$totalRows=$result->num_rows;
return $totalRows;
}
php封装msql 常用函数 增删改查 mysqli
最新推荐文章于 2023-02-03 14:01:40 发布