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

                                Bressuire

                                Image
                                Subprefecture and commune in Nouvelle-Aquitaine, France Bressuire Subprefecture and commune Chateau de Bressuire and the Eglise Notre-Dame Coat of arms Location of Bressuire Bressuire Show map of France Bressuire Show map of Nouvelle-Aquitaine Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Country France Region Nouvelle-Aquitaine Department Deux-Sèvres Arrondissement Bressuire Canton Bressuire Government  • Mayor .mw-parser-output .nobold{font-weight:normal} (2014–20) Jean Michel Bernier Area 1 180.59 km 2 (69.73 sq mi) Population (2014) 2 19,300  • Density 110/km 2 (280/sq mi) Time zone UTC+01:00 (CET)  • Summer (DST) UTC+02:00 (CEST) INSEE/Postal code 79049 /79300 Elevation 98–236 m (322–774 ft) (avg. 173 m or 568 ft) 1 French Land Register data, which exclude...
                                Read more

                                Vorschmack

                                Image
                                Vorschmack Ukrainian Jewish-style vorschmack served on rye bread Course Hors d'oeuvre Region or state Eastern Europe Associated national cuisine Ashkenazi Jewish, Finnish, German, Ukrainian, Polish, Russian Main ingredients Ground meat and/or fish Cookbook: Vorschmack   Media: Vorschmack Vorschmack or forshmak (Yiddish: פֿאָרשמאַק ‎, from archaic German Vorschmack , "foretaste" [1] or "appetizer" [2] ) is an originally East European dish made of salty minced fish or meat. Different variants of this dish are especially common in Ashkenazi Jewish and Finnish cuisine. Some varieties are also known in Russian and Polish cuisine. Contents 1 In Jewish cuisine 2 In Russian cuisine 3 In Polish cuisine 4 In Finnish cuisine 5 See also 6 References In Jewish cuisine According to Gil Marks, the German name points to the possible Germanic origin of this dish. [1] William Pokhlyobkin descr...
                                Read more

                                Quarantine

                                Image
                                For other uses, see Quarantine (disambiguation). Signal flag "Lima" called the "Yellow Jack" which when flown in harbor means ship is under quarantine. A simple yellow flag (also called the "Yellow Jack") had historically been used to signal quarantine (it stands for Q among signal flags), but now indicates the opposite, as a signal of a ship free of disease that requests boarding and inspection. A quarantine is used to separate and restrict the movement of people; it is 'a restraint upon the activities or communication of persons or the transport of goods designed to prevent the spread of disease or pests', for a certain period of time. [1] This is often used in connection to disease and illness, such as those who may possibly have been exposed to a communicable disease. [2] The term is often erroneously used to mean medical isolation, which is "to separate ill persons who have a communicable disease from those who are healthy...
                                Read more