'URL_PATHINFO_DEPR'=>'-', //Modify the URL delimiter
'TMPL_L_DELIM'=>'<{', //Modify the left delimiter 'TMPL_R_DELIM'=>'}>', //Modify the right delimiter http://localhost/test/index.php/Index-add-name-wuhao-age-23 http://localhost/test/index.php/Index/indexHello! {$myname}
D:wampwwwtestAppTplIndex You need to operate the database in the form of new Model (table name) in the method $m=new Model('User'); $arr=$m->select(); 'DB_TYPE'=>'mysql', //Set the database type
$user=new Model('User');
$arr=$user->select();
var_dump($arr);
$this->display();
'SHOW_PAGE_TRACE'=>true,//Open page Trace
There is also a simple and practical model
M() is equivalent to new Model();
$m=M('User');
$arr=$m->select();
You can use model instances to operate data. The operation work is generally to add, delete, modify and check the database CURD
Add -C Create $m->add()
Delete -D Delete $m->delete()
Change -U Update $m->save()
Check -R Read $m->select()
a. Templates can traverse arrays
CURD Demo:
================================================== ================================================== ================================================== ===============================================
Query method:
1. Common query methods
a. String
$arr=$m->where("sex=0 and username='gege'")->find();
b. Array
$data['sex']=0;
$data['username']='gege';
$arr=$m->where($data)->find();
Note: This method defaults to an and relationship. If you use an or relationship, you need to add an array value: $data['_logic']='or';
2. Expression query method
$data['id']=array('lt',6); $arr=$m->where($data)->select();
EQ is equal to, NEQ is not equal to, GT is greater than, EGT is greater than or equal to, LT is less than, ELT is less than or equal to, LIKE fuzzy query
$data['username']=array('like','%ge'); $arr=$m->where($data)->select();
NOTLIKE
$data['username']=array('notlike','%ge%'); $arr=$m->where($data)->select();
Note: If a field needs to match multiple wildcards
$data['username']=array('like',array('%ge%','%2%','%五%'),'and'); //If there is no third Value, the default relationship is the or relationship
BETWEEN
$data['id']=array('between',array(5,7)); $arr=$m->where($data)->select();
//SELECT * FROM `tp_user` WHERE ( (`id` BETWEEN 5 AND 7 ) )
$data['id']=array('not between',array(5,7)); $arr=$m->where($data)->select();
IN
$data['id']=array('in',array(4,6,7)); $arr=$m->where($data)->select();
//SELECT * FROM `tp_user` WHERE ( `id` IN (4,6,7) )
$data['id']=array('not in',array(4,6,7)); $arr=$m->where($data)->select();
//SELECT * FROM `tp_user` WHERE ( `id` NOT IN (4,6,7) )
3. Interval query
$data['id']=array(array('gt',4),array('lt',10)); //The default relationship is the relationship of and
//SELECT * FROM `tp_user` WHERE ( (`id` > 4) AND (`id` < 10) )
$data['id']=array(array('gt',4),array('lt',10),'or') //The relationship is the relationship of or
$data['name']=array(array('like','%2%'),array('like','%五%'),'gege','or');
4. Statistical query
count //Get the number; max //Get the maximum number; min //Get the minimum number; avg //Get the average; sum //Get the total
5. SQL direct query
a. Query is mainly used to process reading data: successfully returns the result set of the data, and fails to return boolean false
$m=M(); $result=$m->query("select * from t_user where id >50");
var_dump($result);
b. execute is used to update a write operation: successfully returns the number of affected rows, and fails to return boolean false
$m=M();
$result=$m->execute("insert into t_user(`username`) values('ztz3')");
var_dump($result);
'DB_LIKE_FIELDS'=>'title|content' //The conditions in the query statement automatically become fuzzy query%%
Query method demonstration:
================================================== ================================================== ================================================== ===============================================
Commonly used coherent operations
1.where Help us set query conditions
2.order Sort the results
$arr=$m->order('id desc')->select(); $arr=$m->order(array('id'=>'desc','sex' =>'asc'))->select();
3.limit Limit results
limit(2,5) limit('2,5') limit(10) //limit(0,10)
4.field Set query field
field('username as name,id') field(array('username'=>'name','id')
field('id',true) //Get all fields except id
5.table
6.group
7.having
2. Supplement
alias is used to define an alias string for the current data table
page is used to query paging (will be converted to limit internally) strings and numbers
join* is used to support joins for queries, strings and arrays
union* for union support for queries strings, arrays and objects
distinct distinct support for queries boolean
lock Lock mechanism for database Boolean value
cache is used to query the cache and supports multiple parameters (described in detail in the cache section later)
relation is used for related queries (requires related model extension support) string
validate is used for automatic data verification array
auto is used for automatic data completion array
filter is used for data filtering string
scope* is used to name ranges strings and arrays
================================================== ================================================== ================================================== ===============================================
View:
1. Use of templates
a. Rules
Under the template folder [TPL]/[Group Folder/][Template Theme Folder/] and the folder with the same name as the module name [Index]/the file with the same name as the method name [index].html (.tpl)
Change the suffix of the template file (modify the configuration file)
'TMPL_TEMPLATE_SUFFIX'=>'.html', //Change the template file suffix name
b. Modify the template file directory hierarchy
'TMPL_FILE_DEPR'=>'_', //Modify the template file directory hierarchy
c. Template theme
'DEFAULT_THEME'=>'your', //Set the default template theme
You need to create a new your folder under TPL as the template theme folder
How to dynamically modify the template theme?
1. Prepare a function in the background to modify the default template item in the config.php file
2. Pass the t=theme parameter through the url to modify different templates
'DEFAULT_THEME'=>'your',//Set the default template theme
'TMPL_DETECT_THEME'=>true,//Automatically detect template themes
'THEME_LIST'=>'your,my',//Supported template theme list
http://localhost/test/index.php/Index/index/t/my http://localhost/test/index.php/Index/index/t/you
2. Output template content
a. display
1. There are no parameters in display: $this->display();
2. Can take parameters
$this->display (other template files in this module folder);
$this->display('index2');
$this->display (template files in other folders);
$this->display('Public:error'); //Note that you only need to have the Public folder and error.html in it under Tpl, and you do not need to have the Public module
$this->display (template files under folders under other themes); //Need to enable theme support
$this->display('my:Index:index');
$this->display(a URL path);
$this->display('./Public/error.html');
$this->display('./Public/error.html','utf-8','text/xml');
$this->show($content);
3.fetch method
Get the content in the template file and return it as a string: $content=$this->fetch('Public:error');
4.show method
No template file is required, the template content can be output directly
$content=$this->fetch('Public:error');
dump($content);
$content=str_replace('h1','i',$content);
$this->show($content);
3. Assignment in templates
//$this->assign('name','Zhao Tongzheng');
$this->name='Zhao Tongzheng2'; $this->display();
4. Template replacement
__PUBLIC__: will be replaced by the public directory of the current website, usually /Public/
__ROOT__: will be replaced with the address of the current website (excluding domain name)
__APP__: will be replaced by the URL address of the current project (excluding domain name)
__GROUP__: will be replaced by the URL address of the current group (excluding domain name)
__URL__: will be replaced by the URL address of the current module (excluding domain name)
__ACTION__: will be replaced by the URL address of the current operation (excluding domain name)
__SELF__: will be replaced with the current page URL
Change template variable rules and modify configuration items
'TMPL_PARSE_STRING'=>array( //Add your own template variable rules
'__CSS__'=>__ROOT__.'/Public/Css',
'__JS__'=>__ROOT__.'/Public/Js',
),
Login box example:
Introduce the extension class and put the files in ThinkPHP3.1.2_Extend in the D:wampwwwtestThinkPHPExtend folder.
Corresponding js and css:
D:wampwwwtestPublicCss ·D:wampwwwtestPublicJs
================================================== ================================================== ================================================== ===============================================
Variables in template:
1. Variable output
1. Scalar output
2. Array output
{$name[1]} {$name['k2']} {$name.k1}
3. Object output
{$name:k} {$name->k}
2. System variables
|
Meaning | Example | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| $Think.server | Get $_SERVER | {$Think.server.php_self} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.get | Get $_GET | {$Think.get.id} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.post | Get $_POST | {$Think.post.name} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.request | Get $_REQUEST | {$Think.request.user_id} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.cookie | GET $_COOKIE | {$Think.cookie.username} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.session | Get $_SESSION | {$Think.session.user_id} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.config | Get system configuration parameters | {$Think.config.app_status} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.lang | Get system language variables | {$Think.lang.user_type} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.const | Get system constants | {$Think.const.app_name} or {$Think.APP_NAME} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.env | Get environment variables | {$Think.env.HOSTNAME} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.version | Get the framework version number | {$Think.version} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.now | Get the current time | {$Think.now} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.template | Get the current template | {$Think.template} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.ldelim | Get template left delimiter | {$Think.ldelim} | ||||||||||||||||||||||||||||||||||||||||||||||||
| $Think.rdelim | Get template right delimiter | {$Think.rdelim} |
