Laravel框架DB facade數(shù)據(jù)庫(kù)操作詳解

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 '新增時(shí)間',
`updated_at` INT not null DEFAULT 0 COMMENT '修改時(shí)間'
)ENGINE=INNODB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1001 COMMENT='學(xué)生表';

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');//查找一個(gè)名為student的數(shù)據(jù)表，因?yàn)樵趀nv里我們已經(jīng)定義了數(shù)據(jù)庫(kù)的名字是laravel，而student存放在laravel里，所以我們給個(gè)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兩個(gè)問(wèn)號(hào)將name和Rarin，age和16連接起來(lái)
 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]);//這里我設(shè)置的是，如果age的值是16的時(shí)候，那么我就把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的數(shù)據(jù)
  echo "pre>";
  print_r($delete);
  echo "/pre>";
 }
}
?>