/plugin/struct/meta/ |
H A D | AccessTableGlobal.php | 27 $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 D | AccessTablePage.php | 58 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1"; 59 $ret = $this->sqlite->queryValue($sql, $opts);
|
/plugin/dataloop/syntax/ |
H A D | roll.php | 199 $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 D | textloop.php | 235 $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 D | loop.php | 281 $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 D | far.css | 37 .sql .aggregate, 53 .sql .aggregate, 104 .sql .aggregate,
|
/plugin/codebutton_ext/ |
H A D | action.php | 146 'title' => $this->getLang('sql'), 147 'icon' => '../../plugins/codebutton_ext/pix/File-sql-32.png', 148 'open' => '<code sql downloadname.sql>\n',
|
H A D | action.php.bak | 45 …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 D | HelperTest.php | 76 $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 D | MDB2Store.php | 320 $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 D | MDB2Store.php | 320 $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 D | syntax.php | 231 $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 D | DB.php | 22 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 D | auth.php | 217 …$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 D | HelperTest.php | 47 $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 D | simplemysqlclient.php | 572 $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 D | auth.php | 51 $sql = $this->getConf('select-session'); 52 $result = $this->_query($sql, ['session' => $session]);
|
/plugin/datatemplate/syntax/ |
H A D | list.php | 97 $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 D | AccessTableStructpublish.php | 73 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1"; 74 $ret = $this->sqlite->queryValue($sql, $opts);
|
/plugin/tagging/helper/ |
H A D | querybuilder.php | 171 $sql = "SELECT $this->field AS item, COUNT(*) AS cnt 180 $sql .= ' LIMIT ?'; 184 return $sql;
|
/plugin/authucenter/lib/uc_client/model/ |
H A D | mail.php | 55 …$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 D | PageMapper.php | 62 …$sql = sprintf("select * from {$this->_table} where page_crc in (%s)", implode(",", $pageCrcList)); 63 $result = $this->_db->query($sql);
|
/plugin/sphinxsearch/ |
H A D | PageMapper.php | 63 …$sql = sprintf("select * from {$this->_table} where page_crc in (%s)", implode(",", $pageCrcList)); 64 $result = $this->_db->query($sql);
|
/plugin/authwordpress/ |
H A D | auth.php | 214 $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 D | Google_FusiontablesService.php | 150 * @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;
|