PHP中使用Insert、Update语句的构造类

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

复制代码

2，insert与update实现的php构造类

2. /**
3. * Insert、Update语句的构造类
4. * edit: bbs.it-home.org
5. */
6. class sqlstr
7. {
8. private $param=array();
9. private $tablename;
10. function sqlstr($tablename)
11. {
12. $this->tablename = $tablename;
13. }
14. public function set($name,$value,$isnum=false){
15. $value = str_replace("'","''",$value);
16. $this->param[$name]=array($value,$isnum);
17. }
18. public function insertSql(){
19. $keys="";
20. $values="";
21. foreach($this->param as $key =>$value){
22. $keys = $keys . $key . ",";
23. if($value[1]){
24. $values = $values . $value[0] . ",";
25. }else{
26. $values = $values . "'" . $value[0] . "',";
27. }
28. }
29. if($keys!=""){$keys=substr($keys,0,strlen($keys)-1) ;}
30. if($values!=""){$values=substr($values,0,strlen($values)-1) ;}
31. return "insert into " .$this->tablename ."($keys) values($values)";
32. }
33. public function updateSql($cond){
34. $group="";
35. foreach($this->param as $key =>$value){
36. $group .= $key . "=";
37. if($value[1]){
38. $group.= $value[0] . ",";
39. }else{
40. $group.= "'" . $value[0] . "',";
41. }
42. }
43. if($group!=""){$group=substr($group,0,strlen($group)-1) ;}
44. return "update " . $this->tablename ." set $group where " . $cond;
45. }
46. }

复制代码