All ways to insert data into MySQL database in Laravel
Explore different methods to insert data into a MySQL database in Laravel, including using Eloquent ORM and Query Builder.
In this article, you will learn about various ways to insert data into a MySQL database in Laravel. We will cover popular methods such as using Eloquent ORM, Query Builder, and more.
Method 1: Using Eloquent ORM
use App\Models\User;
// Create a new record
$user = new User();
$user->name = 'John Doe';
$user->email = '[email protected]';
$user->password = bcrypt('password');
$user->save();
Method 2: Using Eloquent with create() method
use App\Models\User;
// Use the create method to insert data
User::create([
'name' => 'Jane Doe',
'email' => '[email protected]',
'password' => bcrypt('password'),
]);
Method 3: Using Query Builder
use Illuminate\Support\Facades\DB;
// Use Query Builder to insert data
DB::table('users')->insert([
'name' => 'Alice',
'email' => '[email protected]',
'password' => bcrypt('password'),
]);
Method 4: Insert multiple records
use App\Models\User;
// Insert multiple records using insert method
User::insert([
['name' => 'Bob', 'email' => '[email protected]', 'password' => bcrypt('password')],
['name' => 'Charlie', 'email' => '[email protected]', 'password' => bcrypt('password')],
]);
Method 5: Using firstOrCreate() method
use App\Models\User;
// Find or create a new record
$user = User::firstOrCreate(
['email' => '[email protected]'], // Search condition
['name' => 'John Doe', 'password' => bcrypt('password')] // Data to insert
);
System Requirements:
- PHP 7.3 or higher
- Laravel 8.x or higher
- MySQL 5.7 or higher
How to install Laravel:
Use Composer to install Laravel:
composer create-project --prefer-dist laravel/laravel project-name
Tips:
- Always use Eloquent or Query Builder for secure and optimized database queries.
- Use the
bcrypt()function to hash passwords before saving them to the database.