《cakePHP常用数据操作方法总结.docVIP

CakePHP常用数据操作方法总结 测试相关信息 数据表 (1)zmkm_tests Id int(11) primary key Name char(10) Password char(32) Type tinyint(2) zmkm_relations Id int(11) primary key Test_id int(11) Content text Model:Test,Relation Controller:test,relation 查询 find($type,$params) I. $params,查询的限制条件,格式如下 $params = array( conditions = array(SQL中的where条件), fields = array(查询字段), order = array(排序字段,SQL中的order by 条件), group = array(分组字段,SQL中的group by 条件), limit = m,n, // 查询记录条数,SQL中limit page =n // 还有recursive和callbacks等不常用的参数,略过 ); II.$type,查询的类型 $type = first,find的默认参数,查找符合条件的第一条数据. 示例1: 查找数据表中第一条记录 $lists = $this-Test-find(); SQL:SELECT `Test`.`Id`, `Test`.`name`, `Test`.`password`, `Test`.`type` FROM `zmkm_tests` AS `Test` WHERE 1 = 1 LIMIT 1 结果: $lists = array( [Test]= array( Id=1 name password=2f441e566f1bbb7d1faaf32 type=3 ) ) 示例2:查找一条type=1的记录 $lists = $this-Test-find(first,array(conditions=array(Test.type = 1))); SQL:SELECT `Test`.`Id`, `Test`.`name`, `Test`.`password`, `Test`.`type` FROM `zmkm_tests` AS `Test` WHERE `Test`.`type` = 1 LIMIT 1 结果:$lists = array( Test= array( Id=3 name password=5997124ee980322f8a62a758dda4deee type=1 ) ) $type = all,查找所有符合条件的记录 示例:查找所有type为[1,2,3]的记录 $lists = $this-Test-find(all,array(conditions = array(Test.type = array(1,2,3)))); SQL:SELECT `Test`.`Id`, `Test`.`name`, `Test`.`password`, `Test`.`type` FROM `zmkm_tests` AS `Test` WHERE `Test`.`type` IN (1, 2, 3) 结果: $lists = array( 0 = array(Test=array(id=1,name=)), 1=array() ... ); $type = list,返回一个索引数组,key第一列字段,若不指定fields,则value为第二列的字段 示例:查找 10id20 的记录,按type排序 $condition = array( conditions=array(Test.id Between ? And ? = array(10,20)), order = Test.type desc ); $lists = $this-Test-find(list,$condition); SQL:SELECT `Test`.`id`, `Test`.`name` FROM `zmkm_tests` AS `Test` WHERE `Test`.`id` Between 10 And 20 ORDER BY `Test`.`type` DESC 结果: $lists = array(12 =, 10, ); $type = count , 计数,返回一个整数 示例:查