The so-called CURD. That is, the four basic operations (CURD) of database operations: C:create (create), U:update (update), R:read (read) and D:detele (delete).
In ThinkPHP, methods with these names are not necessarily used. Here are the common methods: select, find, findAll, save, create, etc.:
D reading:
select->() query data set , the same as findAll->(). For example:
$User->where('status=1′)->order('create_time')->limit(10)->select();
Note: In continuous operations, except the select method must Except for the last one, the order of calling methods for other consecutive operations is not sequential. For example, the following code is equivalent to the above:
$User->order('create_time')->where('status=1′ )->limit(10)->select();
find->() method, similar to the above two methods. The difference is that only one piece of data is returned. Can be used together with getField->() to obtain a field value of a record.
select has the same effect as findall, and returns a two-dimensional array. Such as
array(1) {
[0] => array(8)
{ ["rank_id"] => string(3) “151″
["rank_name"] => string( 7) “Test 9″
["rank_memo"] => string(3) “123″
["uid”] => string(5) “59471″
["rank_kw"] => string(6) "Important"
["rank_uptime"] => string(10) "1280202914″
["isverify"] => string(1) "0″
["ishot"] => ; string(1) “0″
}
}
find has the following effect, returning a one-dimensional array:
array(8) {
["rank_id"] => string(3) "151″
["rank_name"] => string(7) "Test 9″
["rank_memo"] => string(3) "123″
["uid"] => string( 5) “59471″
["rank_kw"] => string(6) “Important”
["rank_uptime"] => string(10) “
1280202914″ ["isverify"] => string (1) “0″
["ishot"] => string(1) “0″
}
Where method: used to query or update the definition of conditions
Table method: define the data table to be operated on Name
$Model->Table('think_user user')->where('status>1′)->select();
field method: Define the field to be queried
The parameters of the field method support strings and arrays, for example,
$Model->field('id,nickname as name')->select();
$Model->field(array('id','nickname'=>'name '))->select();
If you do not use the field method to specify a field, the default is equivalent to using field('*').
U update, C creation:
data, add, save methods: data object assignment, addition, save. For example:
$data['name'] = 'ThinkPHP';
$data['email'] = 'ThinkPHP@gmail.com';
$Model->data($data)->add(); //Newly added, equivalent to insert, written in a coherent way
$Model->add($data); //Newly added, equivalent to insert, written in a non-consecutive way
$Model->data($data)->where ('id=3′)->save(); //Modify, equivalent to update
It should be noted that in the save method, if the data has not changed, the default return operation is FALSE. But this save execution is OK, this needs attention.
create->() automatically forms data in the form of $data from the POST fields
$User=D(“User”);
$User->create(); //Data submitted through the form by default Create
$User->add(); //Add
setInc and setDec methods. For updates to statistical fields (usually numeric types):
$Model->setInc('score','id=5′,3); // The user's points are increased by 3
$Model->setInc( 'score','id=5′); // The user's points are increased by 1
$Model->setDec('score','id=5′,5); // The user's points are decreased by 5
$Model- >setDec('score','id=5′); // The user's points are reduced by 1
D Delete:
delete->() delete data
$User->where('status=0′ )->order('create_time')->limit('5′)->delete();
Other common methods of Model:
order method: result sorting For example:
order('id desc' )
The sorting method supports sorting multiple fields
order('status desc,id asc')
The parameters of the order method support strings and arrays. The usage of arrays is as follows:
order(array('status'=>' desc','id'))
limit method: Result limit
limit('1,10′)
If limit('10′) is used, it is equivalent to limit('0,10′)
page method: Query paging. The usage of the Page method is similar to the limit method. The format is:
Page(‘page[,listRows]‘)
Page represents the current number of pages, and listRows represents the number of records displayed on each page. For example, if 10 records are displayed on each page, get the data on page 2:
Page('2,10′)
listRow If you don't write it, the value of limit('length') will be read, for example, it means that every page If the page displays 25 records, get the data on page 3:
limit(25)->page(3);
If limit is not set, the default is to display 20 records per page.
Join method: Query Join support. The parameters of the Join method support strings and arrays, and the join method is the only method that can be called multiple times in a coherent operation. For example:
$Model->join(' work ON artist.id = work.artist_id')->join('card ON artist.card_id = card.id')->select();
LEFT is used by default JOIN method, if you need to use other JOIN methods, you can change it to
$Model->join('RIGHT JOIN work ON artist.id = work.artist_id')->select();
Distinct method: query Disiinct support. Perform unique filtering when querying data
$Model->Distinct(true)->select();
Relation method: related query support
$Model->Relation(true)->select();
Conditional query
$map->put('name','php'); //name='php'
('name',array('like','think')); //name like '…'
('id',array('in',array(1,2,4)));
('id',array('10′,'3′,'or')) ; //id>=10 or
thinkphp multi-table query statement
1. table() function
thinkphp provides a table() function. For specific usage, please refer to the following statement:
$list=$Demo ->table('think_blog blog,think_type type')->where('blog.typeid=type.id')->field('blog.id as id,blog.title,blog.content,type. typename as type')->order('blog.id desc' )->limit(5)->select();
echo $Demo->getLastSql(); //Print the SQL statement and view it Let’s take a look
2. Join() function
Look at the code:
$Demo = M('artist');
$Demo->join('RIGHT JOIN think_work ON think_artist.id = think_work.artist_id' );
/ /You can use INNER JOIN or LEFT JOIN. Be sure to pay attention to the prefix of the table name here!
echo $Demo->getLastSql(); //Print the SQL statement and check it

thinkphp是国产框架。ThinkPHP是一个快速、兼容而且简单的轻量级国产PHP开发框架,是为了简化企业级应用开发和敏捷WEB应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。

本篇文章给大家带来了关于thinkphp的相关知识,其中主要介绍了关于使用think-queue来实现普通队列和延迟队列的相关内容,think-queue是thinkphp官方提供的一个消息队列服务,下面一起来看一下,希望对大家有帮助。

thinkphp基于的mvc分别是指:1、m是model的缩写,表示模型,用于数据处理;2、v是view的缩写,表示视图,由View类和模板文件组成;3、c是controller的缩写,表示控制器,用于逻辑处理。mvc设计模式是一种编程思想,是一种将应用程序的逻辑层和表现层进行分离的方法。

本篇文章给大家带来了关于thinkphp的相关知识,其中主要介绍了使用jwt认证的问题,下面一起来看一下,希望对大家有帮助。

thinkphp扩展有:1、think-migration,是一种数据库迁移工具;2、think-orm,是一种ORM类库扩展;3、think-oracle,是一种Oracle驱动扩展;4、think-mongo,一种MongoDb扩展;5、think-soar,一种SQL语句优化扩展;6、porter,一种数据库管理工具;7、tp-jwt-auth,一个jwt身份验证扩展包。

本篇文章给大家带来了关于ThinkPHP的相关知识,其中主要整理了使用think-queue实现redis消息队列的相关问题,下面一起来看一下,希望对大家有帮助。

thinkphp查询库是否存在的方法:1、打开相应的tp文件;2、通过“ $isTable=db()->query('SHOW TABLES LIKE '."'".$data['table_name']."'");if($isTable){...}else{...}”方式验证表是否存在即可。

在thinkphp3.2中,可以利用define关闭调试模式,该标签用于变量和常量的定义,将入口文件中定义调试模式设为FALSE即可,语法为“define('APP_DEBUG', false);”;开启调试模式将参数值设置为true即可。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

WebStorm Mac version
Useful JavaScript development tools

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Atom editor mac version download
The most popular open source editor