How to get values from single coloumn - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Model-View-Controller (https://forum.codeigniter.com/forumdisplay.php?fid=10) +--- Thread: How to get values from single coloumn (/showthread.php?tid=73492) |
How to get values from single coloumn - ravhirzldi - 04-29-2019 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 the result is : Quote:man : 3 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() Thank you and sorry for my bad english RE: How to get values from single coloumn - php_rocs - 04-30-2019 @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 RE: How to get values from single coloumn - tp45 - 10-09-2019 Controller PHP Code: public function yourfunName(){ PHP Code: <?php echo $gener_num; ?> regards RE: How to get values from single coloumn - Wouter60 - 10-09-2019 $query->result() returns an array of objects. Controller: PHP Code: $data['stats'] = $this->model-name->total_gender(); View: PHP Code: <table> Note: <?= is short for: <?php echo |