Laravel - sql query with session

Question

I would like to display the table based on SESSION USERNAME and using the following query but I am getting error.

SELECT tb_list.* FROM tb_list  
WHERE username = ".Session::get('username')."

Error: Class 'App\Models\Session' not found

Could you please help me

Regards

Md. Abutaleb · Accepted Answer · 2016-11-25 20:32:47Z

1

You have to use Session class like:

use Session;

or

use Illuminate\Support\Facades\Session;

answered Nov 25, 2016 at 20:32

Md. Abutaleb

1,6551 gold badge15 silver badges24 bronze badges

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

2 Comments

Selim Over a year ago

Ye the second one worked. Thank you very much. But it works only when it is WHERE id = ".Session::get('uid')." How can I make it work with WHERE username = ".Session::get('username')."

Md. Abutaleb Over a year ago

For logged in user, You can try this one WHERE username = Auth::user()->username

Collectives™ on Stack Overflow

Laravel - sql query with session

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related