• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to get values from single coloumn

#1
Hello,


I have a table for personal data, which contains contents such as name, address, gender, etc.
now I want to calculate the total male or female from the gender column, so I make a sql query like this:

Code:
SELECT gender, COUNT(*) AS total
FROM personaldata
GROUP BY gender

the result is :

Quote:man : 3
woman : 6





So, how do I write the code on the model and controller and display it on my website?
this is my code so far:

PHP Code:
   public function total_gender()
 
   {
 
       $this->db->select('gender, count(*) as total');
 
       $this->db->from('personaldata');
 
       $this->db->group_by('gender');

 
       $query $this->db->get()->row()->total;
 
       return $query->result();
 
   


Thank you and sorry for my bad english   Angel
Reply

#2
@ravhirzldi

Maybe these links will help:
https://codeigniter.com/user_guide/general/views.html (simply replace the array with the results from a model method)

https://www.guru99.com/codeigniter-mvc-framework.html
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.