Simple ways to use CI framework

1. CodeIgniterFramework
3. 1, MemoriesMVC
5. 1.1 , M: model, provide data, save data
6. 1.2, V: View, only responsible for displaying the form form
7. 1.3, C: Controller, coordinating the model and view
8. 1.4 , action: Action is a method in the controller, used to be requested by the browser
10. 2, CI in MVC
11. CI Introduction: CodeIgniter is a lightweight but powerful php framework, based on the MVC design pattern.Provides a rich set of class libraries
13. 2.1, accessed url used pathinfo
14. 2.2, format: entry file/controller/action ( Default pathinfo format)
15. 2.3, application Directory:
17. ControllersControllers
18. ModelsModels
19. Views View
21. 2.4, the default controller is welcome
22. 2.5, the default action is index
23. 2.6, file names must be all lowercase
25. 3, controller (controller):
26. 3.1, no need to add suffix, just the class name .php
27. 3.2、 File names are all lowercase, such as user.php (uppercase file names are not supported by browsers)
28. 3.3, all controllers, directly or indirectly inherited from CI_Controller Classes, the first letter of the class name is capitalized
29. 3.4, method names are not case-sensitive
31. Action requirements:1.must start with public
33. 2. cannot start with an underscore (_)
34. Attention!If the method name is the same as the class name, it will be regarded as a constructor method (__construct)
35. 4
, view (
36. view)
37. 4.1
, load the view in the controller:
38. $this->load->view("user_add"); //No Add extension 4.2
, load the view in the controller:
39. $this->load->view("user/ add”);//Without extension Note: You can call
$this
40. ->load->view(view); 4.3
, in the view, directly use the native
41. php code4.4
, assign variables in the controller:
42. $this->load - >vars("variable name in view", variable name in php); abcdefg ";
43. $this->
44. load->vars("str",$str
45. ); Use in view ：php echo $str;?> 4.5, assign multiple variables in the controller:
46. For example: $str
47. ="
48. abcd";
49. $list =
50. array("id"=>" 1"," name
51. ”=>”zhangsan”,”pwd”=>”1234”);$data [“str "]= $str;$data
52. ["list"]= $list; $this
53. -> ;load->vars($data); The framework will solve it by itself
php
54. Short tags …?>4.7, recommended use: phpforeach
(
55. $list
as
56. $key => Attributes5.1、$this
->
57. loadAttributes5.1. 1, instance of loader class system /core/Loader.
php
59. 5.1.
2
60. 、
CI_
61. Lo Method provided by ader: $this ->load
->
62. view()load view$this->load-> vars() Assign variables to the view
63. $this->load-> ;database()Load database operation object
64. $this -> load-> )Help objects $this
->
65. 5.2, $this->uriattributes
66. 5.2.1, instance of loader class system/core/URI.php
67. 5.2.2 Methods provided by , CI_URI:
68. $this->uri->Segment(n) is used to get URL The n parameter in represents the controller
1
69. , the action represents 2, and the value 1 represents 3 , value 2 is represented by 4…Usage
1
70. : Entry file/controller/action/value1/value2echo $this
- >
71. uri->segment(3);//Output value 1Usage
2
72. : index.php /Controller/Action/6//can be obtained directly; the parameters must correspond correctly
73. public
function
74. ($id=0) {echo $id
;
75. //output 6}
77. 5.3、$this->inputattribute
78. 5.3. 1, instance of loader class system Methods provided by /core/Input.php
79. 5.3.2, CI_Input:
81. $this ->input->post('username'); //$_POST["username"]; -> ;
82. input->server("DOCUMENT_ROOT");//$_SERVER["DOCUMENT_ROOT"]$this-&g t;
83. input -> server ("SERVER_ADDR");//Server-side IPNote: In the view, you can directly use $this
84. to access the properties in the super object 6, access database 6.1
85. , modify configuration file: application/config
86. /database
87. .php
88. 6.2 , Load database operation class:
89. $this->load->database();After successful loading, it will be placed in the properties of the super object, by default The attribute name is db
90. $this->db6.3, $query= $this
91. -& gt;db- >
92. query($sql);
93. //The return value is the object (array_fetch_object)$sql = $this-> db ->last_query($sql);//Display the last executed sql statement
94. 6.3.1,$ query= $this-> $list= $query->
$list
95. = $query-> = $query->row();//Return the first piece of data, which is directly an object6.7,$row=
96. $query ->row_array();//Return the first data, which is an array6.8, $count=
97. $query-> num_rows();//Return the number of rows in the result set6.9, $field=
98. $query->num_fields (); //Return the requested number of fields6.10, $count=
99. $query->affected_rows();//Return the number of affected rows 6.11、$id=
100. $query->insert_id();//Return self-increasing ID 7 , configuration in the database
101. 7.1, automatic loading db: in application/config
102. /autoload .php中Configuration:
103. $autoload["libraries"]= array("database");
104. This way you don't need $this -> load->database();
106. 7.2, parameter binding
107. $name = $this ->input -> ->post ("pwd");
108. //Use question marks to bind parameters $data[0]= $name ;
109. $data[
110. 1]= $pwd;//Use a two-dimensional array to pass values ​​$sql
111. =" insertinto ci_user(name,pwd
112. ) values ​​(?,?)”;//Multiple question marks, you need to pass an index array$bo ol = $this-> The value is boolean 7.3, table prefix configuration is configured in application
113. /config/database.php: $db[' default']['dbprefix']
114. ='ci_
115. ';$db['default '][' swap_pre']='
116. ci_';'; The configuration is the same. In the code, just write the name after the table prefix directly. If the project table prefix changes in the future, you only need to modify it. $db['default']['dbprefix']=
117. 'new_', in the code ci_ will be automatically replaced by new_ 8, database operation (
118. AR model) 8.1, configuration application/ cinfog/database. php中$active_record
119. = TRUE
120. ;8.2, in the configuration file, after configuring the table prefix,
will be added automatically
121. 8.3、 Find (get): $res = $this->db->
122. get('table name'); / /Return the result set object $list
123. = $res->
124. result();//Return the array, the array is one object $ list
125. = $res-> ) ://Data uses associative array$data["database field name"]=
126. value;//$this->input->post("name ");$data["database field name"]=value;
127. $res = $this->db -> ;insert("data table name",
128. $data);//return result boolean;8.5
129. , modify (update
130. ): //Data uses associative array$data["database field name"]
131. =value;//$this->input->post("name"); $data
132. ["database field name"]=value; $where = array("id" =>" 4 ”);
134. $res = $this->db->update("data table name",$data,$where ) ;//return result boolean;
135. 8.6、delete(delete):
136. $where = array("id ”=> ;"4");
137. $res = $this->db->dalete("data table name", $where);//Return result boolean;
139. 9, AR coherent operation
141. 9.1、$res = $this-> -> from("user")//Data table name->
142. where("id >",3)//Conditions There must be a space between id and >
143. ->order_by("id desc")//Sort ->
144. limit(3,1)//Paging; means skip 1 item, take 3 items , opposite to tp
145. ->get();//Get data$list = $res
146. ->result _array() ;9.2
147. , where() conditionsConditional symbols: ">", ">=", "<", "<=", "=", "!="; If you don't specify a condition, the default value is "=" $this->db
148. ->where("field","value")->get();
149. For example:
150. $res = $this
151. ->db->where("name","admin")-> get ();//"="9.2.
152. 2、$res= $this->db - >where("field=","value")->get();For example: $res=
153. $this- >db-> When there are spaces 2 or multiple conditions: use array()9.2.3, $res=
154. $this -> get();For example: $res= $this->db->where( array( "name
155. " =>"admin","id
156. >3" =>"2"))-&g t; get();9.2.4, complex query statements use $this->db-> query(
157. $sql,$data);//Use question marks to bind parameters9.3、joinConnection query
158. 9.3.1, the default is left query (left join … on)
159. $this->db->select("field")
160. - >from ("data table name")
161. ->join('join table','join condition')
162. -> get ();​​ //The default is left query (left join … on) For example:
163. $this->db->select(“*”)
164. -> from ("user")
165. ->join('category', user.id= category. id)//The default is left query (left join )
166. ->get();

1. 9.3.2. Select the connection through the third optional parameter of join(). The optional parameters include: left, right, outer, inner, left outer, right outer
2. For example:
3. $this->db->select(“*”)
4. ->from(“user”)
5. ->join ("category", "user.id = category.id", "left")//Specify through the third parameter
6. ->get();
7. 10. Extended CI controller
9. 10.1. Extending the controller
10. 1. Create a new controller (MY_Controller) in application/core. The new controller inherits the CI_Controller class and can be extended from the controller you created.
11. For example: class MY_Controller extends CI_Controller{
12. Public function __consreuct(){
13. Parent::__construct(); //Call the constructor of the parent class
14. //Login verification
15. //Permission verification
16. }
17. }
18. 2. Let welcome.php inherit the controller you created (MY_Controller) and indirectly inherit CI_Controller.
19. 3. The controller prefix can be modified
20. in application/config/config.php:
21. $config['subclass_prefix'] = 'MY_';
22. 11. Model
23. 11.1. Model file naming: user_model.php, category_model.php, file name in lowercase
24. Recommendation: use _model as the suffix for the model file name to prevent conflicts with Controller class name conflict!
25. 11.2. All models inherit directly or indirectly from the CI_Model class. The first letter of the class name is capitalized
26. 11.3. The methods required for creation: getAll()...
27. 11.4. Loading in the controller Model: $this->load->model("model file name"); //No suffix
28. 11.5. Alias ​​when loading the model in the controller: $this->load->model ("Model file name", "Alias");
29. After successful loading, it will be placed in the properties of the super object. The default property name is the model file name or alias
30. 11.6. Call the model in the controller. Get data: $this->Model file name->Method name();
31. For example: $this->load->model("User_model"); //Pay attention to the case
32. $this->User_model->getAll(); //Call the model and get the data
33. 11.6.1. Call the model in the controller and get the data: $this->alias->Method name() ;
34. For example: $this->load->model("User_model","user"); //Pay attention to the case
35. $this->user->getAll(); / / Call the model and get the data
36. 12. URL related functions in CI
37. 12.1. Loading helper function: $this->load->helper("url");
38. Configure automatic loading Helper function: Configure
39. $autoload['helper'] = array('url');
40. in application/config/autoload.php, so there is no need to write $this- >load->helper("url");
41. Helper function:
42. site_url("Controller/Action/Parameters"); //Process url and parameters
43. Use in the view
44. base_url(); //Return to the root directory of the website ("ci/");
45. 13. in CI Routing and pseudo-static, hidden index.php entry file
46. 13.1, routing settings
48. Set/modify in application/config/routes.php:
50. $route ['default_controller'] = "welcome"; //The default controller is welcome
52. 13.2, pseudo-static setting
53. is set in application/config/routes.php/ Modification:
54. //regular matching (controller/)
55. $route['news/[d]{6}/([dw ]+).html'] = 'user/show/$1';
56. http://localhost/CI/index.php/news/201401/caolizhi66.html
57. will action The parameters in news are routed to user/show/$1
59. 13.3. Hide the entry file index.php
60. 13.3.1. Open the apache configuration file: LoadModule rewrite_module modules/mod_rewrite.so
61. 13.3.2. In the entry file statistics directory, create a .htaccess file with the following content:
63. RewriteEngine on //Enable pseudo-static
64. RewriteCond %{ REQUEST_FILENAME} !-d //Match non-existing directories
65. RewriteCond %{REQUEST_FILENAME} !-f //Match non-existent files
66. RewriteRule ^(.*)$ index.php/$1 [QSA, PT,L] //Rewrite the rules
69. This way you don’t have to write the entry file index.php
71. 14. Pagination in CI
72. $this->load->library('pagination');
73. 1 $config['base_url'] = $url;
74. 2 / * Basic URL for paging
75. 3 If you want to use the link form of a and b, the url should be in the form of /news/page/
76. 4 If the link is in the form of c and d, the url should be in the form of /news?
77. 5 */
78. 6 $config['total_rows'] = $total;//The total number of records, there is nothing to say about this, it is the total number of records you get from the database
79. 7 $config['per_page'] = $pagesize; //Number of items per page.Well, there’s not much to say about this. . Set it yourself. The default is 10.
80. 8 $config['page_query_string'] = TRUE;
81. 9 /*Parameter form. Turning on true will automatically add &per_page=3 after your url. (This per_page is the default query character. Of course, you can also use $config['query_string_segment'] to set it yourself)
82. 10 Therefore, the forms in c and d are generally localhost/news?&per_page =2 But it’s all the same, it doesn’t matter. The per_page of get is still 3
83. 11 */
84. 12 $config['first_link'] = 'Homepage'; // The first page displays
85. 13 $config['last_link'] = 'last page'; // The last page displays
86. 14 $config['next_link'] = 'next page>'; // The next page displays
87. 15 ​​$config['prev_link'] = '<Previous page'; // Previous page shows
88. 16 $config['cur_tag_open'] = '<aclass="current">'; // Current page start style
89. 17 $config['cur_tag_close'] = '</a> ';
90. 18 /* Ending style of the current page. You can try these yourself.
91. 19For example, I want the pagination number style of the current page to look better, with red fonts, etc. You can add csscode to current num_links
92. ' ] = 2;//The number of page numbers displayed before and after the current connection. This means that your current page is page 5
, then you can see pages
93. 3, 4, 5, 6, 7 . 22 $config['uri_segment
'
94. ]=4 ;23/*this It is used to determine the number of pages when you use link styles a) and b). 24 For example, the uri_segment of localhost/news/page/3 should be set to 3. localhost/news/title/page/3 This should be set to 425 */
95. 26
$config
96. ['
97. use_page_numbers
'
98. ]= TRUE;27/*This is the difference between a) and b). When turned on, page will indicate the number of pages. false will indicate the number of records The above introduces the simple use of CI framework, including aspects of content. I hope it will be helpful to friends who are interested in PHP tutorials.