遍历某个表中的所有内容
\Phpcmf\Service::M()->db->table("dr_1_tag")->get()获取当前表前缀:
\Phpcmf\Service::M()->db->DBPrefix;
指定条件查询:
\Phpcmf\Service::M()->db->table($dbPrefix.SITE_ID.'_tag')->select('id','name')->get();单条结果:
getRowArray() \Phpcmf\Service::M()->db->query($data)->getRowArray()
结果集数组:
getResultArray() \Phpcmf\Service::M()->db->query($data)->getResultArray()
数据入库:
\Phpcmf\Service::M()->db->table('member_dowlog')->insert();
示例:
\Phpcmf\Service::M()->db->table('member_dowlog')->insert([
'cid' => $post_id,
'title' => $post_title,
'uid' => $post_mbrid,
'inputtime' => $post_inputtime,
]);批量插入:
$data = [
['name'=>'Token'],
['name'=>'Token'],
['name'=>'Token'],
['name'=>'Token'],
];
\Phpcmf\Service::M()->db->table('1_fwquery')->insertBatch($data)