PHP新手用的Insert和Update语句构造类

171 阅读 0 评论 113 点赞

我是靠谱客的博主老迟到棉花糖，最近开发中收集的这篇文章主要介绍PHP新手用的Insert和Update语句构造类，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

使用方法

复制代码代码如下:

 
$mysql = new sqlstr("table1"); 
$mysql->set("name","value"); 
$mysql->set("name","1",true); 
echo $mysql->insertSql(); 

复制代码代码如下:

 
class sqlstr 
{ 
private $param=array(); 
private $tablename; 
function sqlstr($tablename) 
{ 
$this->tablename = $tablename; 
} 
public function set($name,$value,$isnum=false){ 
$value = str_replace("'","''",$value); 
$this->param[$name]=array($value,$isnum); 
} 
public function insertSql(){ 
$keys=""; 
$values=""; 
foreach($this->param as $key =>$value){ 
$keys = $keys . $key . ","; 
if($value[1]){ 
$values = $values . $value[0] . ","; 
}else{ 
$values = $values . "'" . $value[0] . "',"; 
} 
} 
if($keys!=""){$keys=substr($keys,0,strlen($keys)-1) ;} 
if($values!=""){$values=substr($values,0,strlen($values)-1) ;} 
return "insert into " .$this->tablename ."($keys) values($values)"; 
} 
public function updateSql($cond){ 
$group=""; 
foreach($this->param as $key =>$value){ 
$group .= $key . "="; 
if($value[1]){ 
$group.= $value[0] . ","; 
}else{ 
$group.= "'" . $value[0] . "',"; 
} 
} 
if($group!=""){$group=substr($group,0,strlen($group)-1) ;} 
return "update " . $this->tablename ." set $group where " . $cond; 
} 
} 