使用方法 <div class="codetitle"><a style="CURSOR: pointer" data="44916" class="copybut" id="copybut44916" onclick="doCopy('code44916')"> 代码如下:<div class="codebody" id="code44916"> $mysql = new sqlstr("table1"); $mysql->set("name","value"); $mysql->set("name","1",true); echo $mysql->insertSql(); <div class="codetitle"><a style="CURSOR: pointer" data="36630" class="copybut" id="copybut36630" onclick="doCopy('code36630')"> 代码如下:<div class="codebody" id="code36630"> 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,strlen($keys)-1) ;} if($values!=""){$values=substr($values,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,strlen($group)-1) ;} return "update " . $this->tablename ." set $group where " . $cond; } }
(编辑:安卓应用网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|