- Updates
- Deletes

Laravel's database query builder provides a convenient, fluent interface to creating and running database queries.
- It uses PDO parameter binding to protect your application against SQL injection. There is no need to clean strings passed as bindings.

First, add the DB facade in your controller:
use Illuminate\Support\Facades\DB;
Then, you may use the table() method on the DB facade to begin a query.


To execute Inserts statements with query builder, use the insert() method. It accepts an array of column names and values.
DB::table('users')->insert(['name'=>'MarPlo', 'votes'=>0]);
- To insert several records into the table with a single call to insert(), pass an array of arrays.
 ['name'=>'MarPlo', 'votes'=>0],
 ['name'=>'PloMar', 'votes'=>0]

Auto-Incrementing ID

If the table has an AUTO-INCREMENTING id, use the insertGetId() method to insert a record and then retrieve the ID.
$id = DB::table('users')->insertGetId(['name'=>'MarPlo', 'votes'=>0]);


To update records in MySQL with query builder, use the update() method. It accepts an array of column names and values.
You may also use where() clauses.
DB::table('users')->where('id', 1)->update(['votes'=>1]);
- When updating a JSON column (on databases that support JSON columns), use "->" syntax to access the appropriate key in the JSON object.
DB::table('users')->where('id', 1)->update(['options->enabled'=>true]);

Increment / Decrement

For incrementing or decrementing the value of a column, you may use the increment('col', $nr) / decrement('col', $nr) methods.
The first argument is the 'column name', the second argument is optional, a number to control the amount by which the column should be incremented or decremented.

DB::table('users')->increment('votes', 5);


DB::table('users')->decrement('votes', 5);
- You may also specify additional columns to update during the operation.
DB::table('users')->increment('votes', 1, ['name'=>'MarPlo']);


To delete records in MySQL with query builder, use the delete() method.
You may also use where() clauses.
DB::table('users')->where('votes', '>', 10)->delete();
- If you wish to truncate the entire table (which will remove all rows and reset the auto-incrementing ID to zero), you may use the truncate() method.

- Documentation: Laravel - Database: Query Builder

Daily Test with Code Example

Which HTML element can be used to embed a SWF flash content?
<object> <div> <script>
<object type="application/x-shockwave-flash" data="file.swf" width="500" height="250">
 <param name="src" value="file.swf" />
 Your browser not support SWF.
Which CSS pseudo-class adds a style to an input form field that has keyboard input focus?
:active :focus :hover
input:focus {
  background-color: #88fe88;
Click on the instruction which converts a JSON string into a JavaScript object.
JSON.stringify(javascript_object) object.toString() JSON.parse(json_string)
var jsnstr = '{"url": "http://coursesweb.net/", "title": "Web Development Courses"}';
var obj = JSON.parse(jsnstr);
Indicate the PHP function which can be used to create or write a file on server.
fopen() file_put_contents() file_get_contents()
if (file_put_contents("file.txt", "content")) echo "The file was created";
else echo "The file can not be created";
MySQL Query Builder: Insert, Update, Delete

Last accessed pages

  1. Read Excel file data in PHP - PhpExcelReader (61099)
  2. PhpSpreadsheet - Read, Write Excel and LibreOffice Calc files (12084)
  3. Dynamically PHP Maps with Rectangle, Parallelogram, and Rhomb Shapes (550)
  4. innerHTML in PHP (7023)
  5. Convert XML to JSON in JavaScript (18610)

Popular pages this month

  1. Insert, Select and Update NULL value in MySQL (516)
  2. Read Excel file data in PHP - PhpExcelReader (431)
  3. PhpSpreadsheet - Read, Write Excel and LibreOffice Calc files (320)
  4. PHP getElementById and getElementsByTagName (255)
  5. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (234)