/** * initializeStatement * * Initialiseer de statement en berekent de index waarop parameters zoals max en start gebonden moeten worden. * @since 23 okt 2007 * @param boolean $clear Afdwingen dat de statement opnieuw wordt aangemaakt. * @return void */ private function initializeStatement($clear = false) { if (isset($this->stmt) && $this->stmt instanceof PDOStatement && !$clear) { return; } $sql = $this->sql . " LIMIT ? OFFSET ?"; $this->logger->log($sql); $this->stmt = $this->conn->prepare($sql); $nextIndex = 1; if ($this->mode == self::MODE_PARAMETERIZED) { for ($i = 0; $i < count($this->values); $i++) { if (is_bool($this->values[$i])) { $this->stmt->bindValue($i + 1, $this->values[$i], PDO::PARAM_BOOL); } else { $this->stmt->bindValue($i + 1, $this->values[$i]); } } $nextIndex = ++$i; } $this->index['max'] = $nextIndex++; $this->index['start'] = $nextIndex++; }
public function testLogtNiet() { $logger = new KVDdom_SqlLogger(); $this->assertEquals(false, $logger->log('SELECT * FROM TEST;')); }