Manipulating data within an object












1















Hi I am new to Laravel and php. In my database each student has three marks on each subject and I need to retrieve them and send to the view the average mark for each student.
I tried doing it like below, but the returned value is an object (e.g. [5,4,3]) and it doesn't let me count the average. Please advise how I can operate with data within the object.



$students = Student::all();



foreach ($students as $student) {

    $mathPoints = Point:: where('subject_id', 1)

        ->where('student_id', $student->id)

        ->pluck('points');

}


I tried turning it into an array by (array) method, but I couldn't calculate the sum of values with array_sum after.



Update: my Point model:



namespace AppModels;



use IlluminateDatabaseEloquentModel;



class Point extends Model

{

    //Get the student the credit points are related to

    public function student()

    {

        return $this->belongsTo('App/Models/Student');

    }

    //Get the subject the credit points are related to

    public function subject()

    {

        return $this->belongsTo('App/Models/Subject');

    }

}





php laravel-5







share|improve this question

























  • can you please post your Point model?

    – JoseLinares
    Nov 19 '18 at 9:38











  • @LiMi add that to the question

    – user10415043
    Nov 19 '18 at 9:40











  • @YashKaranke added

    – LiMi
    Nov 19 '18 at 9:44











  • Probably not part of the solution, but you have an errant space in Point:: where

    – Adam Hopkinson
    Nov 19 '18 at 9:44
















1















Hi I am new to Laravel and php. In my database each student has three marks on each subject and I need to retrieve them and send to the view the average mark for each student.
I tried doing it like below, but the returned value is an object (e.g. [5,4,3]) and it doesn't let me count the average. Please advise how I can operate with data within the object.



$students = Student::all();



foreach ($students as $student) {

    $mathPoints = Point:: where('subject_id', 1)

        ->where('student_id', $student->id)

        ->pluck('points');

}


I tried turning it into an array by (array) method, but I couldn't calculate the sum of values with array_sum after.



Update: my Point model:



namespace AppModels;



use IlluminateDatabaseEloquentModel;



class Point extends Model

{

    //Get the student the credit points are related to

    public function student()

    {

        return $this->belongsTo('App/Models/Student');

    }

    //Get the subject the credit points are related to

    public function subject()

    {

        return $this->belongsTo('App/Models/Subject');

    }

}





php laravel-5







share|improve this question

























  • can you please post your Point model?

    – JoseLinares
    Nov 19 '18 at 9:38











  • @LiMi add that to the question

    – user10415043
    Nov 19 '18 at 9:40











  • @YashKaranke added

    – LiMi
    Nov 19 '18 at 9:44











  • Probably not part of the solution, but you have an errant space in Point:: where

    – Adam Hopkinson
    Nov 19 '18 at 9:44














1












1








1








Hi I am new to Laravel and php. In my database each student has three marks on each subject and I need to retrieve them and send to the view the average mark for each student.
I tried doing it like below, but the returned value is an object (e.g. [5,4,3]) and it doesn't let me count the average. Please advise how I can operate with data within the object.



$students = Student::all();



foreach ($students as $student) {

    $mathPoints = Point:: where('subject_id', 1)

        ->where('student_id', $student->id)

        ->pluck('points');

}


I tried turning it into an array by (array) method, but I couldn't calculate the sum of values with array_sum after.



Update: my Point model:



namespace AppModels;



use IlluminateDatabaseEloquentModel;



class Point extends Model

{

    //Get the student the credit points are related to

    public function student()

    {

        return $this->belongsTo('App/Models/Student');

    }

    //Get the subject the credit points are related to

    public function subject()

    {

        return $this->belongsTo('App/Models/Subject');

    }

}





php laravel-5







share|improve this question
















Hi I am new to Laravel and php. In my database each student has three marks on each subject and I need to retrieve them and send to the view the average mark for each student.
I tried doing it like below, but the returned value is an object (e.g. [5,4,3]) and it doesn't let me count the average. Please advise how I can operate with data within the object.



$students = Student::all();



foreach ($students as $student) {

    $mathPoints = Point:: where('subject_id', 1)

        ->where('student_id', $student->id)

        ->pluck('points');

}


I tried turning it into an array by (array) method, but I couldn't calculate the sum of values with array_sum after.



Update: my Point model:



namespace AppModels;



use IlluminateDatabaseEloquentModel;



class Point extends Model

{

    //Get the student the credit points are related to

    public function student()

    {

        return $this->belongsTo('App/Models/Student');

    }

    //Get the subject the credit points are related to

    public function subject()

    {

        return $this->belongsTo('App/Models/Subject');

    }

}





php laravel-5




php laravel-5






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 19 '18 at 10:21









zedling

461220




461220










asked Nov 19 '18 at 9:36









LiMiLiMi

467




467













  • can you please post your Point model?

    – JoseLinares
    Nov 19 '18 at 9:38











  • @LiMi add that to the question

    – user10415043
    Nov 19 '18 at 9:40











  • @YashKaranke added

    – LiMi
    Nov 19 '18 at 9:44











  • Probably not part of the solution, but you have an errant space in Point:: where

    – Adam Hopkinson
    Nov 19 '18 at 9:44



















  • can you please post your Point model?

    – JoseLinares
    Nov 19 '18 at 9:38











  • @LiMi add that to the question

    – user10415043
    Nov 19 '18 at 9:40











  • @YashKaranke added

    – LiMi
    Nov 19 '18 at 9:44











  • Probably not part of the solution, but you have an errant space in Point:: where

    – Adam Hopkinson
    Nov 19 '18 at 9:44

















can you please post your Point model?

– JoseLinares
Nov 19 '18 at 9:38





can you please post your Point model?

– JoseLinares
Nov 19 '18 at 9:38













@LiMi add that to the question

– user10415043
Nov 19 '18 at 9:40





@LiMi add that to the question

– user10415043
Nov 19 '18 at 9:40













@YashKaranke added

– LiMi
Nov 19 '18 at 9:44





@YashKaranke added

– LiMi
Nov 19 '18 at 9:44













Probably not part of the solution, but you have an errant space in Point:: where

– Adam Hopkinson
Nov 19 '18 at 9:44





Probably not part of the solution, but you have an errant space in Point:: where

– Adam Hopkinson
Nov 19 '18 at 9:44












2 Answers
2






active

oldest

votes


















1














use Model::avg('columnName') to calculate average .



read more here : https://laravel.com/docs/5.4/queries#aggregates



$students = Student::all();

foreach ($students as $student){

   $mathPoints = Point::where(['subject_id'=>1,'student_id'=>$student->id])->avg('points');

   $student->avgPoint=$mathPoints;

}


inside your blade : 



{{ $student->avgPoint}}





share|improve this answer

































    1














    Point::where('student_id', $student->id)->get()


    When you use all() with Eloquent, it makes the query for you. If you use where(), you have to ‘get’ it using get() before you can use it as a collection.



    $mathPoints = Point::where('student_id', $student->id)
    
    ->get()
    
    ->pluck('points');


    However, I’d probably look at using more complicated queries to fetch this data, as you could easily end up making hundreds of queries per page, rather than just 1.






    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%2f53371784%2fmanipulating-data-within-an-object%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      1














      use Model::avg('columnName') to calculate average .



      read more here : https://laravel.com/docs/5.4/queries#aggregates



      $students = Student::all();
      
foreach ($students as $student){
      
   $mathPoints = Point::where(['subject_id'=>1,'student_id'=>$student->id])->avg('points');
      
   $student->avgPoint=$mathPoints;
      
}


      inside your blade : 



      {{ $student->avgPoint}}





      share|improve this answer






























        1














        use Model::avg('columnName') to calculate average .



        read more here : https://laravel.com/docs/5.4/queries#aggregates



        $students = Student::all();
        
foreach ($students as $student){
        
   $mathPoints = Point::where(['subject_id'=>1,'student_id'=>$student->id])->avg('points');
        
   $student->avgPoint=$mathPoints;
        
}


        inside your blade : 



        {{ $student->avgPoint}}





        share|improve this answer




























          1












          1








          1







          use Model::avg('columnName') to calculate average .



          read more here : https://laravel.com/docs/5.4/queries#aggregates



          $students = Student::all();
          
foreach ($students as $student){
          
   $mathPoints = Point::where(['subject_id'=>1,'student_id'=>$student->id])->avg('points');
          
   $student->avgPoint=$mathPoints;
          
}


          inside your blade : 



          {{ $student->avgPoint}}





          share|improve this answer















          use Model::avg('columnName') to calculate average .



          read more here : https://laravel.com/docs/5.4/queries#aggregates



          $students = Student::all();
          
foreach ($students as $student){
          
   $mathPoints = Point::where(['subject_id'=>1,'student_id'=>$student->id])->avg('points');
          
   $student->avgPoint=$mathPoints;
          
}


          inside your blade : 



          {{ $student->avgPoint}}






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 19 '18 at 9:56

























          answered Nov 19 '18 at 9:46









          Saurabh MistrySaurabh Mistry

          3,3451726




          3,3451726

























              1














              Point::where('student_id', $student->id)->get()


              When you use all() with Eloquent, it makes the query for you. If you use where(), you have to ‘get’ it using get() before you can use it as a collection.



              $mathPoints = Point::where('student_id', $student->id)
              
    ->get()
              
    ->pluck('points');


              However, I’d probably look at using more complicated queries to fetch this data, as you could easily end up making hundreds of queries per page, rather than just 1.






              share|improve this answer




























                1














                Point::where('student_id', $student->id)->get()


                When you use all() with Eloquent, it makes the query for you. If you use where(), you have to ‘get’ it using get() before you can use it as a collection.



                $mathPoints = Point::where('student_id', $student->id)
                
    ->get()
                
    ->pluck('points');


                However, I’d probably look at using more complicated queries to fetch this data, as you could easily end up making hundreds of queries per page, rather than just 1.






                share|improve this answer


























                  1












                  1








                  1







                  Point::where('student_id', $student->id)->get()


                  When you use all() with Eloquent, it makes the query for you. If you use where(), you have to ‘get’ it using get() before you can use it as a collection.



                  $mathPoints = Point::where('student_id', $student->id)
                  
    ->get()
                  
    ->pluck('points');


                  However, I’d probably look at using more complicated queries to fetch this data, as you could easily end up making hundreds of queries per page, rather than just 1.






                  share|improve this answer













                  Point::where('student_id', $student->id)->get()


                  When you use all() with Eloquent, it makes the query for you. If you use where(), you have to ‘get’ it using get() before you can use it as a collection.



                  $mathPoints = Point::where('student_id', $student->id)
                  
    ->get()
                  
    ->pluck('points');


                  However, I’d probably look at using more complicated queries to fetch this data, as you could easily end up making hundreds of queries per page, rather than just 1.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 19 '18 at 9:41









                  Thomas EdwardsThomas Edwards

                  7,32331432




                  7,32331432






























                      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%2f53371784%2fmanipulating-data-within-an-object%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

                      Guess what letter conforming each word

                      Image
                      6 $begingroup$ This is an entry in the Fortnightly Topic Challenge #41: Short and Sweet. 1 letter only could be mean anything . With an additional letter in front , could be used as medicine component and something you definitely learn or at least heard once. Add another letter in front , you would possibly hear that many times . Add an additional letter in front , you would found an independent country . With an additional letter, in the end , you would found something related to apple . Add another letter in the end , you would found something bad . Hint: Each letter is unique . word knowledge letters chemistry share | improve this question ...
                      Read more

                      Port of Spain

                      Image
                      For ports in the country of Spain, see List of ports in Spain. City in City of Port of Spain, Trinidad and Tobago Port of Spain City City of Port of Spain Top to bottom (left to right): Skyline of Port of Spain from Gulf of Paria; National Academy for the Performing Arts, Independence Square, Eric Williams Plaza; MovieTowne, Port of Port of Spain Motto(s):  "We Gather Strength As We Go Along" Port of Spain Coordinates: 10°40′N 61°31′W  /  10.667°N 61.517°W  / 10.667; -61.517 Coordinates: 10°40′N 61°31′W  /  10.667°N 61.517°W  / 10.667; -61.517 Country   Trinidad and Tobago Jurisdiction City of Port of Spain Settled 1560 Incorporated (town) 1853 Incorporated (city) 1914 Government  • Mayor Joel Martinez  • Governing body City Corporation Area [1]  • City 12 km 2 (5 sq mi) Elevation [2] 66 m (217 ft) Population (2011) [1]  • City 37,074  • Rank 3rd  • Density 3,090/km 2 (8,000/sq mi)...
                      Read more

                      Run scheduled task as local user group (not BUILTIN)

                      Image
                      0 I am trying to run a scheduled task with User Group (not a single user). This is working fine when I in the field "when running a task, use the following user account:" insert BUILTIN User Group (for example: Administrators or Users). But when I try it with the created Local User Group (example: TestGroup) it is not working. The Users in the TestGroup are the same as in the Administrators group. What could be the problem? Are there some restrictions to the Created User Group compared to BUILTINUsers? scheduled-tasks taskscheduler windowstaskschedule share | improve this question asked Nov 15 '18 at 15:36 Far...
                      Read more