php原生sql
1.查询
<?php
namespace App\Http\Controllers;
use DB;
use App\Http\Controllers\Controller;
class UserController extends Controller
{
/**
* Show a list of all of the application's users.
*
* @return Response
*/
public function index()
{
$users = DB::select('select * from users where active = ?', [1]);
return view('user.index', ['users' => $users]);
}
}
或者值的绑定方式
$results = DB::select('select * from users where id = :id', ['id' => 1]);
2.插入
DB::insert('insert into users (id, name) values (?, ?)', [1, 'Dayle']);
3.跟新
返回的是影响的行数
$affected = DB::update('update users set votes = 100 where name = ?', ['John']);
4.删除
返回删除的行数
$deleted = DB::delete('delete from users');
5.对于没有返回值的操作，可以共用
DB::statement('drop table users');
2.事务
DB::transaction(function () {
DB::table('users')->update(['votes' => 1]);
DB::table('posts')->delete();
});
或者手动控制事务
DB::beginTransaction();
DB::rollBack();
DB::commit();
3.监听方法
<?php
namespace App\Providers;
use DB;
use Illuminate\Support\ServiceProvider;
class AppServiceProvider extends ServiceProvider
{
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
DB::listen(function($sql, $bindings, $time) {
//
});
}
/**
* Register the service provider.
*
* @return void
*/
public function register()
{
//
}
}
