Search through laravel relations with builder











up vote
1
down vote

favorite












I'm trying to work on a query builder in Laravel and want to search through a model's relations. So far my code looks like this:



$search = (new City)->newQuery();



// Search for a city based on its state.

if ($request->has('state')) {

    $inquiry->whereHas('state', function ($query) use ($request) {

        $query->whereState($request->state);

    });

}


So I have a City model and a State model. The query is supposed to look through cities and then check each one's state relation and extract the model with the relevant states.



The code doesn't produce any errors, just an empty object.






php laravel eloquent







share|improve this question
























  • Are you executing the query with ->get()?
    – Jonas Staudenmeir
    Nov 7 at 19:54















up vote
1
down vote

favorite












I'm trying to work on a query builder in Laravel and want to search through a model's relations. So far my code looks like this:



$search = (new City)->newQuery();



// Search for a city based on its state.

if ($request->has('state')) {

    $inquiry->whereHas('state', function ($query) use ($request) {

        $query->whereState($request->state);

    });

}


So I have a City model and a State model. The query is supposed to look through cities and then check each one's state relation and extract the model with the relevant states.



The code doesn't produce any errors, just an empty object.






php laravel eloquent







share|improve this question
























  • Are you executing the query with ->get()?
    – Jonas Staudenmeir
    Nov 7 at 19:54













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I'm trying to work on a query builder in Laravel and want to search through a model's relations. So far my code looks like this:



$search = (new City)->newQuery();



// Search for a city based on its state.

if ($request->has('state')) {

    $inquiry->whereHas('state', function ($query) use ($request) {

        $query->whereState($request->state);

    });

}


So I have a City model and a State model. The query is supposed to look through cities and then check each one's state relation and extract the model with the relevant states.



The code doesn't produce any errors, just an empty object.






php laravel eloquent







share|improve this question















I'm trying to work on a query builder in Laravel and want to search through a model's relations. So far my code looks like this:



$search = (new City)->newQuery();



// Search for a city based on its state.

if ($request->has('state')) {

    $inquiry->whereHas('state', function ($query) use ($request) {

        $query->whereState($request->state);

    });

}


So I have a City model and a State model. The query is supposed to look through cities and then check each one's state relation and extract the model with the relevant states.



The code doesn't produce any errors, just an empty object.






php laravel eloquent




php laravel eloquent






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 7 at 12:49









executable

964221




964221










asked Nov 7 at 12:14









roo

9319




9319












  • Are you executing the query with ->get()?
    – Jonas Staudenmeir
    Nov 7 at 19:54


















  • Are you executing the query with ->get()?
    – Jonas Staudenmeir
    Nov 7 at 19:54
















Are you executing the query with ->get()?
– Jonas Staudenmeir
Nov 7 at 19:54




Are you executing the query with ->get()?
– Jonas Staudenmeir
Nov 7 at 19:54












1 Answer
1






active

oldest

votes

















up vote
0
down vote













Try this:



City::when(request()->has('state'), function($query){

    $query->whereHas('state', function ($query){

        $query->where('state', request()->input('state'));

    });

})->get()





share|improve this answer





















    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














     

    draft saved


    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53189285%2fsearch-through-laravel-relations-with-builder%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote













    Try this:



    City::when(request()->has('state'), function($query){
    
    $query->whereHas('state', function ($query){
    
        $query->where('state', request()->input('state'));
    
    });
    
})->get()





    share|improve this answer

























      up vote
      0
      down vote













      Try this:



      City::when(request()->has('state'), function($query){
      
    $query->whereHas('state', function ($query){
      
        $query->where('state', request()->input('state'));
      
    });
      
})->get()





      share|improve this answer























        up vote
        0
        down vote










        up vote
        0
        down vote









        Try this:



        City::when(request()->has('state'), function($query){
        
    $query->whereHas('state', function ($query){
        
        $query->where('state', request()->input('state'));
        
    });
        
})->get()





        share|improve this answer












        Try this:



        City::when(request()->has('state'), function($query){
        
    $query->whereHas('state', function ($query){
        
        $query->where('state', request()->input('state'));
        
    });
        
})->get()






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 11 at 15:04









        Amir Helmy

        713




        713






























             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53189285%2fsearch-through-laravel-relations-with-builder%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            這個網誌中的熱門文章

            Xamarin.form Move up view when keyboard appear

            圖片
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I'm trying to build a Chat app UI, the idea of the Layout was pretty simple: When the input bar is focused, keyboard show up and "push" up the chat bar, as it's a grid, the ListView will resize to fit the screen: I update the input bar's margin to "push" it up: NSValue result = (NSValue)args.Notification.UserInfo.ObjectForKey(new NSString(UIKeyboard.FrameEndUserInfoKey)); CGSize keyboardSize = result.RectangleFValue.Size; if (Element != null){ Element.Margin = new Thickness(0, 0, 0,keyboardSize.Height); //push the entry up to keyboard height when keyboard is activated } And this is ...
            閱讀完整內容

            Post-Redirect-Get with Spring WebFlux and Thymeleaf

            圖片
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 Can someone explain to me how to implement the post-redirect-get pattern in Spring WebFlux and Thymeleaf? What subscribes on the database save method? @GetMapping("/register") public String showRegisterForm(Model model) { model.addAttribute("user", new User()); return "register"; } @PostMapping public String processRegisterForm(@Valid User user, BindingResult bindingResult) { if (bindingResult.hasErrors()) { return "register"; } else { userRepository.save(user); //what subscribes on this? //how to redirect on e.g. "/login"? ...
            閱讀完整內容

            Anylogic : not able to use stopDelay()

            圖片
            -2 I am building a railway station model. I want a train to depart when I click a button. I want to call stopDelay() for that but I am not sure how to do that and from which place. anylogic share | improve this question asked Nov 23 '18 at 10:12 Anupam Singh Anupam Singh 1 Hi Anupam, welcome to SOF. Please check how to ask good questions, see link below. Your question is...
            閱讀完整內容