• 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

#3
Controller
PHP Code:
public function yourfunName(){
 
$data['gener_num'] = $this->yourModel->youModelFunction();

View

PHP Code:
<?php echo $gener_num?>   


regards
Reply

#4
$query->result() returns an array of objects.

Controller:
PHP Code:
$data['stats'] = $this->model-name->total_gender();
$this->load->view('show_stats'$data); 

View:
PHP Code:
<table>
  <tr><th>Gender</th><th>Total</th></tr>
  <?php foreach($stats as $row) : ?>
    <tr>
      <td><?= $row->gender;?></td>
      <td><?= $row->total;?></td>
    </tr>
  <?php endforeach;?>
</table> 

Note: <?= is short for: <?php echo
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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