laravel

文章

Laravel query builder

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;


class StudentController extends Controller
{
//query builder.

    public function query1()
    {
//        $res = DB::table('student')->insert(
//            ['name' => ' php', 'age' => 25]
//        );
//
//        var_dump($res);

        $res = DB::table('student')->insert([
                ['name' => 'golang', 'age' => 5],
                ['name' => 'c++', 'age' => 60]
            ]
        );

        var_dump($res);
    }

}

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;

class StudentController extends Controller

{

//query builder.

public function query1()

{

// $res = DB::table('student')->insert(

// ['name' => ' php', 'age' => 25]

// );

// var_dump($res);

$res = DB::table('student')->insert([

['name' => 'golang', 'age' => 5],

['name' => 'c++', 'age' => 60]

]

);

var_dump($res);

}

2018.01.03

1.5K000

文章

Laravel数据库操作之DB facade

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class Member extends Model
{

//代码格式化快捷键：command + alt + L.

//    public static function getMember(){
//        return 'This is Member.getMember';
//    }

//    public static function getMember(){
//        $member = DB::select('select * from  student');
//        var_dump($member);
//    }

//    public static function getMember(){
//        $info = DB::select('select * from student');
//        dd($info);
//    }

//    public static function getMember(){
//        $info = DB::select('select * from student where id > ? and sex = ?',
//            [1002,1]);
//        dd($info);
//    }

//    public static function getMember()
//    {
//        $info = DB::select('select * from student');
//        dd($info);
//    }

//    public static function getMember()
//    {
//        $info = DB::select('select * from student where age > ?',
//        [27]);
//        dd($info);
//    }

//    public static function getMember()
//    {
//    $info = DB::insert('insert into student(name,age) VALUES(?,?) ',
//        ['SAP',35]);
//
//    var_dump($info);
//    }

//    public static function getMember()
//    {
//        $info = DB::insert('insert into student(name,age,sex) VALUES(?,?,?) ',
//            ['Oracle', 30, 1]);
//    }

//    public static function getMember()
//    {
//        $info = DB::update('update student set name = ? where id = ?',
//            ['Microsoft', 1009]);
//    }

    public static function getMember()
    {
        $info = DB::delete('delete from student where id < ?',
            [1003]);

        var_dump($info);
    }

}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

use Illuminate\Support\Facades\DB;

class Member extends Model

{

//代码格式化快捷键：command + alt + L.

// public static function getMember(){

// return 'This is Member.getMember';

// }

// public static function getMember(){

// $member = DB::select('select * from student');

// var_dump($member);

// }

// public static function getMember(){

// $info = DB::select('select * from student');

// dd($info);

// }

// public static function getMember(){

// $info = DB::select('select * from student where id > ? and sex = ?',

// [1002,1]);

// dd($info);

// }