Home
last modified time | relevance | path

Searched refs:sql (Results 51 – 75 of 186) sorted by relevance

12345678

/plugin/magento/
H A Dauth.php390 foreach( $dbh->query( $sql ) as $row ) {
442 $sql = "select user_id entity,password hash from admin_user where user_id = {$entity};";
444 foreach( $dbh->query( $sql ) as $row ) {
509 foreach( $dbh->query( $sql ) as $row ) {
539 foreach( $dbh->query( $sql ) as $row ) {
571 foreach( $dbh->query( $sql ) as $row ) {
604 foreach( $dbh->query( $sql ) as $row ) {
641 foreach( $dbh->query( $sql ) as $row ) {
659 foreach( $dbh->query( $sql ) as $row ) {
691 … $sql = "select role_id id,role_name name from admin_role where role_type = 'G' order by role_id;";
[all …]
/plugin/git/
H A Dhelper.php118 $this->sqlite->query($sql);
144 $this->sqlite->query($sql);
458 $sql = "SELECT timestamp FROM git WHERE repo = 'local'";
459 $res = $this->sqlite->query($sql);
477 $sql = "SELECT status FROM git WHERE repo = 'local'";
478 $res = $this->sqlite->query($sql);
494 $res = $this->sqlite->query($sql);
511 $sql = "SELECT status FROM git WHERE repo = 'upstream'";
512 $res = $this->sqlite->query($sql);
548 $this->sqlite->query($sql);
[all …]
/plugin/addressbook/
H A Daction.php72 …$sql = "select * from addresslist WHERE instr(lower(surname || firstname || tel1 || tel2 || fax ||…
73 …for ($c=1;$c<count($text);$c++) $sql .= " AND instr(lower(' ' || surname || firstname || tel1 || t…
74 $sql .= " ORDER BY $order LIMIT 20";
76 $query = $sqlite->query($sql);
79 if ($sqlite->res2count($sqlite->query($sql)) == 0) {
/plugin/authgooglesheets/vendor/google/apiclient-services/src/Spanner/
H A DExecuteSqlRequest.php51 public $sql; variable in Google\\Service\\Spanner\\ExecuteSqlRequest
170 public function setSql($sql) argument
172 $this->sql = $sql;
179 return $this->sql;
/plugin/combo/ComboStrap/
H A DPageSql.php19 const CANONICAL = "sql";
21 private $sql; variable in ComboStrap\\PageSql
30 $this->sql = $text;
35 * @param MarkupPath|null $contextualPage - the page where the sql applies to
51 $input = InputStream::fromString($this->sql);
63 $this->listener = new PageSqlTreeListener($lexer, $parser, $this->sql, $contextualPage);
85 return $this->sql;
/plugin/structstatus/
H A Daction.php63 $sql = "SELECT MAX(id) AS id, tbl FROM schemas GROUP BY tbl";
64 $schemas= $sqlite->queryAll($sql);
77 $sql = 'REPLACE INTO opts(opt,val) VALUES ("dbversion_structstatus", ' . $version . ')';
78 $sqlite->query($sql);
143 $sql = 'SELECT opt, val FROM opts WHERE opt=? OR opt=?';
144 $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structstatus']);
/plugin/data-au/
H A Dhelper.php509 $dataau['sql'] = str_replace('%user%', $_SERVER['REMOTE_USER'], $dataau['sql']);
510 …$dataau['sql'] = str_replace('%groups%', implode("','", (array) $USERINFO['grps']), $dataau['sql']…
512 $dataau['sql'] = str_replace('%now%', dformat(null, '%d-%m-%Y'), $dataau['sql']);
515 $dataau['sql'] = $this->makeTranslationReplacement($dataau['sql']);
/plugin/data/
H A Dhelper.php535 * Replace placeholders in sql
544 $data['sql'] = str_replace('%user%', $INPUT->server->str('REMOTE_USER'), $data['sql']);
545 $data['sql'] = str_replace('%groups%', implode("','", $USERINFO['grps'] ?? []), $data['sql']);
547 $data['sql'] = str_replace('%now%', dformat(null, '%Y-%m-%d'), $data['sql']);
550 $data['sql'] = $this->makeTranslationReplacement($data['sql']);
/plugin/dbquery/
H A Dhelper.php88 * @param string $sql
92 public function prepareStatement(\PDO $pdo, $sql, $parameters) argument
103 $sql = str_replace(':groups', join(',', $groupids), $sql);
105 $sth = $pdo->prepare($sql);
109 if (strpos($sql, $key) === false) continue; // skip if parameter is missing
/plugin/strata/driver/
H A Ddriver.php137 * This implementation looks for a file called 'setup-@driver@.sql' and executes all SQL statements in that file.
150 $sqlfile = DOKU_PLUGIN . "strata/sql/setup-$driver.sql";
152 $sql = io_readFile($sqlfile, false);
153 $lines = explode("\n",$sql);
157 $sql = '';
161 $sql .= $line;
165 $sql = explode(';', $sql);
170 foreach($sql a
[all...]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAV/PropertyStorage/Backend/
H A DPDOMysqlTest.php18 foreach($setupSql as $sql) {
20 if (!trim($sql)) continue;
21 $pdo->exec($sql);
H A DPDOSqliteTest.php18 foreach($setupSql as $sql) {
20 if (!trim($sql)) continue;
21 $pdo->exec($sql);
/plugin/sql/
H A Dplugin.info.txt1 base sql
5 name sql plugin
7 url http://dokuwiki.org/plugin:sql
/plugin/struct/meta/
H A DSearchCloud.php19 * @return array ($sql, $opts) The SQL and parameters to execute
84 [$sql, $opts] = $QB->getSQL();
85 return [$sql . $this->limit, $opts];
107 [$sql, $opts] = $this->getSQL();
110 $res = $this->sqlite->query($sql, $opts);
111 if ($res === false) throw new StructException("SQL execution failed for\n\n$sql");
H A DPageMeta.php41 $sql = "SELECT pid, title, lasteditor, lastrev, lastsummary FROM titles WHERE pid = ?";
42 $data = $this->sqlite->queryRecord($sql, [$this->pid]);
51 $sql = "REPLACE INTO titles (pid, title, lasteditor, lastrev, lastsummary) VALUES (?,?,?,?,?)";
52 $this->sqlite->query($sql, [$this->pid, $this->title, $this->lasteditor, $this->lastrev, $this->lastsummary]);
H A DSchemaBuilder.php157 $sql = "INSERT INTO schemas (tbl, ts, user, config) VALUES (?, ?, ?, ?)";
158 $this->sqlite->query($sql, [$this->table, $this->time, $this->user, $config]);
318 $sql = "CREATE TABLE $tbl (
326 $ok = $ok && (bool)$this->sqlite->query($sql);
329 $sql = "CREATE TABLE $tbl (
340 $ok = $ok && (bool)$this->sqlite->query($sql);
354 $sql = " ALTER TABLE $tbl ADD COLUMN col$index DEFAULT ''";
355 if (!$this->sqlite->query($sql)) {
/plugin/sqlite/
H A Dadmin.php56 $exportfile = $conf['tmpdir'] . '/' . $this->db->getDbName() . '.sql';
58 header('Content-Type: text/sql');
59 header('Content-Disposition: attachment; filename="' . $this->db->getDbName() . '.sql";');
71 $sql = Tools::SQLstring2array(file_get_contents($importfile));
74 foreach ($sql as $s) {
85 $this->querySaver->saveQuery($INPUT->str('name'), $INPUT->str('sql'));
122 $form->addTextarea('sql')->addClass('edit');
130 if ($INPUT->has('sql')) $this->showQueryResults($INPUT->str('sql'));
171 * @param string $sql
163 showQueryResults($sql) global() argument
[all...]
/plugin/structpublish/helper/
H A Ddb.php50 $sql = 'SELECT pid FROM titles';
51 $list = $sqlite->queryAll($sql);
73 $sql = 'SELECT pid FROM structpublish_assignments WHERE pid = ? AND assigned = 1';
74 return (bool) $sqlite->queryAll($sql, $pid);
/plugin/fksnewsfeed/inc/ORM/
H A DAbstractService.php35 …$sql = 'INSERT INTO ' . $this->table . ' (' . join(',', array_keys($data)) . ') VALUES( ' . join(…
37 return (bool)$this->sqlite->query($sql,
43 $sql = 'UPDATE ' . $this->table . ' SET ' . join(',', array_map(function ($key) {
46 $this->sqlite->query($sql,
/plugin/data-au/syntax/
H A Drelated.php83 $sql = "SELECT A.value
88 $res = $sqlite->query($sql, $col, $id);
154 $sql = "SELECT pages.pid, pages.page as page, pages.title as title, COUNT(*) as rel
164 $sql .= ' LIMIT ' . ($dataau['limit']);
167 return $sql;
H A Dcloud.php108 $sql = "SELECT dataau.value AS value, COUNT(dataau.pid) AS cnt
114 $sql .= ' HAVING cnt >= ' . $dataau['min'];
116 $sql .= ' ORDER BY cnt DESC';
118 $sql .= ' LIMIT ' . $dataau['limit'];
121 return $sql;
/plugin/data/syntax/
H A Drelated.php44 if (!$data['sql']) return true; // sql build
47 $rows = $sqlite->queryAll($data['sql']);
87 $sql = "SELECT A.value
92 $rows = $sqlite->queryAll($sql, $col, $id);
163 $sql = "SELECT pages.pid, pages.page as page, pages.title as title, COUNT(*) as rel
173 $sql .= ' LIMIT ' . ($data['limit']);
176 return $sql;
H A Dcloud.php117 $sql = "SELECT data.value AS value, COUNT(data.pid) AS cnt
123 $sql .= ' HAVING cnt >= ' . $data['min'];
125 $sql .= ' ORDER BY cnt DESC';
127 $sql .= ' LIMIT ' . $data['limit'];
130 return $sql;
168 $rows = $sqlite->queryAll($data['sql']);
/plugin/bez/action/
H A Dmigration.php49 $sql = file_get_contents($file);
50 if($sql === false) {
55 preg_match_all('/.*?(?(?=BEGIN)BEGIN.*?END)\s*;/is', $sql, $matches);
82 $sql = file_get_contents($file);
83 if($sql === false) {
88 preg_match_all('/.*?(?(?=BEGIN)BEGIN.*?END)\s*;/is', $sql, $matches);
123 $sql = file_get_contents($file);
124 if ($sql === false) {
129 preg_match_all('/.*?(?(?=BEGIN)BEGIN.*?END)\s*;/is', $sql, $matches);
/plugin/bez/mdl/
H A DThread_commentFactory.php117 $sql = "SELECT type, COUNT(type) AS 'cnt'
122 $r = $this->model->sqlite->query($sql, $from, $to);
124 $sql = "SELECT type, COUNT(type) AS 'cnt'
128 $r = $this->model->sqlite->query($sql);

12345678