Simple operations for adding, deleting, modifying, and querying thinkphp

Add, delete, modify, and query operations on CURDAction. class. php & lt ;? Php // test the add, delete, modify, and query operations on the database classCURDActionextendsAction {// index page publ...

Adding, deleting, modifying, and querying CURD,First, a set of code CURDAction. class. php is provided.

2.  
3. // Test the addition, deletion, modification, and query operations on the database
4.  
5. ClassCURDActionextendsAction
6.  
7. {
8.  
9. // Index page
10.  
11. Publicfunctionindex ()
12.  
13. {
14.  
15. $ This-> assign ('title', 'Add data'); // The template variable {$ title} is set here}
16.  
17. $ This-> assign ('datetime', date ("Y-m-dH: I: s "));
18.  
19. $ This-> display ();
20.  
21. }
22.  
23. // INSERT operation
24.  
25. Publicfunctioncreate ()
26.  
27. {
28.  
29. // Initialize the ing object (O/RMapping) corresponding to the think_demo table)
30.  
31. $ Demo = D ("Demo ");
32.  
33. If ($ demo-> create ()){
34.  
35. // Assign values to the autotime field: obtain the date format accepted by the datetime field type in mysql database by date ("Y-m-dH: I: s.
36.  
37. $ Demo-> autotime = date ("Y-m-dH: I: s ");
38.  
39. // Insert operation
40.  
41. $ Demo-> add ();
42.  
43. // Jump to the display page
44.  
45. // $ This-> display ("read ");
46.  
47. $ This-> redirect ("read ");
48.  
49. } Else {
50.  
51. Header ("Content-Type: text/html; charset = utf-8 ");
52.  
53. Exit ($ demo-> getError (). '[return aaaaaa]');
54.  
55. }
56.  
57. }
58.  
59. // SELECT operation
60.  
61. Publicfunctionread ()
62.  
63. {
64.  
65. $ Demo = D ("Demo ");
66.  
67. $ Data = $ demo-> order ('iddesc')-> limit (10)-> select ();
68.  
69. $ This-> assign ('data', $ data );
70.  
71. $ This-> assign ('title', 'Add data 2 ');
72.  
73. $ This-> display ();
74.  
75. }
76.  
77. // UPDATE operation
78.  
79. Publicfunctionupdate ()
80.  
81. {
82.  
83. $ Demo = D ("Demo ");
84.  
85. // In practice, it is found that the create () method may not be executed if the user does not start the onClick event, because the database is not updated if the user clicks the page.
86.  
87. // Create () method: automatically extract data from html forms and inject it into Model objects.
88.  
89. // $ Demo-> create ();
90.  
91. // $ Demo-> save ();
92.  
93. // Same as the above code
94.  
95. $ Date ['title'] = $ _ POST ['title'];
96.  
97. $ Date ['content'] = $ _ POST ['content'];
98.  
99. $ Date ['id'] = $ _ POST ['id'];
100.  
101. $ Demo-> save ($ date );
102.  
103. $ This-> assign ('title', 'update data 2 ');
104.  
105. $ This-> display ();
106.  
107. }
108.  
109. // DELECT operation
110.  
111. Publicfunctiondelect ()
112.  
113. {
114.  
115. $ Demo = D ("Demo ");
116.  
117. $ Demo-> where ('Id = 5')-> delete ();
118.  
119. $ This-> redirect ("read ");
120.  
121. }
122.  
123. }
124.  
125. ?>

After understanding the operation, you can understand the above code. because you have to get off work, I will go home and explain it again.

1. $ Demo = D ("Demo ");

Creates a ing object for a specified table through the database.

2. $ Demo-> create ()

Automatically loads the values in the form to the ing object using the same form name attribute name.

3. $ Demo-> add ();

Insert operations to insert data from non-empty ing objects into the database

4. $ Date ['title'] = $ _ POST ['title'];

$ Date ['content'] =_ _ POST ['content']; $ date ['id'] =$ _ POST ['id']; $ demo-> save ($ date); update operation. here, unconditional update is performed, and the system will automatically update 5 through the primary key. $ Demo-> where ('Id = 5')-> delete ();

Delete an operation by setting conditions.

6. $ Data = $ demo-> order ('iddesc')-> limit (10)-> select ();

$ This-> assign ('data', $ data );