Level 104
There is an increment Builder method for this
https://laravel.com/docs/9.x/queries#increment-and-decrement
Example:
$profile = Profile::where('user_id', auth()->id())->first();
$profile->increment('views');
1 like
Mar 23, 2022
13
Level 17
Adding +1 to a column
I want my code to work so that when you visit the profiles page it adds 1 to the views column.
Level 17
I also want to set up to echo virtual items from columns without js in my views.
1 like
Level 104
I don't know what you mean - explain?
Level 17
@tykus I need for Laravel to echo Html for SQL columns rather than using JS to do that.
Level 104
@aeothegod I don't know if I'm missing something here... you can use Blade to render model properties to HTML
Level 17
for example here's my HTML code
<div class="row" id="items"></div>
Level 104
@aeothegod what does that script tag have to do with the database and database columns?
EDIT you removed the earlier code snippet?
Level 17
i want to echo html using for each but I don't have a class to grab items from
Level 17
Level 104
@aeothegod you can fetch data from the database using the query builder:
$items = DB::table('table_name')->where('some_column', '=', 'some_value')->get();
Passing this $items variable to a Blade template:
@foreach($items as $item)
<!-- markup -->
{{ $item->column_name }}
@endforeach
Level 1
Hey!
You can use it this way also,
->update([ 'loyalty_points' => DB::raw('loyalty_points + 1') ]);
Level 17
@divya.kanak Thanks!
Please or to participate in this conversation.