使用DB类(不推荐)
use DB ;
function getMovie ( ) {
return DB : : table ( 'movies' )
- > select ( 'title' , 'poster' , 'rate as number' )
- > where ( 'rate' , '>=' , '8.5' )
- > orderBy ( 'rate' , 'asc' )
- > get ( ) ;
}
使用模型
php artisan make: model Model/ Home/ Member
<?php
namespace App\ model\ Home ;
use Illuminate\ Database\ Eloquent\ Model ;
class Member extends Model
{
protected $table = 'member' ;
protected $primaryKey = 'id' ;
public $timestamps = false ;
protected $fillable = [ 'id' , 'name' , 'age' , 'email' ] ;
}
use App\ Model\ Home\ Member ;
$res = Member: : create ( [ 'name' = > '007' , 'age' = > '15' , 'email' = > '007@mf.site' ] ) ;
$res = Member: : where ( 'id' , '=' , '24' ) - > delete ( ) ;
$res = Member: : where ( 'name' , 'dq' ) - > update ( [ 'age' = > '26' ] ) ;
$res = Member: : find ( 10 ) ;
$res = Member: : get ( ) ;
$res = Member: : where ( 'id' , '<' , '40' ) - > first ( ) ;
$res = Member: : where ( 'id' , '<' , '20' ) - > select ( 'name' , 'age' ) - > orderBy ( 'age' , 'desc' ) - > get ( ) ;
$res = Member: : all ( ) - > toArray ( ) ;