全局变量
//MySQL数据库服务器的地址 $host="localhost"; //连接MySQL数据库服务器的用户名 $DB_userName="root"; //连接MySQL数据库服务器的密码 $DB_pwd=""; //连接MySQL数据库名称 $DBName="database";
1、连接数据库
function connectDB()
{
global $host ,$DB_userName,$DB_pwd,$DBName;
$conn=new mysqli($host,$DB_userName,$DB_pwd,$DBName);
if(!$conn){
return null;
}
return $conn;
}
扩展:mysqli_connect_errno()判断连接数据库能否成功。
2、获取数据
function DB_helper_Query($sql){
$conn=connectDB();
try
{
if($conn==null)
return null;
//mysqli_query()发送select会得到结果集数据
mysqli_query($conn,"set names utf8");
$rs=mysqli_query($conn,$sql);
$result = mysqli_fetch_all($rs, MYSQLI_BOTH);//MYSQLI_ASSOC);//判断搜索是否成功
return $result;
}
finally
{
if($conn!=null)
mysqli_close($conn);
}
}
查:
$selectSql="select * from usergoods where id='".$id."' "; $result=DB_helper_Query($selectSql);
3、增删修(更新)数据
function DB_helper_NOQuery($sql){
$conn=connectDB();
try {
if ($conn == null)
return 0;
//mysqli_query向服务器发送insert 、update、delete请求
@mysqli_query($conn, "set names utf8");
$rs = @mysqli_query($conn, $sql);
//获取操作行数
$insertLineCount = @$conn->affected_rows;
if ($insertLineCount == -1) {
return 0;
} else {
return 1;
}
}
finally
{
if($conn!=null)
//关闭数据库
@mysqli_close($conn);
}
}
增:
$insertSql="insert into users VALUES ('".$id."','".$userName."','".$pwd."')"; $result=DB_helper_NOQuery($insertSql);
删:
$deleteSql="delete from users where id='".$id."'"; DB_helper_NOQuery($deleteSql);
改:
$sql="update users set userName='".$username."' where id='".$id."'"; $result=DB_helper_NOQuery($sql);