Database: Insert, Update, Delete

<?php

DB::insert('insert into users (name, email) values (?, ?)', ['test', 'test@example.com']);

$affected = DB::update('update users set email = ? where id = ?', ['test@example.com', 1]);

$deleted = DB::delete('delete from users where id = ?', [1]);

?>

 

Related Snippets

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