About ThinkPHP 5. Some basic operations of database-PHP Tutorial-php.cn

About ThinkPHP 5. Some basic operations of database

jacklove

Release： 2023-04-01 09:32:01

Original

1801 people have browsed it

New

Normal new

$User = M("User"); // 实例化User对象$data[&#39;name&#39;] = &#39;ThinkPHP&#39;;$data[&#39;email&#39;] = &#39;ThinkPHP@gmail.com&#39;;$User->add($data);

Copy after login

Continuous operation

$User = M("User"); // 实例化User对象$data[&#39;name&#39;] = &#39;ThinkPHP&#39;;$data[&#39;email&#39;] = &#39;ThinkPHP@gmail.com&#39;;$User->data($data)->add();

Copy after login

Use Create

$User = M("User"); // 实例化User对象
 // 根据表单提交的POST数据创建数据对象$User->create();$User->add(); // 根据条件保存修改的数据

Copy after login

Batch insert data

$User->addAll($data)

Copy after login

Read Take the

select method

$User = M("User"); // 实例化User对象
 // 查找status值为1的用户数据 以创建时间排序 返回10条数据$list = $User->where(&#39;status=1&#39;)->order(&#39;create_time&#39;)->limit(10)->select();

Copy after login

array as the query condition

$User = M("User"); // 实例化User对象$condition[&#39;name&#39;] = &#39;thinkphp&#39;;$condition[&#39;status&#39;] = 1; // 把查询条件传入查询方法$User->where($condition)->select();

Copy after login

Change the logical relationship of multiple conditions

$User = M("User"); // 实例化User对象$condition[&#39;name&#39;] = &#39;thinkphp&#39;;$condition[&#39;account&#39;] = &#39;thinkphp&#39;;$condition[&#39;_logic&#39;] = &#39;OR&#39;; // 把查询条件传入查询方法$User->where($condition)->select();

Copy after login

Object mode query

$User = M("User"); // 实例化User对象
 // 定义查询条件$condition = new stdClass(); 
$condition->name = &#39;thinkphp&#39;; 
$condition->status= 1; 
$User->where($condition)->select();

Copy after login

Expression query

$User = M("User"); // 实例化User对象
 // 要修改的数据对象属性赋值$data[&#39;name&#39;] = &#39;ThinkPHP&#39;;$data[&#39;score&#39;] = array(&#39;exp&#39;,&#39;score+1&#39;);// 用户的积分加1$User->where(&#39;id=5&#39;)->save($data); // 根据条件保存修改的数据

Copy after login

Quick or query

$User = M("User"); // 实例化User对象$map[&#39;name|title&#39;] = &#39;thinkphp&#39;; // 把查询条件传入查询方法$User->where($map)->select();

Copy after login

Quick multi-field and query

$User = M("User"); // 实例化User对象$map[&#39;status&title&#39;] =array(&#39;1&#39;,&#39;thinkphp&#39;,&#39;_multi&#39;=>true); // 把查询条件传入查询方法$User->where($map)->select();

Copy after login

Interval query

$map[&#39;id&#39;] = array(array(&#39;gt&#39;,1),array(&#39;lt&#39;,10)) ;

Copy after login

find method

$User = M("User"); // 实例化User对象
 // 查找status值为1name值为think的用户数据 $User->where(&#39;status=1 AND name="think"&#39;)->find();

Copy after login

Limit field

$User = M("User"); // 实例化User对象
 // 获取ID为3的用户的昵称 $nickname = $User->where(&#39;id=3&#39;)->getField(&#39;nickname&#39;);

Copy after login

Return an array composed of one field

$this->getField(&#39;id&#39;,true); // 获取id数组

Copy after login

Multiple fields return an associative array

$User = M("User"); // 实例化User对象
 // 获取所有用户的ID和昵称列表 $list = $User->getField(&#39;id,nickname&#39;);

Copy after login

Limit the number of returns

$this->getField(&#39;id,name&#39;,5); // 限制返回5条记录

Copy after login

left join

$Model->join(&#39; work ON artist.id = work.artist_id&#39;)->join(&#39;card ON artist.card_id = card.id&#39;)->select();$Model->join(&#39;RIGHT JOIN work ON artist.id = work.artist_id&#39;)->select();

Copy after login

More query methods can be found here:
http://doc.thinkphp.cn/manual/query.html

Update

Update after condition selection

$User = M("User"); // 实例化User对象
 // 要修改的数据对象属性赋值$data[&#39;name&#39;] = &#39;ThinkPHP&#39;;$data[&#39;email&#39;] = &#39;ThinkPHP@gmail.com&#39;;$User->where(&#39;id=5&#39;)->save($data); // 根据条件保存修改的数据

Copy after login

Continuous operation

$User = M("User"); // 实例化User对象
 // 要修改的数据对象属性赋值$data[&#39;name&#39;] = &#39;ThinkPHP&#39;;$data[&#39;email&#39;] = &#39;ThinkPHP@gmail.com&#39;;//更新时间字段$data[&#39;time&#39;]=date("Y-m-d H:i:s", time());$User->where(&#39;id=5&#39;)->data($data)->save(); // 根据条件保存修改的数据

Copy after login

Update specific fields

$User = M("User"); // 实例化User对象
 // 更改用户的name值$User-> where(&#39;id=5&#39;)->setField(&#39;name&#39;,&#39;ThinkPHP&#39;);

Copy after login

Update multiple fields

$User = M("User"); // 实例化User对象
 // 更改用户的name和email的值$data = array(&#39;name&#39;=>&#39;ThinkPHP&#39;,&#39;email&#39;=>&#39;ThinkPHP@gmail.com&#39;);$User-> where(&#39;id=5&#39;)->setField($data);

Copy after login

Increase and decrease

$User = M("User"); // 实例化User对象$User->where(&#39;id=5&#39;)->setInc(&#39;score&#39;,3); // 用户的积分加3$User->where(&#39;id=5&#39;)->setInc(&#39;score&#39;); // 用户的积分加1$User->where(&#39;id=5&#39;)->setDec(&#39;score&#39;,5); // 用户的积分减5$User->where(&#39;id=5&#39;)->setDec(&#39;score&#39;); // 用户的积分减1

Copy after login

Delete

Conditional deletion

$User = M("User"); // 实例化User对象$User->where(&#39;id=5&#39;)->delete(); // 删除id为5的用户数据$User->where(&#39;status=0&#39;)->delete(); // 删除所有状态为0的用户数据

Copy after login

Limit the number of deletions

$User->where(&#39;status=0&#39;)->order(&#39;create_time&#39;)->limit(&#39;5&#39;)->delete();

Copy after login

Transaction

启动事务：$User->startTrans(); 
 提交事务：$User->commit();
 事务回滚：$User->rollback();

Copy after login

This article explains some basic operations about ThinkPHP 5. Database. For more related content, please pay attention to php Chinese website .

Related recommendations:

Rules for adding different data in thinkphp5

About ThinkPHP5 database and model usage

The above is the detailed content of About ThinkPHP 5. Some basic operations of database. For more information, please follow other related articles on the PHP Chinese website!