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

(05-31-2020, 07:37 PM)krishnamhnsingh Wrote: What if i want to pass arguments to this function


function getQuizes($course_id) {
        $db = db_connect();
        $builder = $db->table('quiz_courses');

        $quizes = $this->whereIn('id', function(BaseBuilder $builder,$course_id) {
                    return $builder->select('quiz_id')->distinct()->from('quiz_courses')->where('course_id', $course_id);
                })->get();

        return $quizes;
    }

getting error

Too few arguments to function App\Models\QuizModel::App\Models\{closure}(), 1 passed in C:\wamp64\www\ci-news\vendor\codeigniter4\framework\system\Database\BaseBuilder.php on line 1032 and exactly 2 expected

PHP Code:
use CodeIgniter\Database\BaseBuilder;

function 
getQuizes($course_id) {
        $db db_connect();
        $builder $db->table('quiz_courses');

        $quizes $this->whereIn('id', function(BaseBuilder $builder) use ($course_id) {
            return $builder->select('quiz_id')->distinct()->from('quiz_courses')->where('course_id'$course_id);
        })->get();

        return $quizes;

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