Laravel Query: BadMethodCallException in Builder.php line 2258:

Question

I have building a laravel application where in a controller I'm checking with time overlapping problem.

The Logic I have used is in my controller's query first I will check whether the day_id has given as input is match with database with that day_id and then it will check with the time, if it matches so it can't let user to save the input otherwise if the query failed, it will let user to save the data.

public function postAllocateRoom(Request $request)
    {


            $startTime = Carbon::parse(str_replace(array('am', 'pm'), ':00', $request->input('start')));
            $endTime = Carbon::parse(str_replace(array('am', 'pm'), ':00', $request->input('end')));
            $dayId = $request->input('day_id');

            $timeExists = ClassRoom::where('day_id', $dayId)
                                                ->andWhere('start', $startTime)
                                                ->andWhere('end', $endTime)
                                                ->exists();

            if($timeExists){
                return redirect('allocateRoomPage')->withErrors(['time' => 'Class Room Already Taken']);
            }

            $classRoom = new ClassRoom();  
            $classRoom->department_id=$request->input('department_id');     
            $classRoom->room_id=$request->input('room_id'); 
            $classRoom->course_id=$request->input('course_id'); 
            $classRoom->day_id=$dayId;
            $classRoom->start=$startTime;
            $classRoom->end=$endTime;
            $classRoom->save();

            $request->session()->flash('success', 'Successfully allocated room');

        return redirect('allocateRoomPage'); 


}

But After I run the program I'm seeing the following Error:

BadMethodCallException in Builder.php line 2258: Call to undefined method Illuminate\Database\Query\Builder::andWhere()

If anyone find the problem please help me to find the solution.

tyro · Accepted Answer · 2016-05-14 06:17:35Z

1

Simply use

 $timeExists = ClassRoom::where('day_id', $dayId)
                                            ->Where('start', $startTime)
                                            ->Where('end', $endTime)
                                            ->exists();

as there is no andWhere method in laravel

answered May 14, 2016 at 6:17

tyro

1,4781 gold badge17 silver badges34 bronze badges

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

Comments

Giedrius Kiršys · Accepted Answer · 2016-05-14 06:16:08Z

1

There is no andWhere method.
Simple where(<...>)->where(<...>) acts like where <...> and where <...>.

answered May 14, 2016 at 6:16

Giedrius Kiršys

5,3642 gold badges22 silver badges28 bronze badges

Collectives™ on Stack Overflow

Laravel Query: BadMethodCallException in Builder.php line 2258:

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related