PDO Bulk Insert (Prepared Statements)

PHP
13

Got it working! It looks like it was down to how I had the PDO Statement class extended (done so so that I can keep an eye on the number of queries run), i had:

    public function execute($bound_input_params = NULL) {
        $GLOBALS['query_count']++;

        ++$this->query_count;
        
        return parent::execute($bound_input_params = NULL);
    }

I created a new function in the PDO Statment extended class:

    public function bulk_insert($data) {
        $GLOBALS['query_count']++;

        ++$this->query_count;
        
        return parent::execute($data);
    }

I also typecast each variable (something that I really need to finish off doing everywhere). It seems like PDO is stricter possibly after version 5.5 of PHP, when it comes to extending the Statement object