Best Method to store a Checkbox

First, If I were you I would do the sql part in the Model file. Also a foreach in another one is nod adviced. It's not good. You need to handle it in sql.


In your Model :

PHP Code:

public function getCategoriesWithProducts() {
        $builder = $this->db->table('categories');
        $builder->select('categories.category_name, products.product_name');
        $builder->join('products', 'categories.category_id = products.category_id', 'left');
        $builder->orderBy('categories.category_name');
        return $builder->get()->getResultArray();
    } 


In Your Controller:

PHP Code:

public function showCategoriesWithProducts() {
    $categoryModel = new CategoryModel();
    $data['results'] = $categoryModel->getCategoriesWithProducts();
    return view('categories_view', $data);
} 


And In your View:

PHP Code:

<?php foreach ($results as $row): ?>
    <h2><?= $row['category_name']; ?></h2>
    <p><?= $row['product_name']; ?></p>
<?php endforeach; ?>

In bocca al lupo!