How to query two tables in Laravel

Question

I am trying to query two tables in Laravel when the user submits a form. The data is stored in the transaction table and I can also update the Account table by adding the $transactions->amt with $account->total.

I tried doing this;

public function store(Request $request)
    {
        $account = DB::table('users')
            ->join('accounts', "users.id", '=', 'accounts.user_id')
            ->select('users.*', 'accounts.*')
            ->first();

        $transaction = new Transaction();
        $data  = $this->validate($request, [
            'baddress'=>'required',
            'package'=>'required',
            'amt'=>'required',
        ]);
        $transaction->username = $account->username;          
        $transaction->baddress = $request->input('baddress');
        $transaction->package = $request->input('package');
        $transaction->amt = $request->input('amt');
        $transaction->fund_option = "Fund";
        $transaction->save();

        $bal= $transaction->amt + $account->total;

        $account->amt_paid = $bal;
        $account->total = $bal;
        $account->save();

        return redirect('/transfer')->with('success', 'Transaction has been made');
    }

but I got this error:

Call to undefined method stdClass::save()

How can I find the best method to do this?

rather than join two tables to get account info from a user, use the correct model relationship property as suggested in fabio's answer laravel.com/docs/7.x/eloquent-relationships#one-to-one — user8209791
– user8209791, Commented May 5, 2020 at 7:44

halfer · Accepted Answer · 2020-05-22 16:47:16Z

1

That error occur because $account is not collection. method save() is method from model collection.

if you want update you can use this code like.

$accountUpdate = DB::table('accounts')
          ->where('id', $account->id)
          ->update(['amt_paid' => $bal, 'total' => $bal]);

but if you want to use method save() then you have to call $account from model.

edited May 22, 2020 at 16:47

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered May 5, 2020 at 6:47

dikutandi

1271 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fabio.ivona · Accepted Answer · 2020-05-05 06:47:53Z

1

$account is a row made by your join (users.* and accounts.*) so it's a stdClass, not an Eloquent model. You don't have a save() method

in order to do this you should have a relationship between User model and Account model:

//Account.php

public function user(){
     return $this->belongsTo("App\User");
}

........

//User.php

public function account(){
     return $this->hasOne("App\Account");
}

then you can retrieve Account from your User:

$user = User::first();

$account = $user->account;

[....]

$account->amt_paid = $bal;
$account->total = $bal;
$account->save();

answered May 5, 2020 at 6:47

fabio.ivona

6189 silver badges26 bronze badges

Comments

A.A Noman · Accepted Answer · 2020-05-05 07:03:50Z

1

You have to use like this. This is simple as like as much

$accountModelUpdate = DB::table('accounts')
      ->where('user_id', $account->id)
      ->update(['amt_paid' => $bal, 'total' => $bal]);

answered May 5, 2020 at 7:03

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

How to query two tables in Laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related