PHP自动生成可靠SQL语句的函数[原创]

xiaoyu28

PHP自动构建可靠SQL的函数。
用法很简单，看看函数就知道了。我就不多说了，呵呵。
这几个函数会给日常开发带来很多便利。


<?php//作者：longbill (longbill.cn#gmail.com)
function make_insert_sql($table,$data) {     
$cols = array();     
$vals = array();     
foreach($data as $key =&gt; $val)   
  {        
$cols[] = "`$key`";        
$vals[] = "'".mysql_escape_string($val)."'";   
  }     
return "INSERT INTO `$table` (".join(',',$cols).") VALUES(".join(',',$vals).") "; } function make_select_sql($table,$data = array(),$_select = '*') {     $cond = array();     foreach($data as $key =&gt; $val)         $cond[] = "`$key` = '".mysql_escape_string($val)."' ";     $sql = "SELECT $_select FROM `$table` ";     if (count($cond) &gt; 0)         $sql.= " WHERE ".join(' AND ',$cond);     else         $sql.= " WHERE 1=1 ";     return $sql; } function make_update_sql($table,$data,$cond_arr) {     $values = array();     $cond = array();     foreach($data as $key =&gt; $val)         $values[] = "`$key` = '".mysql_escape_string($val)."'";     foreach($cond_arr as $key =&gt; $val)         $cond[] = "`$key` = '".mysql_escape_string($val)."'";     return "UPDATE `$table` SET ".join(',',$values)." WHERE ".join(' AND ',$cond); }?>