thinkphp笔记（ThinkPHP笔记）.doc

thinkphp笔记（ThinkPHP笔记） Regular expressions require escape symbols that are: * + + ^ $() / \ \ {{} MySQL looks at the table structure show, columns, from, test.user, or describe (DESC) table name column names Thinkphp related knowledge points Example of the use of the model can operate on the data, the operation of the general database is to add and delete to check CURD Add -C, Create, $m-add () - returns the ID number of the new data Delete -D, Delete, $m-delete () - returns the number of affected rows Change -U, Update, $m-save () - returns the number of affected rows Check -R, Read, $m-select () Two, ThinkPHP 3 read data (focus) Read data, Read $m=new Model (User); $m=M (User); Select ($m-select); / / get all the data in an array of return Find $m-find ($id); / / get a single data GetField (field) / / get a specific field value $arr=$m-where (id=2) -getField (username); Three, ThinkPHP 3 create data (focus) Add data to Create $m=new Model (User); $m=M (User); $m- field name = value $m-add (); The return value is the new ID number Four, ThinkPHP 3 delete data (focus) $m=M (User); $m-delete (2); / / delete ID 2 data $m-where (id=2) (-delete); / / the same as above, and delete the ID 2 data The return value is the number of affected rows Five, ThinkPHP 3 update data (key) $m=M (User); $data[id]=1; $data[username]=ztz2; $m-save ($data); The return value is the number of affected rows Templates can walk through arrays volist name=dataid=vo {$vo.id}----{$vo.username}-----{$vo.sex}br/ /volist Inquiry mode: I. General inquiry method A, string $arr=$m-where (sex=0 and username=gege) -find (); B and array $data[sex]=0; $data[username]=gege; $arr=$m-where ($data) -find (); Note: this way the default is the and relationship, and if you use the or relationship, you need to add the array value $data[sex]=0; $data[username]=gege; $data[_logic]=or; Two, expression inquiry method $data[id]=array (lt, 6); $arr=$m-where ($data) -select (); EQ equals NEQ is not equal to GT greater th