@automica you said "no need to pass auth into blade as you can access it directly as auth()" how do i do this because i just followed your method and i'm getting this error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'settings.user_id' in 'where clause' (SQL: select * from `settings` where `settings`.`user_id` = 3 and `settings`.`user_id` is not null)

@Megatech show us the schema of all 3 tables

@Megatech how are you associating settings and user?

if user hasMany settings, you'd put the user_id on the settings table.

lets see a schema please

@automica please disregard how i am retrieving the Settings, it is not associated with the users. This is how i am actually using the setting in my main file.

    $user = auth()->user();
    $settings = Setting::get();
    $card = Card::where('user_id', $user->id)->first(); 
    return view('user.dashboard', compact('user', 'settings', 'card'));

here is my setting schema

Schema::create('settings', function (Blueprint $table) {
            $table->id();
            $table->text('site_desc')->nullable();
            $table->string('tawk_id')->nullable();
            $table->string('email')->nullable();
            $table->string('mobile')->nullable();
            $table->text('address')->nullable();
            $table->string('gradient1')->nullable();
            $table->string('gradient2')->nullable();
            $table->integer('email_notify')->nullable();
            $table->integer('sms_notify')->nullable();
            $table->integer('kyc')->nullable();
            $table->integer('email_verification')->nullable();
            $table->integer('sms_verification')->nullable();
            $table->integer('registration')->nullable();
            $table->timestamps();
        });

the setting just only control how the dashboard operate, for example the registration table check the status of the registration if the app accept new registration or not, something like that.

Now i'm trying to retrieve data as an array so that i don't pass too many variable in the return view like this

    return view('user.dashboard', compact('data')); //everything should be inside the data

i tried this but did not work

$user = auth()->user();
$data['setting'] = Setting::get();
$data['card'] = Card::where('user_id', $user->id)->first();
return view('user/dashboard', compact($user, $data));

I think the problem is from the last line, the blade view is not receiving the data

@automica Thanks for your support, i got it working with the help of @kokoshneta.

@kokoshneta @kokoshneta i used your method and i'm getting

Property [mastercard] does not exist on this collection instance.

it seems like it is not getting anything from the table, meanwhile here is my card schema

 Schema::create('cards', function (Blueprint $table) {
            $table->id();
            $table->integer('user_id')->nullable();
            $table->string('mastercard')->nullable();
            $table->string('mas_cvv')->nullable();
            $table->string('mas_exp')->nullable();
            $table->string('visacard')->nullable();
            $table->string('visa_cvv')->nullable();
            $table->string('visa_exp')->nullable();
            $table->timestamps();
        });

here is how i am using it in my view file

<div class="middle">
          <h1> {{$cards->mastercard}}</h1>
          <img src="{{asset('images/card chip.png')}}" class="chip">
       </div>

@Megatech I suggest you give these a read.

https://tray2.se/posts/sqlerrm

https://tray2.se/posts/database-design

https://tray2.se/posts/database-design-pasrt-2

https://tray2.se/posts/properly-formed-foreign-keys-are-your-best-friends

@Megatech In your Blade view, you try to access $cards->mastercard directly.

That won’t work if you use get(), because (as I said in my first answer), get() returns a collection of objects. The collection has no property called mastercard, that property belongs to the individual objects in the collection.

Are you certain that there will only ever be one row per user in both the cards and settings table? If so, you can simply replace get() with first(), which returns a single model instance instead of a collection.

If there may be more than one row, you should loop through the collection:

@foreach ($cards as $card)
	<div class="middle">
		<h1> {{$card->mastercard}}</h1>
		<img src="{{ asset('images/card chip.png') }}" class="chip">
	</div>
@endforeach

Also, and even more importantly:

NEVER STORE USERS’ PAYMENT CARD DETAILS IN YOUR DATABASE!!!

It’s almost certainly not legal, and you run the very real risk of having hundreds or thousands of customers’ card details stolen and abused, with you liable for the leak.

@kokoshneta Yes the table is just 1 row per user, a user can not have 2 of their data saved in that table. also this is not users real card detail, it is an auto generated numbers i used in designing a mastercard in my blade file, here is a screenshoot https://paste.pics/3620bc3ad63b6f36d834b6a867b518f3

@Megatech All right, then it should work if you just replace get() with first() (I’ve updated the original answer). And if it’s not real card data, you’re fine.

@kokoshneta can you also correct the return view because yours is throwing an error, the blade file is not receiving the datas, then i can mark it as best answer. thanks

return view('user.dashboard', compact('user', 'settings', 'cards'));

using this works fine.

@Megatech Oh, pure brainfart – fixed now!

@kokoshneta also is there a way to shorten the return view, for example if i want to retrieve from "settings", "users", "categories", "card", instaed of retrieving them individually like we did, we just put them in an array so that when passing it into the view blade it receives just one variable of arrays like this

return view('user.dashboard', compact( 'data')); 

everything collected should be in just one variable. because there might me cases whereby i want to retrieve data from like 10 tables, passing 10 variables in the return view is somehow.

@Megatech Sure, you can do that. You would then use $data['user'], etc., in the Blade template.

Alternatively, if you make sure that your array is associative and your array keys are the same as the variable names you use in your Blade template, you can just pass $data directly and then keep using $user, $setting, $card and so on in your template as you’ve been doing:

// Controller
$data['user'] = $user = auth()->user();
$data['setting'] = Setting::where('user_id', $user->id)->first();
$data['card'] = Card::where('user_id', $user->id)->first();
return view('user/dashboard', $data);

// Blade template
<div class="middle">
	<h1>{{ $card->mastercard }}</h1>
	<img src="{{ asset('images/card chip.png') }}" class="chip">
</div>

@kokoshneta exactly i tried this same thing but the "$user->id" is showing red underlined. when i hover, it says "undefined variable $user"

$data['setting'] = Setting::where('user_id', $user->id)->first();
$data['card'] = Card::where('user_id', $user->id)->first();

@Megatech Oh yeah, forgot to change that. Obviously if you’re not saving the user in a variable named $user, it won’t be available for use in the other queries. You can either just use auth()->user() three times or use a temporary variable $user (as in the updated comment).

@kokoshneta do you mean something like this

$user = auth()->user();
$data['setting'] = Setting::where('user_id', $user->id)->first();
$data['card'] = Card::where('user_id', $user->id)->first();
return view('user/dashboard', extract($user, $data));

If yes, the "extract" method in the return view will be expecting an Int in the second variable, changing the extract to compac the view is not recieving the data

[[ This comment relates to an earlier version of the accepted answer. It is no longer relevant. ]]

@Megatech No, you can’t use extract() like that; the second argument to that is a flag, not an array. The updated comment above has it as it should be: compact('data') in the controller creates an array of the structure ['data' => $data]; this is passed to the view() function, and the value of each array element (there is only one) is made available to the view as a variable named from the corresponding array key; then that’s extracted into separate variables within the view.

In other words, at the start of the Blade template, the view’s symbol table will contain this:

$data = [
	'user' => (model instance of class User),
	'setting' => (model instance of class Setting),
	'card' => (model instance of class Card)
];

When you extract() that, it creates a variable in the view’s symbol table for each of the array keys, so the symbol table will then look like this:

// $data is still there
$data = [
	'user' => (model instance of class User),
	'setting' => (model instance of class Setting),
	'card' => (model instance of class Card)
];

// but so are these three
$user = (model instance of class User);
$setting = (model instance of class Setting);
$card = (model instance of class Card);

@kokoshneta Thanks, i think i missed your updated comment before, now it is working. I really appreciate your support.

@Megatech I just randomly thought of this post and realised that the compacting and extracting is completely stupid and unnecessary: $data is already an associative array, which is what the view() function expects the data parameter to be, so you can just pass it directly, as-is.

I’ve updated the accepted answer accordingly.