Add a number to the record

[ali_254]

I want to add a value to the field, and keep the previous value in the field.How does it work?

 

 

    $data['count'] = 1;
        DB::table('posts')->where('id' , $id)->update($data);

 

[requinix]

You can't both change and not-change the value.

Explain what you're trying to do in more detail.

[ali_254]

ok thanks....

I want to get the number of views of an posts(Articles).

I created a field in the posts table, I want to add a value to the field every time the code is executed.

As a result, I have to update the value of a field , By maintaining the previous value that exists in the database.

 

i want update a field , By maintaining the previous value

DB::table('posts')->where('id' , $id)->update($data);

Edited August 12, 2021 by ali_254

[requinix]

So you want a query like

UPDATE posts SET count = count + 1 WHERE id = $id

 

[ali_254]

53 minutes ago, requinix said:

So you want a query like

UPDATE posts SET count = count + 1 WHERE id = $id

 

ok thanks , but this procedure use in 'Pure PHP' ! .

i want update database in laravel framework and this Command Will not work!

i use from query builder in laravel

Edited August 12, 2021 by ali_254

[requinix]

Yes, it is possible to make that query happen with the query builder. Have you looked around to see what kinds of options you have available to use?

[ali_254]

thanks... we can use from this cod:

 

   DB::table('posts') ->where('id' , $id)

            ->increment('counter', 1);