PHP中使用Insert、Update語句的構造類

$mysql = new sqlstr("table1"); $mysql->set("name","value"); $mysql->set("name","1",true); echo $mysql->insertSql(); 複製代碼 2，insert與update實現的php構造類 /** * Insert、Update語句的構造類 * edit: bbs.it-home.org */ 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; } } 複製代碼

