phpcms的增删改查操作整理

一、查

①select($where = '', $data = '*', $limit = '', $order = '', $group = '', $key='')

②listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key='', $setpages = 10,$urlrule = '',$array = array(), $data = '*')

③get_one($where = '', $data = '*', $order = '', $group = '')

④query($sql)

二、增

①insert($data, $return_insert_id = false, $replace = false)

②insert_id()

三、改

①update($data, $where = '')

'phpcms','password'=>'123456')]
     *                        数组的另一种使用array('name'=>'+=1', 'base'=>'-=1');程序会自动解析为`name` = `name` + 1, `base` = `base` - 1
     * @param $where         更新数据时的条件,可为数组或字符串
     * @return boolean
     

四、删

① delete($where)