array in where condition in laravel

Question

hello i am facing problem in where condition laravel. i have two array

$a = [▼
  0 => 2
  1 => 9
  2 => 39
  3 => 174
  4 => 190
];

$b = [▼
  0 => 2
  1 => 9
  2 => 39
  3 => 174
  4 => 190
  5 => 0
];

**array values is ids.  i tried array_values($a) && array_values($b) 
i want ids like this  but not get same response.**

[ 2 ,9 ,39 ,174 ,190] && [ 2 ,9 ,39 ,174 ,190 , 0 ]

trying to get data from query like

$classrooms = Classroom::where('teacher_id', $teacherId)
                ->where('school_curriculum_id', [$b])
                ->where('hybrid_curriculum', [$b])->get();

but got null . something wrong in where condition. please help me to solve this.

protected $fillable = [
        'id', 'school_id', 'grade_id', 'teacher_id', 'school_curriculum_id', 'name', 'deleted', 'deleted_date', 'archived', 'is_hybrid', 'hybrid_curriculum', 'hybrid_grade', 'enable_auto_submit_assessment', 'timeline_type', 'timeline_modified', 'group_test_by', 'created', 'modified', 'enable_auto_lockout_unit',
    ];

What is your table structure?

Shahrukh
– Shahrukh

2021-04-15 06:47:31 +00:00
Commented Apr 15, 2021 at 6:47 — Shahrukh
– Shahrukh, Commented Apr 15, 2021 at 6:47
have you tried whereIn instead of where?

OMR
– OMR

2021-04-15 06:49:45 +00:00
Commented Apr 15, 2021 at 6:49 — OMR
– OMR, Commented Apr 15, 2021 at 6:49

ibrahim-dogan · Accepted Answer · 2021-04-15 06:54:10Z

1

Can you try this:


$classrooms = Classroom::where('teacher_id', $teacherId)
                ->whereIn('school_curriculum_id', $b)
                ->whereIn('hybrid_curriculum', $b)->get();

answered Apr 15, 2021 at 6:54

ibrahim-dogan

6211 gold badge5 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

array in where condition in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related