当前位置 博文首页 > u012442504的专栏:微擎数据库查询函数汇总,补充官方简洁后的参
官方给的真的是简化简化再简化后的函数……还是自己备份下吧,不去官方看函数,真坑……
ims_模块名_表名
//如
ims_health_moniter_orders
int | boolean
pdo_insert() - 对指定数据表插入一条新记录
参数
pdo_insert($tablename, $data = array(), $replace = false)
?
//案例
$arr=['name'=>'英语' ];
$result = pdo_insert('health_moniter_category', $arr, false);
int | boolean
参数
pdo_delete($tablename, $condition = array(), $glue = 'AND')
//例句
$result = pdo_delete('health_moniter_category', array('id'=>3));
var_dump($result)
array | boolean
参数
pdo_update($tablename, $data = array(), $condition, $glue = 'AND')
//例句
$result = pdo_update('health_moniter_category', array('name'=>'web编程'), array('id'=>1));
查单条
array | boolean
参数
tablename()
函数pdo_get($tablename, $condition = array(), $fields = array());
//例名
$result = pdo_get('health_moniter_course', array('id'=>1), array());
查多条
array | boolean
参数
tablename()
函数pdo_getall($tablename, $condition = array(), $fields = array(), $keyfield = '',$orderby = array(), $limit = array());
//例句
$result = pdo_getall('health_moniter_course', array(), array(), '',array('id DESC'), array());
//或者
$result = pdo_getall('health_moniter_course');
查多表
$sql="SELECT cou.*,cate.* FROM ims_health_moniter_course as cou inner JOIN ims_health_moniter_category as cate on (cou.category = cate.id)";
$result = pdo_fetchall($sql);
var_dump($result);
?
cs