- 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.

Inserts

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.
DB::table('users')->insert([
 ['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]);

Updates

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');

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

DB::table('users')->decrement('votes');

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']);

Deletes

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.
DB::table('users')->truncate();


- Documentation: Laravel - Database: Query Builder

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which attribute specifies the URL address where to send the form-data?
method action name
<form action="script.php" method="post"> ... </form>
Which CSS property can be used to break lines in the middle of words?
word-wrap line-height font-size
#id {
  width: 100px;
  word-wrap: break-word;
}
Which function sorts the elements of an array into alphabetical order, based on the string values?
pop() sort() shift()
var tutorials = ["php", "html", "css", "flash"];
tutorials.sort();
alert(tutorials[0]);          // css
Indicate the function that returns the value of the last element into an array.
current() next() end()
$code =[10=>"Perl", 20=>"PHP", 21=>"Python", 30=>"JavaScript");
$last = end($code);
echo $last;      // JavaScript
MySQL Query Builder: Insert, Update, Delete

Last accessed pages

  1. CSS Rhombus Shape (4422)
  2. jQuery Drag and Drop Rows between two similar Tables (8737)
  3. Read Excel file data in PHP - PhpExcelReader (72545)
  4. Get Attribute (ID, Class, Name, Title, Src) with jQuery (64674)
  5. Draw arrow markers with clicks in html element (1932)

Popular pages this month

  1. Making DIV Contents Scroll Horizontally, with multiple Div`s inside (796)
  2. Contact page - CoursesWeb (774)
  3. Tabs effect with CSS (771)
  4. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (249)
  5. PHP getElementById and getElementsByTagName (188)