Lines Matching refs:sql

30         $sql = 'REPLACE INTO opts VALUES (?, ?)';
31 $db->query($sql, [$key, $value]);
99 $sql = 'SELECT val FROM opts WHERE opt = ?';
100 $res = $db->query($sql, [$key]);
143 $sql = "REPLACE INTO $table ($keys) VALUES ($wlds)";
144 $ok = $db->query($sql, $vals);
166 $sql = "SELECT secret FROM webhooks WHERE service = ? AND repository_id = ?";
167 $secrets = $this->sqlArrayQuery($sql, [$service, $repo]);
174 * @param string $sql the query
179 private function sqlArrayQuery($sql, $conditional) argument
181 if (substr(trim($sql), 0, strlen('SELECT')) !== 'SELECT') {
182 … throw new InvalidArgumentException("SQL-Statement must be a SELECT statement! \n" . $sql);
184 if (strpos(trim($sql, ';'), ';') !== false) {
185 … throw new InvalidArgumentException("SQL-Statement must be one single statement! \n" . $sql);
192 $res = $db->query($sql, $conditional);
229 $sql = "DELETE FROM $table WHERE $where";
230 $db->query($sql, $vals);
235 $sql = 'SELECT * FROM webhooks WHERE service = ?';
238 $sql .= ' AND repository_id = ?';
242 $sql .= ' AND id = ?';
246 $webhooks = $this->sqlArrayQuery($sql, $params);
290 …$sql = 'SELECT * FROM issues WHERE service = ? AND project = ? AND id = ? AND is_mergerequest = ?';
291 …$issues = $this->sqlArrayQuery($sql, [$serviceName, $projectKey, $issueId, $isMergeRequest ? 1 : 0…
319 $sql = '
328 … return $this->sqlArrayQuery($sql, [$serviceName, $project, $issueId, $isMergeRequest ? 1 : 0]);
342 $sql = "SELECT page, rev
350 …return $this->sqlArrayQuery($sql, [$serviceName, $projectKey, $issue_id, $isMergeRequest ? 1 : 0]);