<?php
require_once '../include.php';
error_reporting(E_ALL ^ E_NOTICE);
/**
?* 連接數(shù)據(jù)庫(kù)
?* @return resource
?*/


function connect(){
??? $link = mysqli_connect(DB_HOST,DB_USER,DB_PWD,DB_DBNAME) or die("數(shù)據(jù)庫(kù)連接失敗Error:".mysqli_errno($link).":".mysqli_error($link));
?? ?mysqli_set_charset($link,DB_CHARSET);
?? ?//mysqli_select_db(DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
?? ?return $link;
}
?
/**
?* 完成記錄插入的操作
?* @param string $table
?* @param array $array
?* @return number
?*/
function insert($table,$array){
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
?? ?$keys=join(",",array_keys($array));
?? ?$vals="'".join("','",array_values($array))."'";
?? ?$sql="insert {$table}($keys) values({$vals})";
?? ?mysqli_query($link,$sql);
?? ?return mysqli_insert_id($link);
}

/**
?*得到指定一條記錄
?* @param string $sql
?* @param string $result_type
?* @return multitype:
?*/
function fetchOne($sql,$result_type=MYSQLI_ASSOC){//ASSOC返回關(guān)聯(lián)詞組
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
??? $result=mysqli_query($link,$sql);
??? if (!$result) {
??????? //return bace;
??????? printf("Error: %s\n", mysqli_error($link));
??????? exit();
??? }
??? $row=mysqli_fetch_array($result,$result_type);
??? return $row;
}

/* function fetchOne($sql,$result_type=MYSQLI_ASSOC){
?? $result=mysqli_query($sql);
?? $row=mysqli_fetch_array($result,$result_type);
?? return $row;
} */

/* function fetchOne($sql,$result_type=MYSQL_ASSOC){
?$result=mysqli_query($link,$sql);
?$row=mysqli_fetch_array($result,$result_type);
?return $row;
?} */



//update MFY_admin set username='Queee' where id=1
/**
?* 記錄的更新操作
?* @param string $table
?* @param array $array
?* @param string $where
?* @return number
?*/
function update($table,$array,$where=null){
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");? ?
?? ?foreach($array as $key=>$val){
?? ???? //$str.=$sep.$key."='".$val."'";
?? ??? ?if($str==null){
?? ??? ??? ?$sep="";
?? ??? ?}else{
?? ??? ??? ?$sep=",";
?? ??? ?}
?? ??? ?$str.=$sep.$key."='".$val."'";
?? ?}
?? ??? ?$sql="update {$table} set {$str} ".($where==null?null:" where ".$where);
?? ??? ?$result=mysqli_query($link,$sql);
?? ??? ?var_dump($result);
?? ??? ?var_dump(mysqli_affected_rows($link));//exit;
?? ??? ?if($result){
?? ??? ??? ?return mysqli_affected_rows($link);
?? ??? ?}else{
?? ??? ??? ?return false;
?? ??? ?}
}

/**
?*?? ?刪除記錄
?* @param string $table
?* @param string $where
?* @return number
?*/
function delete($table,$where=null){
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
?? ?$where=$where==null?null:" where ".$where;
?? ?$sql="delete from {$table} {$where}";
?? ?mysqli_query($link,$sql);
?? ?return mysqli_affected_rows($link);
}



/**
?* 得到結(jié)果集中所有記錄 ...
?* @param string $sql
?* @param string $result_type
?* @return multitype:
?*/
function fetchAll($sql,$result_type=MYSQLI_ASSOC){
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
?? ?$result=mysqli_query($link,$sql);
?? ?while(@$row=mysqli_fetch_array($result,$result_type)){
?? ??? ?$rows[]=$row;
?? ?}
?? ?return $rows;
}

/**
?* 得到結(jié)果集中的記錄條數(shù)
?* @param unknown_type $sql
?* @return number
?*/
function getResultNum($sql){
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
?? ?$result=mysqli_query($link,$sql);
?? ?return mysqli_num_rows($result);
}

/**
?* 得到上一步插入記錄的ID號(hào)
?* @return number
?*/
function getInsertId(){
??? $link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數(shù)據(jù)庫(kù)鏈接失敗Error:".mysqli_errno().":".mysqli_errno());
??? mysqli_set_charset($link,DB_CHARSET);
??? mysqli_select_db($link,DB_DBNAME) or die("指定數(shù)據(jù)庫(kù)打開失敗");
?? ?return mysqli_insert_id($link);
}

看下你mysql.func.php代碼