[PHP] Laravel框架DB facade数据库操作详解

前两篇文章我们讲述了Laravel下载介绍路由和MVC几个知识点，这篇我们就来讲述一下关于数据库的操作，有关于数据库的增删改查

create table if not exists student(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '姓名',
`age` TINYINT UNSIGNED not null DEFAULT 0 COMMENT '年龄',
`sex` TINYINT UNSIGNED not null DEFAULT 10 COMMENT '性别',
`created_at` INT not null DEFAULT 0 COMMENT '新增时间',
`updated_at` INT not null DEFAULT 0 COMMENT '修改时间'
)ENGINE=INNODB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1001 COMMENT='学生表';

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class Student extends Controller
{
public function mql()
{
return 'my first mysql';
}
}

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class Student extends Controller
{
public function mql()
{
$Students = DB::select('select * from student');//查找一个名为student的数据表，因为在env里我们已经定义了数据库的名字是laravel，而student存放在laravel里，所以我们给个student即可
echo "<pre>";
print_r($Students);
echo "</pre>";
}
}

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class Student extends Controller
{
public function mql()
{
$Nadded = DB::insert('insert into student(name,age) values(?,?)',['Rarin',16]);//这里我们定义在student里的name，age新增值，values两个问号将name和Rarin，age和16连接起来
echo "<pre>";
print_r($Nadded);
echo "</pre>";
}
}

namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class Student extends Controller
{
public function mql()
{
$update= DB::update('update student set id = ? where age = ?',[1002,16]);//这里我设置的是，如果age的值是16的时候，那么我就把id的值改成1002
echo "<pre>";
print_r($update);
echo "</pre>";
}
}

<?php
namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class StudentController extends Controller
{
public function test1()
{
$delete = DB::delete('delete from student where id > ?',[1003]);//这里指的是，删除id大于1003的数据
echo "<pre>";
print_r($delete);
echo "</pre>";
}
}
?>