How to create categories and associate them with posts - 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 create categories and associate them with posts (/showthread.php?tid=68940) |
How to create categories and associate them with posts - Marcolino92 - 09-15-2017 Hi guys, I'm using the Codeigniter framework, I'm fine. However, I would need help with the creation of categories associated with any hypothetical post. I'm creating a small script where every post has to be associated with a category, but it is not practical to follow the right practices for creating tables in databases. If anyone can help me, I would be grateful. In the database I guess I can create these tables and fields: Post: id, title, description, category Categories: id, category_name So, I create categories within "Categories". Subsequently, each post has the classic id, title, description, and assigned category. In my home, I show all the results. While in the category page I get only the results associated with the category. This is how I think it should be done in words, if anyone can advise me on an article maybe it would be better. Thanks to anyone who will help me! RE: How to create categories and associate them with posts - ciadvantage - 09-15-2017 I think you may have to decide if it is 1-1 relation or 1-many. For example, if post only belongs to one category or possible a post may have more than one category it is up to you to think of designing your database. Either case the query to show all results is straight forward. Regards RE: How to create categories and associate them with posts - Marcolino92 - 09-16-2017 I would like posts to have only one category. Could you give me an example of the schema that should have the database? for example: category: id_cat, id_post, etc RE: How to create categories and associate them with posts - Marcolino92 - 09-16-2017 I'm doing some tests, like counting how many posts are in a category. Unfortunately I can not get it running because it tells me it can not pick up the variable, but if I do "echo" me it prints correctly. Anyway, I cleaned up everything and now only show all the results in the "love" category. How can I make the variable of all categories in place? Controller: PHP Code: public function category($slug_category) { Model PHP Code: public function countPostCat() { Views PHP Code: (<?php echo $this->admin_model->countPostCat(); ?>) RE: How to create categories and associate them with posts - Wouter60 - 09-16-2017 In your model, create function that groups the results on 'slug_category' and counts how many records are in each category. PHP Code: public function count_per_category() Call this function from your controller, not from the view. Controller: PHP Code: $data['cpcs'] = $this->admin_model->count_per_category(); In the view: PHP Code: <table> RE: How to create categories and associate them with posts - Marcolino92 - 09-16-2017 Thanks a lot, you've been helpful. Unfortunately, however, you show me all the categories and their relative counts. I would like to show every single category, I'll explain it better. If you go to miosito.com/category/love I show counting articles and articles Thank you anyway, you have been kind PS: Okay, okay, I did this PHP Code: public function category($slug_category) { RE: How to create categories and associate them with posts - Wouter60 - 09-16-2017 Quote:If you go to miosito.com/category/love No, it doesn't. It gives a blank page. If you just want the count of one category, you could do this: PHP Code: public function count_per_category($category=NULL) Now, the function is flexible. You can use it to get the count of all categories, or just one category. |