Laravel Insert, Update, and Delete with DB Query

Laravel Insert, Update, and Delete with DB Query

In Laravel, you can use the DB Query builder to perform basic database operations like inserting, updating, and deleting data. This is useful when you don't need to use models or when you want to execute raw SQL queries.

Inserting Data

To insert data into a database table using the DB Query builder, you can use the insert() method. Here's an example:

$data = ['name' => 'John Doe','email' => '[email protected]','password' => bcrypt('secret'),];

DB::table('users')->insert($data);

In this example, we're inserting a new user into the users table. We first define an array of data that we want to insert, which includes the user's name, email, and password (which is hashed using Laravel's bcrypt() function). We then use the insert() method to insert the data into the table.

Updating Data

To update data in a database table using the DB Query builder, you can use the update() method. Here's an example:

DB::table('users')
->where('id', 1)
->update(['name' => 'Jane Doe']);

In this example, we're updating the name of the user with an ID of 1. We use the where() method to specify which row(s) to update, and then we use the update() method to set the new name.

Deleting Data

To delete data from a database table using the DB Query builder, you can use the delete() method. Here's an example:

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

In this example, we're deleting the user with an ID of 1. We use the where() method to specify which row(s) to delete, and then we use the delete() method to delete the data from the table.

Conclusion

The DB Query builder in Laravel provides a simple and convenient way to perform basic database operations without the need for models or raw SQL queries. By using the insert(), update(), and delete() methods, you can easily insert, update, and delete data from a database table.


Comments

No comments yet.


Add Comment