How to structure multiple PHP queries

Question

I just had a question regarding how to structure a line of code that gathers all of the objects of my Task objects into my array based on a couple of conditions aka multiple queries.

What I want to do is gather all of the objects with certain department names and certain full names that are inputted by my user in another html file.

So far, it stores and displays the correct objects for departments but I can't seem to figure out how to add a full name filter too... Here's what I have so far but I can't find anything on the Internet regarding if this is correct syntax to have multiple queries. Thank you! :)

$tasks = Task::where('department',$request['selected'])->where('name'.' '.'last_name', $request['full_name'])->paginate(5);

Iatrarchy · Accepted Answer · 2017-06-12 16:56:27Z

1

You can't just append columns but you could separate the full name into first name and last name as following:

$fullName = explode(' ', $request['full_name']);
$firstName = $fullName[0];
$lastName = $fullName[1];
$tasks = Task::where('department',$request['selected'])->andWhere('name', 
$firstName)->andWhere('last_name', $lastName)->paginate(5);

answered Jun 12, 2017 at 16:56

Iatrarchy

3333 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How to structure multiple PHP queries

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