Lines Matching refs:sql
437 $sql = $this->getConf('insert-group');
439 $result = $this->query($sql, [':group' => $group]);
474 $sql = $this->getConf('select-user');
476 $result = $this->query($sql, [':user' => $user]);
549 $sql = $this->getConf('select-user-groups');
550 $result = $this->query($sql, $userdata);
580 $sql = $this->getConf('select-groups');
581 $result = $this->query($sql);
622 $sql = $this->getConf('join-group');
623 $result = $this->query($sql, $data);
638 $sql = $this->getConf('leave-group');
639 $result = $this->query($sql, $data);
647 * @param string $sql The SQL statement to execute
651 protected function query($sql, $arguments = []) argument
653 $sql = trim($sql);
654 if (empty($sql)) {
661 $sth = $this->pdo->prepare($sql);
669 if (strpos($sql, (string) $key) === false) continue; // skip if parameter is missing
682 $currentsql = $sql;
703 $dsql = $this->debugSQL($sql, $params, !defined('DOKU_UNITTEST'));
750 $sql = trim($this->getConf($key));
753 if (!$sql) return false;
756 if (strpos($sql, ":$param") === false) return false;
766 * @param string $sql
771 protected function debugSQL($sql, $params, $htmlescape = true) argument
783 $sql = str_replace($key, $val, $sql);
785 if ($htmlescape) $sql = hsc($sql);
786 return $sql;