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

最新推荐文章于 2021-04-13 15:32:10 发布

dodomail

最新推荐文章于 2021-04-13 15:32:10 发布

阅读量290

点赞数

分类专栏： php 文章标签： SQL PHP MySQL Gmail

本文链接：https://blog.csdn.net/dodomail/article/details/83498284

版权

php 专栏收录该内容

60 篇文章 0 订阅

订阅专栏

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

<?php//作者：longbill (longbill.cn#gmail.com)
function make_insert_sql($table,$data) {
$cols = array();
$vals = array();
foreach($data as $key => $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 => $val) $cond[] = "`$key` = '".mysql_escape_string($val)."' "; $sql = "SELECT $_select FROM `$table` "; if (count($cond) > 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 => $val) $values[] = "`$key` = '".mysql_escape_string($val)."'"; foreach($cond_arr as $key => $val) $cond[] = "`$key` = '".mysql_escape_string($val)."'"; return "UPDATE `$table` SET ".join(',',$values)." WHERE ".join(' AND ',$cond); }?>