+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=31)
+--- Thread: How to GET number of posts for each category with type category_post in the view (/showthread.php?tid=83017)
How to GET number of posts for each category with type category_post in the view - optic4predator1 - 09-11-2022
hello team, I'm working on a project using Codeigniter and I want to display the following data by showing the number of data in real time. I have a TABLE named POST which contains id, title, content, category_id and a TABLE named CATEGORY which contains id, category_name, category_type. So i would like to display the total of POSTS recorded for each CATEGORY selected in the request, because the CATEGORY table is used for other tables, so I want to have just categories which relates to POSTS, the query is fine but i dont know how to send the data to the view.
I have difficulties about how to display data in VIEW here an image on how I want to have the data, any help will be appreciated Thank you for your assistance, my respects
Code:
here is my Model
class My_model extends CI_Model {
function get_post_by_category() {
$q = $this->db->select(' POST.CATEGORY_ID, CATEGORY.CATEGORY_NAME, COUNT(POST.CATEGORY_ID) as total_posts, COUNT(POST.CATEGORY_ID)/COUNT(*) * 100 as percentage')
->from('POST')
->join('CATEGORY', 'POST.CATEGORY_ID= CATEGORY.ID', 'left')
->where('CATEGORY.CATEGORY_TYPE', 'TYPE_POST')
->group_by('POST.CATEGORY_ID, CATEGORY.CATEGORY_NAME')
->order_by('POST.CATEGORY_ID', 'ASC')
->get();
return $q->result();
}
}
here is my controller
public function __construct() {
parent::__construct();
$this->load->model('My_model');
}
function index() {
$this->load->model('My_model');
//config
$config['base_url'] = base_url('/?c=ui_page');
//load the method of model
$data['countdata']=$this->My_model->get_post_by_category();
//return the data in view
$this->load->view('data/my_view', $data);
}
here is my view
<table border="1">
<tbody>
<tr>
<td> CATEGORY NAME</td>
<td> Total POSTS</td>
<td> %</td>
</tr>
<?php
foreach ($countdata as $row1)
{
?><tr>
<td><?php echo $row1->CATEGORY_NAME;?></td>
<td><?php echo $row1->ID;?></td>
<td>%</td>
</tr>
<?php }
?>
</tbody>
</table>RE: How to GET number of posts for each category with type category_post in the view - JustJohnQ - 09-12-2022
Change
Code:
<tr>
<td> CATEGORY NAME</td>
<td> Total POSTS</td>
<td> %</td>
</tr>To:
Code:
<tr>
<td> CATEGORY NAME</td>
<td> Total POSTS</td>
<td><?php echo count($countdata);?></td>
</tr>