function update($table, $array, $where = null)
{
//error_reporting(E_ALL ^ E_DEPRECATED);
foreach ($array as $key => $val) {
if (@$str == null) {
$sep = "";
} else {
$sep = ",";
}
$str .=join(",","{$key}") . "='" . $val . "'";
}
$sql = "update {$table} set {$str}" .($where == null ? null : "where" . $where);
$result=mysqli_query(connect(),$sql);
return $result;
}
2016-02-21
function update($table,$array,$where=null){
$str = "";
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);
mysql_query($sql);
return mysql_affected_rows();
}
function update($table,$array,$where=null) {
$str="";
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);
if($result){
return mysql_affected_rows();
}else{
return false;
}
}
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;
}
}举报
