insert query laravel code example
Example 1: laravel query builder data insert
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
public function create(Request $request)
{
DB::table('students')->insert([
'email' => $request->email,
'password' => Hash::make($request->password),
'address' => $request->address,
'address2' => $request->address2,
'city' => $request->city,
'country' => $request->country,
'zip' => $request->zip,
]);
return redirect('create');
}
Example 2: laravel db inserr
DB::table('users')->insert([
'email' => '[email protected]',
'votes' => 0
]);
Example 3: laravel db inserr
DB::table('users')->insert([
['email' => '[email protected]', 'votes' => 0],
['email' => '[email protected]', 'votes' => 0],
]);
Example 4: DB::table('users')->get();
DB::table('users')->where('name', Input::get('name'))->get();