Welcome Guest, Not a member yet? Register   Sign In
SubQuery Not Working
#5

(This post was last modified: 01-17-2021, 05:44 PM by basahbasahan.)

(10-28-2019, 03:31 PM)louieuow Wrote: I have the following function that uses a subquery and this error pops up

Code:
TypeError
Argument 1 passed to App\Models\MainModel::App\Models\{closure}() must be an instance of App\Models\BaseBuilder,
instance of CodeIgniter\Database\MySQLi\Builder given, called in C:\CI_system_4A\Database\BaseBuilder.php on line 970

PHP Code:
//-----------------------------------------------
function get_current_subjects()
    {
        $db = \Config\Database::connect();
        $builder $db->table('central.v1_cal_subjects');
        $builder $builder->distinct()->select("subject_code,subject_name");
        $builder $builder->whereIn("cal_id", function(BaseBuilder $builder)   [u][color=#e82a1f]// error on this line[/color][/u]
                                                {
                                                    return $builder->select("cal_id")->from('central.v1_calendar')->where('`year` >= year(now())'null,false); 
                                                }
                                      );
        $builder $builder->orderby("subject_code");
        $query $builder->get();
        return $query->getResultArray();
    



I used the example for the Online reference as a guide

Quote:$builder->whereIn('id', function(BaseBuilder $builder) {
    return $builder->select('job_id')->from('users_jobs')->where('user_id', 3);
});
// Produces: WHERE "id" IN (SELECT "job_id" FROM "users_jobs" WHERE "user_id" = 3)



An ideas on whats wrong with my code?
Thanx


May be it's too late. But you can use "use" in anonymous function if you want to access the variable outside the scope like this :

PHP Code:
$builder->orWhereIn("shop_id",function(BaseBuilder $builder) use ($crsk){
      return $builder->select('shop_id')->from('shops')->where('owner'$crsk);
}); 
Reply


Messages In This Thread
SubQuery Not Working - by louieuow - 10-28-2019, 03:31 PM
RE: SubQuery Not Working - by louieuow - 11-05-2019, 10:58 PM
RE: SubQuery Not Working - by dhefley - 05-10-2020, 06:45 AM
RE: SubQuery Not Working - by krishnamhnsingh - 05-31-2020, 07:37 PM
RE: SubQuery Not Working - by basahbasahan - 01-29-2021, 05:41 AM
RE: SubQuery Not Working - by paulbalandan - 01-30-2021, 09:33 AM
RE: SubQuery Not Working - by basahbasahan - 01-17-2021, 05:43 PM
RE: SubQuery Not Working - by iRedds - 01-18-2021, 07:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB