put single row to variable and delete it at same time with one query

Question

I have a password_resets table in mysql database and i want to get single raw of data and delete it with one query in Lumen with DB facade like this:

$reset_row = DB::table('password_resets')->where('token', $request->token)->first()->delete();

But i have a error :

Call to undefined method stdClass::delete()

i try this code :

  $reset_row = DB::table('password_resets')->where('token', $request->token)
  //do my work whith $reset_row->first();
  $reset_row->delete();

But i think this way use 2 query to do this work.

NOTE : i know i can not delete and reason is first() method )return it to array)

Is there any way to do this?

Please post the exact error you receive. (edit it into the question, do not post it as a comment) — Avery, Mar 26 '19 at 11:38
question updated.sorry for my mistake.(i have error in in first code) — Omid Reza Heidari, Mar 26 '19 at 11:41
As far as i know you should use models as often as possible instead of using the DB facade — Nico Bleiler, Mar 26 '19 at 11:59

score 0 · Answer 1 · answered Mar 26 '19 at 12:14

0

Actually no need to use ->first(). Bcz your token is unique.

if you need try this.

$reset_row = DB::table('password_resets')->where('token', $request->token)
    ->Limit(1)->delete();

I think it is possible to use "limit" with "delete".

answered Mar 26 '19 at 12:14

Hashan

164
8

i used this way and i get ```Trying to get property 'email' of non-object``` Error.this way don't save raw in reset_row variable !!!!! – Omid Reza Heidari Mar 26 '19 at 13:49

score 0 · Answer 2 · edited Mar 26 '19 at 13:59

0

You can simply chain the delete method to your Query Buider. No need to select the first on since you want to delete them, not select them.

DB::table('password_resets')->where('token', $request->token)->delete();

Its already answered in another post in StackOverflow.

You can use this answer too laravel-delete-query-builder and you can also look at the official documentation about deleting using the query builder

edited Mar 26 '19 at 13:59

Kerel

732
6
20

answered Mar 26 '19 at 12:40

Karan Sadana

1,363
7
11

i know i can get it by this way(!) but i want to store it in reset_row variable first!!!!! – Omid Reza Heidari Mar 26 '19 at 13:45
1

Calm down, adding extra exclamation marks isn't going to help. – Kerel Apr 24 '19 at 06:28

Omid Reza Heidari · Accepted Answer · 2019-03-27T07:09:34.453

0

At the end I Think to create model for reset password and Use it like this:

1. set primary key to token by set it on model like this

2. use find method to find token (document for find method)

use this way:

$reset=PasswordReset::find($token);
//work with $reset
$reset->delete()

NOTE: : for set primary key to string col see this link too

edited Mar 27 '19 at 07:09

answered Mar 26 '19 at 14:09

Omid Reza Heidari

658
12
27

put single row to variable and delete it at same time with one query

3 Answers3