首頁猿問求改為mysqli格式

求改為mysqli格式

MySQL PHP 數(shù)據(jù)結(jié)構(gòu)

我是個9527 2017-01-03 11:13:05

function?connect(){ ???$link=mysql_connect(DB_HOST,DB_USER,DB_PWD)?or?die("數(shù)據(jù)庫連接失敗Error:".mysql_errno().":".mysql_error()); ???mysql_set_charset(DB_CHARSET); ???mysql_select_db(DB_DBNAME)?or?die("指定數(shù)據(jù)庫打開失敗"); ???return?$link; } /** ?*?完成記錄插入的操作 ?*?@param?string?$table ?*?@param?array?$array ?*?@return?number ?*/ 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(); } //update?imooc_admin?set?username='king'?where?id=1 /** ?*?記錄的更新操作 ?*?@param?string?$table ?*?@param?array?$array ?*?@param?string?$where ?*?@return?number ?*/ 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; ??????} } /** ?*?刪除記錄 ?*?@param?string?$table ?*?@param?string?$where ?*?@return?number ?*/ function?delete($table,$where=null){ ???$where=$where==null?null:"?where?".$where; ???$sql="delete?from?{$table}?{$where}"; ???mysql_query($sql); ???return?mysql_affected_rows(); } /** ?*得到指定一條記錄 ?*?@param?string?$sql ?*?@param?string?$result_type ?*?@return?multitype: ?*/ function?fetchOne($sql,$result_type=MYSQL_ASSOC){ ???$result=mysql_query($sql); ???$row=mysql_fetch_array($result,$result_type); ???return?$row; } /** ?*?得到結(jié)果集中所有記錄?... ?*?@param?string?$sql ?*?@param?string?$result_type ?*?@return?multitype: ?*/ function?fetchAll($sql,$result_type=MYSQL_ASSOC){ ???$result=mysql_query($sql); ???while(@$row=mysql_fetch_array($result,$result_type)){ ??????$rows[]=$row; ???} ???return?$rows; } /** ?*?得到結(jié)果集中的記錄條數(shù) ?*?@param?unknown_type?$sql ?*?@return?number ?*/ function?getResultNum($sql){ ???$result=mysql_query($sql); ???return?mysql_num_rows($result); } /** ?*?得到上一步插入記錄的ID號 ?*?@return?number ?*/ function?getInsertId(){ ???return?mysql_insert_id(); }

查看完整描述

2 回答

慕妹0947187

TA貢獻1條經(jīng)驗獲得超2個贊

<?php
/**
?*?Created?by?PhpStorm.
?*?User:?Administrator
?*?Date:?2017/1/3
?*?Time:?15:26
?*/
require_once?'../include.php';
header("Content-Type:text/html;charset=utf-8");

function?connect()
{
????$mysqli?=?new?mysqli(DB_HOST,DB_USER,DB_PWD,DB_DBNAME);
????if?($mysqli->connect_error)?{
????????die('Connect?Error?('?.?$mysqli->connect_errno?.?')?'.?$mysqli->connect_error);

????}
????$mysqli->set_charset(DB_CHARSET);
????return?$mysqli;
}
function?insert($table,$array)
{
????$keys?=?join(",",array_keys($array));
????$vals="'".join("','",array_values($array))."'";
????$sql="insert?{$table}($keys)?values({$vals})";
????$link?=?connect();
????mysqli_query($link,$sql);
????return??mysqli_insert_id($link);
}
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);
????$link?=?connect();
????mysqli_query($link,$sql);
????return?mysqli_affected_rows($link);
}
function?delete($table,$where?=?null)
{
????$where?=?($where?==?null?null:"where".$where);
????$sql?=??"delete?from?{$table}{$where}";
????$link?=?connect();
????mysqli_query($link,$sql);
????return?mysqli_affected_rows($link);
}
function?fetchOne($sql,$result_type?=?MYSQLI_ASSOC)
{
????$link?=?connect();
????$result?=?mysqli_query($link,$sql);
????$row?=?mysqli_fetch_array($result,$result_type);
????return?$row;
}
function?fetchAll($sql,$result_type?=?MYSQLI_ASSOC)
{
????$link?=?connect();
????$result?=?mysqli_query($link,$sql);
????while?(@$row?=?mysqli_fetch_array($result,$result_type))
????{
????????$row[]?=?$row;
????}
????return?$row;
}
function?getResultNum($sql)
{
????$link?=?connect();
????$result?=?mysqli_query($link,$sql);
????return?mysqli_num_rows($result);
}

2 反對回復 2017-01-05