EVOLUTION-NINJA

Edit File: Model_sub.php

<?php // app/Models/YourModel.php namespace App\Models; use CodeIgniter\Model; class Model_sub extends Model { public function getJoinedData($startDate,$endDate) { $builder = $this->db->table('register_user'); $builder->select('*'); $builder->join('subscription_payment', 'register_user.id = subscription_payment.user_id', 'inner'); if ($startDate) { $builder->where('paid_date >=', $startDate); } if ($endDate) { $builder->where('paid_date <=', $endDate); } return $builder->get()->getResultArray(); } } ?>