Difference between select and find in thinkphp

Thinkphp is a good php development framework that can quickly develop a management system with MVC architecture. we need to use the select () and find () methods. both methods can return a dataset array.

Thinkphp is a good php development framework that can quickly develop a management system with MVC architecture. we need to use the select () and find () methods. both methods can return a dataset array, but what's the difference? Let's take a look at my code comparison:

1. $ Tech = M ('techlevel', 'HR _ CS _ ', 'DB _ config2 ');
2. $ Data = $ tech-> where ('Id = 1')-> find ();
3. Dump ($ Data );
4. $ Data = $ tech-> where ('Id = 1')-> select ();
5. Dump ($ Data );

Result

1. Array (6 ){
2. ["ID"] => int (1)
3. ["TechLevel"] => string (2) "10"
4. ["Remark"] => string (4) "��"
5. ["CreateDate"] => string (19) "2013-03-1415: 14: 38"
6. ["CreateBy"] => string (5) "admin"
7. ["ROW_NUMBER"] => string (1) "1"
8. }
9.  
10. Array (1 ){
11. [0] => array (6 ){
12. ["ID"] => int (1)
13. ["TechLevel"] => string (2) "10"
14. ["Remark"] => string (4) "��"
15. ["CreateDate"] => string (19) "2013-03-1415: 14: 38"
16. ["CreateBy"] => string (5) "admin"
17. ["ROW_NUMBER"] => string (1) "1"
18. }
19. }

From the code above, find () returns a one-dimensional array, and select () returns a two-dimensional array, so the values are different, the value of a one-dimensional array is $ data ["TechLevel"], and the value of a two-dimensional array is $ data [0] ["TechLevel"]. since we didn't understand this usage at the beginning, debugging is not worthwhile for one day. only the dump method can be used to see the difference between the two methods!

In addition,

1. $ Model = M ();
2. $ SQL = 'selectroleidfrom '. C ("DB_PREFIX"). 'adminwhereuserid ='. session ('userid ').'';
3. $ List = $ Model-> query ($ SQL );
4.  
5. // Write method 1
6. Foreach ($ listas & $ info ){
7. If (info ['roleid'] = '1 '){
8. }
9.  
10. // Statement 2
11. If ($ list [0] ['roleid'] = '1 '){
12. }

The spelling of the original thinkphp SQL is also a two-dimensional array.