Home
last modified time | relevance | path

Searched refs:sql (Results 76 – 100 of 186) sorted by relevance

12345678

/plugin/struct/meta/
H A DAccessTableGlobal.php27 $sql = 'DELETE FROM data_' . $this->schema->getTable() . ' WHERE rid = ?';
28 $this->sqlite->query($sql, $this->rid);
29 $sql = 'DELETE FROM multi_' . $this->schema->getTable() . ' WHERE rid = ?';
30 $this->sqlite->query($sql, $this->rid);
H A DAccessTablePage.php58 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1";
59 $ret = $this->sqlite->queryValue($sql, $opts);
/plugin/dataloop/syntax/
H A Droll.php199 $sql = $this->_buildSQL($data); // handles GET params, too
210 $res = sqlite_query($this->dthlp->db,$sql);
372 $sql = "SELECT ".join(', ',$select)."
380 $sql .= ' LIMIT '.($data['limit'] + 1);
383 $sql .= ' OFFSET '.((int) $_GET['dataofs']);
388 return $sql;
H A Dtextloop.php235 $sql = $this->_buildSQL($data); // handles GET params, too
245 $res = sqlite_query($this->dthlp->db,$sql);
412 $sql = "SELECT ".join(', ',$select)."
420 $sql .= ' LIMIT '.($data['limit'] + 1);
423 $sql .= ' OFFSET '.((int) $_GET['dataofs']);
428 return $sql;
H A Dloop.php281 $sql = $this->_buildSQL($data); // handles GET params, too
292 $res = sqlite_query($this->dthlp->db,$sql);
488 $sql = "SELECT ".join(', ',$select)."
496 $sql .= ' LIMIT '.($data['limit'] + 1);
499 $sql .= ' OFFSET '.((int) $_GET['dataofs']);
504 return $sql;
/plugin/highlightjs/highlight/styles/
H A Dfar.css37 .sql .aggregate,
53 .sql .aggregate,
104 .sql .aggregate,
/plugin/codebutton_ext/
H A Daction.php146 'title' => $this->getLang('sql'),
147 'icon' => '../../plugins/codebutton_ext/pix/File-sql-32.png',
148 'open' => '<code sql downloadname.sql>\n',
H A Daction.php.bak45 …rebol, reg, robots, ruby, sas, scala, scheme, scilab, sdlbasic, smalltalk, smarty, sql, tcl, terat…
137 'title' => $this->getLang('sql'),
138 'icon' => '../../plugins/codebutton_ext/pix/File-sql-32.png',
139 'open' => '<code sql downloadname.sql>\n',
/plugin/dbquery/_test/
H A DHelperTest.php76 $sql = 'SELECT :user, :mail, :id, :page, :ns WHERE \'foo\' in (:groups)';
77 $sth = $this->hlp->prepareStatement($pdo, $sql, $parameters);
/plugin/fedauth/Auth/OpenID/
H A DMDB2Store.php320 $sql = "";
330 $sql = sprintf("SELECT handle, secret, issued, lifetime, assoc_type " .
335 $sql = sprintf("SELECT handle, secret, issued, lifetime, assoc_type " .
341 $assoc = $this->connection->getRow($sql, $types, $params);
/plugin/openid/Auth/OpenID/
H A DMDB2Store.php320 $sql = "";
330 $sql = sprintf("SELECT handle, secret, issued, lifetime, assoc_type " .
335 $sql = sprintf("SELECT handle, secret, issued, lifetime, assoc_type " .
341 $assoc = $this->connection->getRow($sql, $types, $params);
/plugin/sqlcomp/
H A Dsyntax.php231 $sql = $data[1];
254 … case "mysql": $rs = $this->_mysql($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); break;
255 … case "mssql": $rs = $this->_mssql($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); break;
256 …case "oracle": $rs = $this->_oracle($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); brea…
257 …case "sqlite": $rs = $this->_sqlite($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); brea…
258 …qlaccess": $rs = $this->_sqlaccess($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); break;
259 …tgresql": $rs = $this->_postgresql($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); break;
260 …case "sqlcsv": $rs = $this->_sqlcsv($dbcon[1], $dbcon[2], $dbcon[3], $dbcon[4], $sql, $opts); brea…
/plugin/sql/
H A DDB.php22 function query($sql, $mode = null, ...$params) { argument
25 if ($ALOCAL['debug']) error_log($sql, 3, '/tmp/php.log');
26 $stmt = parent::prepare($sql);
/plugin/authowncloud/
H A Dauth.php217 …$sql = "SELECT DISTINCT *PREFIX*users.uid AS user, *PREFIX*users.displayname AS name $selectMail $…
218 $sql .= $joins.' '.$wheres;
219 if($limit > 0) $sql .= ' LIMIT '.$start.','.$limit.' ';
220 $db = OC_DB::prepare($sql);
/plugin/sqlite/_test/
H A DHelperTest.php47 $sql = "SELECT * FROM testdata WHERE keyword='music'";
48 $res = $SqliteHelper->query($sql);
61 $sql = "INSERT INTO testdata VALUES(20,'glass','Purple')";
62 $res = $SqliteHelper->query($sql);
/plugin/simplemysqlclient/syntax/
H A Dsimplemysqlclient.php572 $sql = $this->getLang ( 'template.' . $i . '.sql' );
573 …$ret = $ret . '<button style="margin:4px" onclick="return simplemysqlclient_load(\'' . $sql . '\')…
592 $sql = $this->getLang ( 'shortcut.' . $i . '.sql' );
593 $sql = str_replace ( '#DATABASENAME#', $this->getConf ( 'dbName' ), $sql );
594 …$ret = $ret . '<button style="margin:4px" onclick="return simplemysqlclient_load(\'' . $sql . '\')…
/plugin/authjoomla/
H A Dauth.php51 $sql = $this->getConf('select-session');
52 $result = $this->_query($sql, ['session' => $session]);
/plugin/datatemplate/syntax/
H A Dlist.php97 $sql = parent::_buildSQL($data);
104 return $sql;
114 $sql = $this->_buildSQL($data);
123 $this->dtc->checkAndBuildCache($data, $sql, $this);
132 $datarows = $this->dtc->getData($sql);
/plugin/structpublish/meta/
H A DAccessTableStructpublish.php73 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1";
74 $ret = $this->sqlite->queryValue($sql, $opts);
/plugin/tagging/helper/
H A Dquerybuilder.php171 $sql = "SELECT $this->field AS item, COUNT(*) AS cnt
180 $sql .= ' LIMIT ?';
184 return $sql;
/plugin/authucenter/lib/uc_client/model/
H A Dmail.php55 …$sql = "INSERT INTO ".UC_DBTABLEPRE."mailqueue (touid, tomail, subject, message, frommail, charset…
65 $sql .= implode(',', $values_arr);
66 $this->db->query($sql);
/plugin/sphinxsearch-was/
H A DPageMapper.php62 …$sql = sprintf("select * from {$this->_table} where page_crc in (%s)", implode(",", $pageCrcList));
63 $result = $this->_db->query($sql);
/plugin/sphinxsearch/
H A DPageMapper.php63 …$sql = sprintf("select * from {$this->_table} where page_crc in (%s)", implode(",", $pageCrcList));
64 $result = $this->_db->query($sql);
/plugin/authwordpress/
H A Dauth.php214 $sql = $this->sql_wp_user_data
217 $stmt = $this->db->prepare($sql);
219 $this->logDebug("Retrieving data for user '$user'\n$sql");
/plugin/authgoogle/google/contrib/
H A DGoogle_FusiontablesService.php150 * @param string $sql An SQL SELECT/SHOW/DESCRIBE/INSERT/UPDATE/DELETE/CREATE statement.
157 public function sql($sql, $optParams = array()) { argument
158 $params = array('sql' => $sql);
170 * @param string $sql An SQL SELECT/SHOW/DESCRIBE statement.
177 public function sqlGet($sql, $optParams = array()) { argument
178 $params = array('sql' => $sql);
1217 public $sql; variable in Google_Table
1269 public function setSql( $sql) { argument
1270 $this->sql = $sql;
1273 return $this->sql;

12345678