Random query
$data=Move::where('release',1)
->where('is_hot',1)
->where('is_status',1)
->orderBy(\DB::raw('RAND()'))
->take(4)
->get();
The operation requires creating the corresponding model
class User extends Eloquent
2. There are two ways to use data to operate objects
a. Method of executing an object after creating it with new keyword
b. Directly call the static method (actual concurrent static method, but generated by fascade)
3. Common data operations
a. User::find(1) Find a single piece of data
b. User::all() finds all data
c. User::find(1)->delete() Delete a single piece of data
d. User::destory(array(1,2,3)) Delete a single or multiple data
e. User::save() Save data
f. User::first() Get the first piece of data
g. Album::where('artist', '=', 'Matt Nathanson') ->update(array('artist' => 'Dayle Rees')); Specify query conditions and update data
h. User::truncate() Clear the data table, dangerous operation
i. Album::where('artist', '=', 'Something Corporate')->get(array('id','title')); Get multiple pieces of data in conjunction with query conditions
j. Album::pluck('artist'); Returns the first record of this field in the table
k. Album::lists('artist'); Returns a column of data
l. Album::where('artist', '=', 'Something Corporate')->toSql(); Get the query SQL statement, only used for conditions, cannot be used in queries such as get(), etc.
Note:Directly use return to query data in json format
The User used here is the model name
Conditional query:
1. The most common conditional query User::where('field name','query characters','restrictions') Example: Album::where('title', 'LIKE', '...%')
2. Multi-condition query, using multiple where Album::where('title', 'LIKE', '...%')->where('artist', '=', 'Say Anything')->get();
3. Or use orWhere() for query operations, and use the method to where
4. Directly write query conditions using SQL statements Album::whereRaw('artist = ? and title LIKE ?', array('Say Anything', '...%'))
5. Other query methods
whereIn(), whereBetween(), whereNested() subquery, orWhereNested(), whereNotIn(), whereNull(), whereNotNull(), whereNotNull()
6. ShortcutswhereUsername('king') query the data of 'username' = 'king'. This method is not available in the default system. Username is the field name.
Result sort:
Use the order keyword:
Album::where('artist', '=', 'Matt Nathanson')->orderBy('year')->get(); defaultasc
orderBy('year', 'desc')
Limit the number of results
take()method Album::take(2)->get(); //select * from `albums` limit 2
Specify offset
Album::take(2)->skip(2)->get(); //select * from `albums` limit 2 offset 2 whereRaw($where)->skip($limit)->take($pageSize)->get();
The above Laravel ORM data model operation tutorial is all the content I share with you. I hope you can give you a reference and I hope you can support me more.