About database and model usage of ThinkPHP5-PHP Tutorial-php.cn

Table of Contents

1, TP5 database architecture

2, Database access

Home

Backend Development

PHP Tutorial

About database and model usage of ThinkPHP5

jacklove

Jun 15, 2018 am 11:07 AM

thinkphp

1, TP5 database architecture

About database and model usage of ThinkPHP5

1	`Db: 是TP5操作数据库的入口类。它的作用是为连接数据库做准备，我们只需要在database.php里填写相应的配置即可。`

Copy after login

1	`Connection: 是TP5的连接器类，因为TP5支持四种数据库（Mysql，Pgsql，Sqlite，Sqlsrv），所以TP5封装了一个类来提供统一的调用接口来支持我们连接数据库（这里的连接是惰性连接，只有在执行SQL的时候才会真正连接）。`

Copy after login

1	`Query: 查询器，因为不同数据库的SQL语句不同，所以封装了一个Query类来提供统一的接口，以实现不同数据库的CURD操作。查询器是TP5数据访问层的核心，它连接了Connection和Builder。`

Copy after login

1	`Builder: 生成器。这个类主要是把Query的查询参数生成相应的sql语句，然后把其返回给Connection供其使用。`

Copy after login

2, Database access

In TP5, there are three methods for database access:

Native sql statement.

1 2	`Db::query('select * from think_user where id=?',[8]);` `Db::execute('insert into think_user (id, name) values (?, ?)',[8,'thinkphp']);`

Copy after login

Query constructor

About database and model usage of ThinkPHP5

It should be noted that the above In the query method, find, select, insert, update, and delete are all query operations, and the others are auxiliary operations. The auxiliary operations return an object and support chain calls. But once the query operation is executed, it cannot be called further.

The order of different auxiliary operations has no effect, but the order of the same auxiliary operations will.

1	`不同的辅助操作，先后顺序没影响。Db::table('banner')->where('id', '>', '2')->order('update_time asc')->select();Db::table('banner')->order('update_time asc')->where('id', '>', '2')->select();`

Copy after login

相同的查询操作，先后顺序有影响。
$list = Db::table(&#39;data&#39;)
    ->where(&#39;id&#39;, &#39;>&#39;, 1)
    ->where(&#39;name&#39;, &#39;like&#39;, &#39;%think%&#39;)
    ->order(&#39;id&#39;, &#39;desc&#39;)
    ->order(&#39;create_time&#39;, &#39;desc&#39;)
    ->limit(8)
    ->select();
$list = Db::table(&#39;data&#39;)
    ->where(&#39;name&#39;, &#39;like&#39;, &#39;%think%&#39;)
    ->where(&#39;id&#39;, &#39;>&#39;, 1)
    ->order(&#39;create_time&#39;, &#39;desc&#39;)
    ->order(&#39;id&#39;, &#39;desc&#39;)
    ->limit(8)
    ->select();

Copy after login

Model

ORM Object Relation Mapping Object relational mapping

is mapped to our database through the model table, and then operate the database by operating the model.

We compare it with the query constructor

1	`// 查询操作$user = Db::table('user')->find(1);// 取值操作echo $user['name'];echo $user['email'];// 设置操作$user['name'] = 'topthink';$user['email'] = 'thinkphp@qq.com';// 更新操作Db::table('user')->update($user);`

Copy after login

If it is a model operation, it can be implemented corresponding to the following code

1 2	`// 查询操作$user = User::get(1);// 取值操作echo $user->name;` `echo` `$user->email;// 设置操作$user->name = 'topthink';$user->email = 'thinkphp@qq.com';// 更新操作$user->save();`

Copy after login

This is outside the model, and also It is the value acquisition and setting operations in the controller, but inside the model, the following method is used:

// 取值操作echo $user->getData(&#39;name&#39;);
echo $user->getData(&#39;email&#39;);// 设置操作echo $user->data(&#39;name&#39;, &#39;SpawN&#39;);
echo $user->data(&#39;email&#39;, &#39;123@qq.com&#39;);

Copy after login

CURD operation of the model

Creation

Db usage:

1	`Db::table('user')->insert([ 'name' => 'spawn', 'email' => '123@qq.com'])`

Copy after login

Model usage:

1	`$user` `=` `new` `User;$user->save([ 'name' => 'spawn', 'email' => '123@qq.com'])$user` `= User::create([ 'name' => 'sapwn', 'email' => '123@qq.com'])`

Copy after login

Summary:

save (dynamic) Returns: Number of affected records
create(static) Returns: model object instance (method can be called directly)

Read

Db:

1	`$user` `= Db::table('user')->where('id', 1)->find();`

Copy after login

Model:

1	`$user` `= User::get(1);`

Copy after login

It should be noted that find and select are methods of the query constructor, and get and all are methods of the model. But the model is based on the query constructor, so the model can call the find and select methods, but the query constructor cannot call the get and all methods

Summary:

Method Function Return value
get Query a single record Model object instance
find Query a single record Model object instance
all Query multiple records based on the primary key Array or data set containing model object instances
select Query multiple records based on conditions Containing model object instances Array or data set

Update

Db:

1	`Db::table('user')->where('id', 1)->update([ 'name' => 'haha', 'email' => 'heihei@qq.com'])`

Copy after login

Model:

$user = User::get(1);$user->save([    &#39;name&#39; => &#39;haha&#39;,    &#39;email&#39; => &#39;heihei@qq.com&#39;])
 
或者 
 
User::update([    &#39;name&#39;  => &#39;topthink&#39;,    &#39;email&#39; => &#39;topthink@qq.com&#39;,
], [&#39;id&#39; => 1]);

Copy after login

Summary:

Method Function Return value
save Update data Number of records affected
update Update data (static) Return model object instance

1	`需要注意的是，模型的更新操作是只更新有变化的数据。性能比较好。`

Copy after login

Delete

Db:

1	`Db::table('user')->delete(1);`

Copy after login

Model:

$user = User::get(1);$user->delete();
或者
User::destory(1);

Copy after login

Summary:

Method Function Return value
delete Delete current data Number of records affected
destroy Delete specified data (static) Affected Number of records

Now that we have mastered the basic CURD operations of the model, let’s summarize the method differences:

Usage Db class model (dynamic) Model (static)
Create insert save create
Update update save update
Read a single find find get
Read multiple select select all
Delete delete delete destroy destroy

This article explains the database and model usage of ThinkPHP5, For more related content, please pay attention to php Chinese website.

Related recommendations:

A case study on thinkphp5.0 database operation

Create the simplest ThinkPhp project

The above is the detailed content of About database and model usage of ThinkPHP5. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

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

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

3 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

3 weeks ago By DDD

Strength Levels for Every Enemy & Monster in R.E.P.O.

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Roblox: Dead Rails - How To Tame Wolves

3 weeks ago By DDD

Blue Prince: How To Get To The Basement

3 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1655

CakePHP Tutorial

1413

Laravel Tutorial

1306

PHP Tutorial

1252

C# Tutorial

1226

Related knowledge

How to run thinkphp project Apr 09, 2024 pm 05:33 PM

To run the ThinkPHP project, you need to: install Composer; use Composer to create the project; enter the project directory and execute php bin/console serve; visit http://localhost:8000 to view the welcome page.

There are several versions of thinkphp Apr 09, 2024 pm 06:09 PM

ThinkPHP has multiple versions designed for different PHP versions. Major versions include 3.2, 5.0, 5.1, and 6.0, while minor versions are used to fix bugs and provide new features. The latest stable version is ThinkPHP 6.0.16. When choosing a version, consider the PHP version, feature requirements, and community support. It is recommended to use the latest stable version for best performance and support.

How to run thinkphp Apr 09, 2024 pm 05:39 PM

Steps to run ThinkPHP Framework locally: Download and unzip ThinkPHP Framework to a local directory. Create a virtual host (optional) pointing to the ThinkPHP root directory. Configure database connection parameters. Start the web server. Initialize the ThinkPHP application. Access the ThinkPHP application URL and run it.

Which one is better, laravel or thinkphp? Apr 09, 2024 pm 03:18 PM

Performance comparison of Laravel and ThinkPHP frameworks: ThinkPHP generally performs better than Laravel, focusing on optimization and caching. Laravel performs well, but for complex applications, ThinkPHP may be a better fit.

Development suggestions: How to use the ThinkPHP framework to implement asynchronous tasks Nov 22, 2023 pm 12:01 PM

"Development Suggestions: How to Use the ThinkPHP Framework to Implement Asynchronous Tasks" With the rapid development of Internet technology, Web applications have increasingly higher requirements for handling a large number of concurrent requests and complex business logic. In order to improve system performance and user experience, developers often consider using asynchronous tasks to perform some time-consuming operations, such as sending emails, processing file uploads, generating reports, etc. In the field of PHP, the ThinkPHP framework, as a popular development framework, provides some convenient ways to implement asynchronous tasks.

How to install thinkphp Apr 09, 2024 pm 05:42 PM

ThinkPHP installation steps: Prepare PHP, Composer, and MySQL environments. Create projects using Composer. Install the ThinkPHP framework and dependencies. Configure database connection. Generate application code. Launch the application and visit http://localhost:8000.

How is the performance of thinkphp? Apr 09, 2024 pm 05:24 PM

ThinkPHP is a high-performance PHP framework with advantages such as caching mechanism, code optimization, parallel processing and database optimization. Official performance tests show that it can handle more than 10,000 requests per second and is widely used in large-scale websites and enterprise systems such as JD.com and Ctrip in actual applications.

Development suggestions: How to use the ThinkPHP framework for API development Nov 22, 2023 pm 05:18 PM

Development suggestions: How to use the ThinkPHP framework for API development. With the continuous development of the Internet, the importance of API (Application Programming Interface) has become increasingly prominent. API is a bridge for communication between different applications. It can realize data sharing, function calling and other operations, and provides developers with a relatively simple and fast development method. As an excellent PHP development framework, the ThinkPHP framework is efficient, scalable and easy to use.

See all articles