Query Builder: Insert, Update, Delete

<?php

// Insert
DB::table('users')->insert([
    'email' => 'test@example.com', 
    'created_at' => date('Y-m-d H:i:s'), 
    'updated_at' => date('Y-m-d H:i:s')
]);

// Insert and Get ID
$id = DB::table('users')->insertGetId([
    'email' => 'test@example.com', 
    'created_at' => date('Y-m-d H:i:s'), 
    'updated_at' => date('Y-m-d H:i:s')
]);

// Update
DB::table('users')->where('id', 1)->update([
    'email' => 'test@example.com', 
    'updated_at' => date('Y-m-d H:i:s')
]);

// Delete
DB::table('users')->where('id', 1)->delete();

?>

 

Related Snippets

•	Validation: Validator
•	Query Builder: Raw SQL Select Query
•	Database: Insert, Update, Delete
•	Query Builder: Get value of an aggregated field
•	Database: Raw SQL Select Query