Get Users by Age Using User Birthdate Column From Table












2















Brief:



I have user birthdate column in my users table. User birthdate has a default date format: Y-m-d. Also, I have custom mutator to get user age in User model.



Mutator code:



public function getAgeAttribute($value) {

    if($this->birthday !== null) {

        $bday = new DateTime("{$this->birthday}");

        $today = new Datetime(date('Y-m-d'));

        $diff = $today->diff($bday);



        return $diff->y;

    }



    return null;

}


Question:



How I can get users by age using User model?






laravel eloquent laravel-5.7







share|improve this question




















  • 2





    what do you mean by age ? you mean that you want to fetch all users greater than 20 years?

    – hassan
    Oct 29 '18 at 8:11











  • Yes of course @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:12






  • 2





    what is the column type? datetime/date?

    – hassan
    Oct 29 '18 at 8:13






  • 1





    Column type string. If you think will change the type of field to date from string, I will change it. @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:16






  • 1





    you might want to use a local scope for that.

    – duckduckduck
    Oct 29 '18 at 9:08


















2















Brief:



I have user birthdate column in my users table. User birthdate has a default date format: Y-m-d. Also, I have custom mutator to get user age in User model.



Mutator code:



public function getAgeAttribute($value) {

    if($this->birthday !== null) {

        $bday = new DateTime("{$this->birthday}");

        $today = new Datetime(date('Y-m-d'));

        $diff = $today->diff($bday);



        return $diff->y;

    }



    return null;

}


Question:



How I can get users by age using User model?






laravel eloquent laravel-5.7







share|improve this question




















  • 2





    what do you mean by age ? you mean that you want to fetch all users greater than 20 years?

    – hassan
    Oct 29 '18 at 8:11











  • Yes of course @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:12






  • 2





    what is the column type? datetime/date?

    – hassan
    Oct 29 '18 at 8:13






  • 1





    Column type string. If you think will change the type of field to date from string, I will change it. @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:16






  • 1





    you might want to use a local scope for that.

    – duckduckduck
    Oct 29 '18 at 9:08
















2












2








2








Brief:



I have user birthdate column in my users table. User birthdate has a default date format: Y-m-d. Also, I have custom mutator to get user age in User model.



Mutator code:



public function getAgeAttribute($value) {

    if($this->birthday !== null) {

        $bday = new DateTime("{$this->birthday}");

        $today = new Datetime(date('Y-m-d'));

        $diff = $today->diff($bday);



        return $diff->y;

    }



    return null;

}


Question:



How I can get users by age using User model?






laravel eloquent laravel-5.7







share|improve this question
















Brief:



I have user birthdate column in my users table. User birthdate has a default date format: Y-m-d. Also, I have custom mutator to get user age in User model.



Mutator code:



public function getAgeAttribute($value) {

    if($this->birthday !== null) {

        $bday = new DateTime("{$this->birthday}");

        $today = new Datetime(date('Y-m-d'));

        $diff = $today->diff($bday);



        return $diff->y;

    }



    return null;

}


Question:



How I can get users by age using User model?






laravel eloquent laravel-5.7




laravel eloquent laravel-5.7






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 14 '18 at 21:56









Karl Hill

2,93412142




2,93412142










asked Oct 29 '18 at 7:59









Andreas HunterAndreas Hunter

745518




745518








  • 2





    what do you mean by age ? you mean that you want to fetch all users greater than 20 years?

    – hassan
    Oct 29 '18 at 8:11











  • Yes of course @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:12






  • 2





    what is the column type? datetime/date?

    – hassan
    Oct 29 '18 at 8:13






  • 1





    Column type string. If you think will change the type of field to date from string, I will change it. @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:16






  • 1





    you might want to use a local scope for that.

    – duckduckduck
    Oct 29 '18 at 9:08
















  • 2





    what do you mean by age ? you mean that you want to fetch all users greater than 20 years?

    – hassan
    Oct 29 '18 at 8:11











  • Yes of course @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:12






  • 2





    what is the column type? datetime/date?

    – hassan
    Oct 29 '18 at 8:13






  • 1





    Column type string. If you think will change the type of field to date from string, I will change it. @hassan

    – Andreas Hunter
    Oct 29 '18 at 8:16






  • 1





    you might want to use a local scope for that.

    – duckduckduck
    Oct 29 '18 at 9:08










2




2





what do you mean by age ? you mean that you want to fetch all users greater than 20 years?

– hassan
Oct 29 '18 at 8:11





what do you mean by age ? you mean that you want to fetch all users greater than 20 years?

– hassan
Oct 29 '18 at 8:11













Yes of course @hassan

– Andreas Hunter
Oct 29 '18 at 8:12





Yes of course @hassan

– Andreas Hunter
Oct 29 '18 at 8:12




2




2





what is the column type? datetime/date?

– hassan
Oct 29 '18 at 8:13





what is the column type? datetime/date?

– hassan
Oct 29 '18 at 8:13




1




1





Column type string. If you think will change the type of field to date from string, I will change it. @hassan

– Andreas Hunter
Oct 29 '18 at 8:16





Column type string. If you think will change the type of field to date from string, I will change it. @hassan

– Andreas Hunter
Oct 29 '18 at 8:16




1




1





you might want to use a local scope for that.

– duckduckduck
Oct 29 '18 at 9:08







you might want to use a local scope for that.

– duckduckduck
Oct 29 '18 at 9:08














4 Answers
4






active

oldest

votes


















7














Just take today's date and substract the number of years. then compare it to birthdays



Users::where('birthday', '<=', date('Y-m-d', strtotime('-20 years')))->get();





share|improve this answer
























  • adding to this answer, this logic can be enclosed on a local scope defined in the User model.

    – duckduckduck
    Oct 29 '18 at 9:17



















4














If you're using MySQL there's also this alternative:



 $users = User::whereDate('birthdate' , '<', DB::raw("CURDATE()-INTERVAL 20 YEAR"))->get();





share|improve this answer































    0














    You can use Collection's groupBy method to group the users based on their age. 



    $users = User::all()->groupBy(function($user) {
    
             return $user->age;
    
         });


    Then, you can get all users for a particular user like this.



    $users->get(20);


    Hope this is what you are looking for.






    share|improve this answer































      0














      i hope this will help you, date() function is php function which converts a string to datetime.



      $users = User::where('birthdate' , '<', date('Y-m-d', strtotime('your input field name')))->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',
        autoActivateHeartbeat: false,
        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%2f53041087%2fget-users-by-age-using-user-birthdate-column-from-table%23new-answer', 'question_page');
        }
        );

        Post as a guest















        Required, but never shown

























        4 Answers
        4






        active

        oldest

        votes








        4 Answers
        4






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        7














        Just take today's date and substract the number of years. then compare it to birthdays



        Users::where('birthday', '<=', date('Y-m-d', strtotime('-20 years')))->get();





        share|improve this answer
























        • adding to this answer, this logic can be enclosed on a local scope defined in the User model.

          – duckduckduck
          Oct 29 '18 at 9:17
















        7














        Just take today's date and substract the number of years. then compare it to birthdays



        Users::where('birthday', '<=', date('Y-m-d', strtotime('-20 years')))->get();





        share|improve this answer
























        • adding to this answer, this logic can be enclosed on a local scope defined in the User model.

          – duckduckduck
          Oct 29 '18 at 9:17














        7












        7








        7







        Just take today's date and substract the number of years. then compare it to birthdays



        Users::where('birthday', '<=', date('Y-m-d', strtotime('-20 years')))->get();





        share|improve this answer













        Just take today's date and substract the number of years. then compare it to birthdays



        Users::where('birthday', '<=', date('Y-m-d', strtotime('-20 years')))->get();






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Oct 29 '18 at 8:18









        N69SN69S

        1,107514




        1,107514













        • adding to this answer, this logic can be enclosed on a local scope defined in the User model.

          – duckduckduck
          Oct 29 '18 at 9:17



















        • adding to this answer, this logic can be enclosed on a local scope defined in the User model.

          – duckduckduck
          Oct 29 '18 at 9:17

















        adding to this answer, this logic can be enclosed on a local scope defined in the User model.

        – duckduckduck
        Oct 29 '18 at 9:17





        adding to this answer, this logic can be enclosed on a local scope defined in the User model.

        – duckduckduck
        Oct 29 '18 at 9:17













        4














        If you're using MySQL there's also this alternative:



         $users = User::whereDate('birthdate' , '<', DB::raw("CURDATE()-INTERVAL 20 YEAR"))->get();





        share|improve this answer




























          4














          If you're using MySQL there's also this alternative:



           $users = User::whereDate('birthdate' , '<', DB::raw("CURDATE()-INTERVAL 20 YEAR"))->get();





          share|improve this answer


























            4












            4








            4







            If you're using MySQL there's also this alternative:



             $users = User::whereDate('birthdate' , '<', DB::raw("CURDATE()-INTERVAL 20 YEAR"))->get();





            share|improve this answer













            If you're using MySQL there's also this alternative:



             $users = User::whereDate('birthdate' , '<', DB::raw("CURDATE()-INTERVAL 20 YEAR"))->get();






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Oct 29 '18 at 8:46









            apokryfosapokryfos

            19k43159




            19k43159























                0














                You can use Collection's groupBy method to group the users based on their age. 



                $users = User::all()->groupBy(function($user) {
                
             return $user->age;
                
         });


                Then, you can get all users for a particular user like this.



                $users->get(20);


                Hope this is what you are looking for.






                share|improve this answer




























                  0














                  You can use Collection's groupBy method to group the users based on their age. 



                  $users = User::all()->groupBy(function($user) {
                  
             return $user->age;
                  
         });


                  Then, you can get all users for a particular user like this.



                  $users->get(20);


                  Hope this is what you are looking for.






                  share|improve this answer


























                    0












                    0








                    0







                    You can use Collection's groupBy method to group the users based on their age. 



                    $users = User::all()->groupBy(function($user) {
                    
             return $user->age;
                    
         });


                    Then, you can get all users for a particular user like this.



                    $users->get(20);


                    Hope this is what you are looking for.






                    share|improve this answer













                    You can use Collection's groupBy method to group the users based on their age. 



                    $users = User::all()->groupBy(function($user) {
                    
             return $user->age;
                    
         });


                    Then, you can get all users for a particular user like this.



                    $users->get(20);


                    Hope this is what you are looking for.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Oct 29 '18 at 8:24









                    Nabin PaudyalNabin Paudyal

                    666212




                    666212























                        0














                        i hope this will help you, date() function is php function which converts a string to datetime.



                        $users = User::where('birthdate' , '<', date('Y-m-d', strtotime('your input field name')))->get();






                        share|improve this answer




























                          0














                          i hope this will help you, date() function is php function which converts a string to datetime.



                          $users = User::where('birthdate' , '<', date('Y-m-d', strtotime('your input field name')))->get();






                          share|improve this answer


























                            0












                            0








                            0







                            i hope this will help you, date() function is php function which converts a string to datetime.



                            $users = User::where('birthdate' , '<', date('Y-m-d', strtotime('your input field name')))->get();






                            share|improve this answer













                            i hope this will help you, date() function is php function which converts a string to datetime.



                            $users = User::where('birthdate' , '<', date('Y-m-d', strtotime('your input field name')))->get();







                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Oct 29 '18 at 8:27









                            Naveed AliNaveed Ali

                            22916




                            22916






























                                draft saved

                                draft discarded




















































                                Thanks for contributing an answer to Stack Overflow!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid …



                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.


                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function () {
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53041087%2fget-users-by-age-using-user-birthdate-column-from-table%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







                                -

                                Popular posts from this blog

                                Xamarin.iOS Cant Deploy on Iphone

                                Image
                                .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } -1 I have a windows laptop and a mac mini my problem is that It wont deploy on iphone if I use Visual Studio Xamarin on windows to install my app, but it works fine with Visual Studio For Mac. Here's what I get after build succeded on Visual Studio Xamarin on windows : 1>------ Build started: Project: FinalCustomerApp.iOS, Configuration: Debug iPhone ------ 1> Connecting to Mac server 192.168.8.100... 1> FinalCustomerApp.iOS -> C:UsersJeremy PaulDesktopFinalCustomerAppFinalCustomerAppFinalCustomerApp.iOSbiniPhoneDebugFinalCustomerApp.iOS.exe 1> Detected signing identity: 1> Code Signing Key: &quo
                                Read more

                                Glorious Revolution

                                Image
                                "The Bloodless Revolution" redirects here. For a history of the vegetarian movement, see The Bloodless Revolution (book). This article is about the English revolution of 1688. For the revolution of 1868 in Spain, see Glorious Revolution (Spain). For other uses, see Glorious Revolution (disambiguation). Glorious Revolution The Prince of Orange lands at Torbay Date 1688–1689 Location British Isles Also known as Revolution of 1688 War of the English Succession Bloodless Revolution Participants English, Welsh and Scottish society, Dutch forces Outcome Replacement of James II by William III and Mary II Jacobite rising of 1689 Williamite War in Ireland War with France; England and Scotland join Grand Alliance Drafting of the Bill of Rights 1689 Part of a series on the History of England Timeline Prehistoric Britain Roman Britain Sub-Roman Britain Medieval period Economy in the Middle Ages Anglo-Saxon period
                                Read more

                                Dulmage-Mendelsohn matrix decomposition in Python

                                Image
                                0 Matlab has a function called dmperm that computes the so-called Dulmage–Mendelsohn decomposition of a n x n matrix. From wikipedia, the Dulmage–Mendelsohn is a partition of the vertices of a bipartite graph into subsets, with the property that two adjacent vertices belong to the same subset if and only if they are paired with each other in a perfect matching of the graph. Looking both on scipy and numpy, I could not find this function, nor some similar version. Is it possible to implement it using basic linear algebra operations? Any idea if this is implemented in some Python package? python matlab linear-algebra graph-theory matrix-decomposition share | improve this question
                                Read more