All methods to UPDATE data in a MySQL database using Laravel

A comprehensive guide on how to update data in a MySQL database using Laravel, covering both Eloquent ORM and Query Builder methods.

In this article, you will explore different methods to update data in a MySQL database using Laravel. We will examine both Eloquent ORM and Query Builder to efficiently and flexibly perform data update operations.

Using Eloquent ORM to update data:

Example 1: Updating a single record using Eloquent

use App\Models\Student;

// Find the record to update
$student = Student::find(1);

// Update data
$student->name = 'Jane Doe';
$student->age = 22;
$student->save();

Using Query Builder to update data:

Example 2: Updating multiple records using Query Builder

use Illuminate\Support\Facades\DB;

// Update data using Query Builder
DB::table('students')
    ->where('id', 1)
    ->update(['name' => 'Jane Doe', 'age' => 22]);

Updating multiple records with multiple conditions:

Example 3: Updating multiple records with conditions

DB::table('students')
    ->where('age', '>', 20)
    ->update(['status' => 'active']);

Updating with Prepared Statements:

Example 4: Using Prepared Statements

$studentId = 1;
$name = 'Jane Doe';

DB::table('students')
    ->where('id', $studentId)
    ->update(['name' => $name]);

System Requirements:

• Laravel 8.x or 9.x
• MySQL

How to install Laravel:

To install Laravel, you can use Composer:

composer create-project --prefer-dist laravel/laravel your-project-name

Tips:

• Use Eloquent ORM for more complex database operations as it allows you to work with objects easily.
• Carefully check conditions when updating to avoid unintended data updates.
• Always validate data before updating to ensure data integrity.