Lines Matching defs:sql
434 $sql = $this->getConf('insert-group');
436 $result = $this->query($sql, [':group' => $group]);
471 $sql = $this->getConf('select-user');
473 $result = $this->query($sql, [':user' => $user]);
546 $sql = $this->getConf('select-user-groups');
547 $result = $this->query($sql, $userdata);
577 $sql = $this->getConf('select-groups');
578 $result = $this->query($sql);
619 $sql = $this->getConf('join-group');
620 $result = $this->query($sql, $data);
635 $sql = $this->getConf('leave-group');
636 $result = $this->query($sql, $data);
644 * @param string $sql The SQL statement to execute
648 protected function query($sql, $arguments = [])
650 $sql = trim($sql);
651 if (empty($sql)) {
658 $sth = $this->pdo->prepare($sql);
666 if (strpos($sql, (string) $key) === false) continue; // skip if parameter is missing
679 $currentsql = $sql;
700 $dsql = $this->debugSQL($sql, $params, !defined('DOKU_UNITTEST'));
747 $sql = trim($this->getConf($key));
749 // check if sql is set
750 if (!$sql) return false;
753 if (strpos($sql, ":$param") === false) return false;
763 * @param string $sql
768 protected function debugSQL($sql, $params, $htmlescape = true)
780 $sql = str_replace($key, $val, $sql);
782 if ($htmlescape) $sql = hsc($sql);
783 return $sql;