insert laravel code example
Example 1: laravel insert
DB::table('users')->insert([
'email' => 'kayla@example.com',
'votes' => 0
]);
Example 2: laravel not in query
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
Example 3: laravel update from query
$affected = DB::table('users')
->where('id', 1)
->update(['votes' => 1]);
Example 4: laravel wher in
$users = DB::table('users')
->whereIn('id', [1, 2, 3])
->get();
Example 5: DB::table('users')->get();
DB::select('SELECT * FROM users WHERE name = ?', array(Input::get('name')));
Example 6: laravel 8 orderby
$flights = App\Models\Flight::where('active', 1)
->orderBy('name', 'desc')
->take(10)
->get();