MySql Query error in Laravel

Question

I am using laravel 5.4. When trying to run

select * from `users` inner join `addprojects` on `users`.`emp_id` = `addprojects`.`emp_id` where `emp_id` = $emp_id)"

It produces:

"SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'emp_id' in where clause is ambiguous (SQL: select * from users inner join addprojects on users.emp_id = addprojects.emp_id where emp_id = $emp_id)"

$emp_id= Auth::user()->emp_id;
$projects_for_emp = DB::table('users')->join('addprojects', 'users.emp_id', '=', 'addprojects.emp_id')->where('emp_id', '$emp_id')->get();

Matiur Rahman Mozumdar · Accepted Answer · 2017-12-19 10:14:14Z

3

emp_id in both tables , so can use users.emp_id or addprojects.emp_id

->where('users.emp_id', '=', $emp_id)

edited Dec 19, 2017 at 10:14

answered Dec 19, 2017 at 10:07

Matiur Rahman Mozumdar

4511 gold badge4 silver badges12 bronze badges

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

Comments

Marek Maszay · Accepted Answer · 2017-12-19 09:56:16Z

2

You have specified column name which exists in both tables, so use users.emp_id or addprojects.emp_id doesn't matter which one

Example:

$emp_id= Auth::user()->emp_id;
$projects_for_emp = DB::table('users')
   ->join('addprojects', 'users.emp_id', '=', 'addprojects.emp_id')
   ->where('users.emp_id', '$emp_id')
   ->get();

answered Dec 19, 2017 at 9:56

Marek Maszay

1,5571 gold badge9 silver badges11 bronze badges

Comments

rubyshine72 · Accepted Answer · 2017-12-20 20:08:18Z

1

Because both users and addprojects tables have same named field "emp_id". You can change your code like following.

$emp_id= Auth::user()->emp_id;
$projects_for_emp = DB::table('users')
    ->join('addprojects', 'users.emp_id', '=', 'addprojects.emp_id')
    ->where('users.emp_id', $emp_id)
    ->get();

edited Dec 20, 2017 at 20:08

answered Dec 19, 2017 at 9:56

rubyshine72

1321 silver badge6 bronze badges

1 Comment

Mujahidur Rahman Mithun IUB Over a year ago

Thanks it works. but i think where condition does not work properly . If I return $projects_for_emp; It shows jeson word with blank page. But If I ->where('users.emp_id', '245') , It will Show value

Collectives™ on Stack Overflow

MySql Query error in Laravel

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related