About database operations of thinkphp5

1. Database configuration

query executeOriginal ecologysqlStatement addition, deletion, modification and query

$result = Db::execute('insert into log(user_id, ip) values(1, 11231)');
dump($result);
$result = Db::query('select * from log');
echo &#39;<pre class="brush:php;toolbar:false">&#39;;
var_dump($result);

Copy after login

Parameter binding Named placeholder binding

$str = 'insert into log(user_id, ip) values(?, ?)';
$result = Db::execute($str, [1, '12312']);

$result = Db::query('select * from log where id = ?', [4]);

//占位符
Db::execute('insert into log(user_id, ip) values(:user_id, :ip)', ['user_id'=>12, 'ip'=>'5555']);

Copy after login

Query Constructor

//添加：
Db::table('log')->insert(['user_id'=>1, 'ip'=>'654321']);

//更新
Db::table('log')
    ->where('id', 12)
    ->update(['user_id'=>123]);

//查询数据
$list = Db::table('log')
    ->where('id', 12)
    ->select();

//删除数据
Db::table('log')
    ->where('id', 10)
    ->delete();

How to query the table without adding a prefix:

Db::name('log')->insert(['user_id'=>44, 'ip'=>5555]);

##5.

Chain operation

//自动控制事物
Db::transaction(function (){
    Db::table('log')->delete(2);
    Db::table('log')->insert(['user_id'=>123]);
});

//手动控制事物的提交
//启动事物
Db::startTrans();
try {
    Db::table('log')
        ->where(2);
    Db::table('log')
        ->insert(['user_id' => 213]);
    Db::commit();
} catch (Exception $e){
    Db::rollback();
}

##How to link the database through ThinkPHP

How to connect multiple databases through thinkphp

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