1、链接数据库(D:\laravel\yzmedu\yzm2\.env)
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=yzm
DB_USERNAME=root
DB_PASSWORD=123
2、执行原生SQL语句
1、查询数据
$data=\DB::select('select * from user');
2、删除数据
如果删除成功 返回影响行数、
var_dump(\DB::delete('delete from user where id>5'));
3、增加数据
返回值bool 如果成功 true 失败 false
var_dump(\DB::insert("insert into user values(null,'123','123',0,'23131321')"));
4、修改数据
返回值 影响行数
var_dump(\DB::update('update user set name="帅哥" where id>3'));
5、运行一段命令
\DB::statement("create database yzmedu");
\DB::statement("drop database yzmedu");
6、事物机制
\DB::beginTransaction();
删除id=1数据
$a=\DB::delete("delete from user where id=1");
删除id=10数据
$b=\DB::delete("delete from user where id=11");
if ($a && $b) {
# code...
提交事务
\DB::commit();
}else{
回滚事务
\DB::rollback();
}