Home
last modified time | relevance | path

Searched refs:sql (Results 26 – 50 of 186) sorted by relevance

12345678

/plugin/authucenter/lib/uc_client/lib/
H A Ddb.class.php66 function result_first($sql) { argument
67 $query = $this->query($sql);
71 function fetch_first($sql) { argument
72 $query = $this->query($sql);
76 function fetch_all($sql, $id = '') { argument
78 $query = $this->query($sql);
92 $this->halt('MySQL Query Error', $sql);
95 $this->histories[] = $sql;
154 function halt($message = '', $sql = '') { argument
159 $this->query($sql);
[all …]
H A Ddbi.class.php55 function result_first($sql) { argument
56 $query = $this->query($sql);
60 function fetch_first($sql) { argument
61 $query = $this->query($sql);
65 function fetch_all($sql, $id = '') { argument
67 $query = $this->query($sql);
81 $this->halt('MySQL Query Error', $sql);
84 $this->histories[] = $sql;
147 function halt($message = '', $sql = '') { argument
152 $this->query($sql);
[all …]
/plugin/jplayer/vendor/james-heinrich/getid3/getid3/
H A Dextension.cache.sqlite3.php137 $stmt = $db->prepare($sql);
162 $sql = $this->getQuery('delete_cache');
163 $db->exec($sql);
164 $sql = $this->getQuery('set_version');
165 $stmt = $db->prepare($sql);
195 $stmt = $db->prepare($sql);
207 $sql = $this->getQuery('cache_file');
208 $stmt = $db->prepare($sql);
227 $sql = $this->getQuery('make_table');
228 return $db->exec($sql);
[all …]
/plugin/statistics/inc/
H A DStatisticsLogger.class.php71 $sql = "REPLACE INTO " . $this->hlp->prefix . "lastseen
74 $this->hlp->runSQL($sql);
100 $sql = "INSERT DELAYED INTO " . $this->hlp->prefix . "groups
104 $sql .= "( NOW(), '$type', '$group' ),";
106 $sql = rtrim($sql, ',');
108 $ok = $this->hlp->runSQL($sql);
189 $sql = "INSERT INTO " . $this->hlp->prefix . "search
194 $id = $this->hlp->runSQL($sql);
200 $sql
[all...]
/plugin/sqlite/
H A DQuerySaver.php37 $sql = 'INSERT INTO queries (db, name, sql) VALUES (?, ?, ?)';
38 $this->db->exec($sql, [$this->upstream, $name, $query]);
51 $sql = 'SELECT sql FROM queries WHERE db = ? AND name = ?';
52 return $this->db->queryValue($sql, [$this->upstream, $name]);
69 $sql = 'DELETE FROM queries WHERE db = ? AND name = ?';
70 $this->db->exec($sql, [$this->upstream, $name]);
82 $sql = 'SELECT name, sql FRO
[all...]
H A DTools.php8 * Split sql queries on semicolons, unless when semicolons are quoted
13 * @param string $sql
14 * @return string[] sql queries
16 public static function SQLstring2array($sql) argument
19 $len = strlen($sql);
21 // Simple state machine to "parse" sql into single statements
26 $prev = $i ? $sql[$i - 1] : "\n";
27 $char = $sql[$i];
28 $next = $i < ($len - 1) ? $sql[$i + 1] : '';
/plugin/struct/action/
H A Dmove.php103 $sql = "UPDATE data_$tbl SET pid = ? WHERE pid = ?";
104 $this->db->query($sql, [$new, $old]);
107 $sql = "UPDATE multi_$tbl SET pid = ? WHERE pid = ?";
108 $this->db->query($sql, [$new, $old]);
121 $sql = "UPDATE schema_assignments SET pid = ? WHERE pid = ?";
122 $this->db->query($sql, [$new, $old]);
136 $sql = "UPDATE titles SET pid = ? WHERE pid = ?";
137 $this->db->query($sql, [$new, $old]);
156 $sql = "UPDATE multi_$table
163 $sql
[all...]
/plugin/blogtng/helper/
H A Dcomments.php72 $sql = 'SELECT COUNT(pid) as val
76 $sql .= ' AND status = \'visible\'';
160 $sql = "SELECT cid
167 $sql,
206 $sql = "DELETE FROM comments WHERE pid = ?";
237 $sql = "SELECT title, page, mail
278 $sql = "SELECT A.mail as mail, B.key as key
347 $sql = "INSERT OR REPLACE INTO optin
351 $sql = "INSERT OR IGNORE INTO optin
592 $sql = 'SELECT *
[all …]
/plugin/top/
H A Dhelper.php67 $sql = "INSERT OR REPLACE INTO toppages (page, value, lang, month)
69 $res = $sqlite->query($sql, $page, $page, $month, $lang, $month);
86 $sql = $sqlbegin . $sqlend;
87 $res = $sqlite->query($sql, $num);
89 $sql = $sqlbegin . "WHERE lang = ? " . $sqlend;
90 $res = $sqlite->query($sql, $lang, $num);
92 $sql = $sqlbegin . "WHERE month >= ? " . $sqlend;
93 $res = $sqlite->query($sql, intval($month), $num);
95 $sql = $sqlbegin . "WHERE lang = ? AND month >= ? " . $sqlend;
96 $res = $sqlite->query($sql, $lang, intval($month), $num);
/plugin/openid/Auth/OpenID/
H A DSQLStore.php72 protected $sql = []; variable in Auth_OpenID_SQLStore
139 $this->sql = [];
239 if (!array_key_exists($key, $this->sql)) {
241 } else if (!$this->sql[$key]) {
281 if (is_array($this->sql[$k])) {
286 $this->sql[$k] = sprintf($this->sql[$k], $value);
347 return $this->connection->query($this->sql['set_assoc'],
416 $this->sql['remove_assoc'],
489 $sql = $this->sql['add_nonce'];
490 $result = $this->connection->query($sql, [
[all …]
/plugin/fedauth/Auth/OpenID/
H A DSQLStore.php126 $this->sql = array();
226 if (!array_key_exists($key, $this->sql)) {
228 } else if (!$this->sql[$key]) {
264 if (is_array($this->sql[$k])) {
270 $this->sql[$k] = sprintf($this->sql[$k], $value);
324 return $this->connection->query($this->sql['set_assoc'],
356 $result = $this->connection->getRow($this->sql['get_assoc'],
387 $this->sql['remove_assoc'],
456 $sql = $this->sql['add_nonce'];
457 $result = $this->connection->query($sql, array($server_url,
[all …]
/plugin/addressbook/
H A Dsyntax.php379 $query = $sqlite->query($sql);
482 $sql .= ')';
486 $res = $sqlite->query($sql);
525 $sqlite->query($sql);
593 $sql .= " ORDER BY $order";
595 $query = $sqlite->query($sql);
628 $query = $sqlite->query($sql);
673 $query = $sqlite->query($sql);
941 $query = $sqlite->query($sql);
946 $sql = "INSERT INTO addresslist
[all …]
/plugin/authdrupal7/
H A Dauth.php85 $sql = str_replace('%{drupal_prefix}', $this->getConf('drupalPrefix'), $sql);
86 $result = $this->_queryDB($sql);
187 $sql = str_replace('%{drupal_prefix}', $this->getConf('drupalPrefix'), $sql);
188 $result = $this->_queryDB($sql);
213 $sql = str_replace('%{drupal_prefix}', $this->getConf('drupalPrefix'), $sql);
214 $result = $this->_queryDB($sql);
238 $result = $this->_queryDB($sql);
465 $sql = "LOCK TABLES ";
468 if($cnt++ != 0) $sql .= ", ";
469 $sql .= "$table $mode";
[all …]
/plugin/authdrupal8/
H A Dauth.php80 $sql = str_replace('%{user}', $this->_escape($user), $this->checkPass);
81 $sql = str_replace('%{drupalPrefix}', $this->getConf('prefix'), $sql);
82 $result = $this->_queryDB($sql);
181 $sql = str_replace('%{user}', $this->_escape($user), $this->getUserInfo);
182 $sql = str_replace('%{drupalPrefix}', $this->getConf('prefix'), $sql);
183 $result = $this->_queryDB($sql);
207 $sql = str_replace('%{user}', $this->_escape($user), $this->getGroups);
208 $sql
[all...]
/plugin/top/_test/
H A Ddate.test.php19 $sql = "INSERT INTO toppages (page, value, lang, month) VALUES
21 $sqlite->query($sql,'wiki:start',3,'','201407');
22 $sqlite->query($sql,'wiki:start',2,'','201401');
23 $sqlite->query($sql,'wiki:start',6,'','201201');
24 $sqlite->query($sql,'wiki:start',1,'',null);
25 $sqlite->query($sql,'en:wiki:start',8,'en','201201');
26 $sqlite->query($sql,'en:wiki:start',1,'en','201303');
27 $sqlite->query($sql,'de:wiki:start',6,'de','201201');
/plugin/authgooglesheets/vendor/google/apiclient-services/src/CloudDataplex/
H A DGoogleCloudDataplexV1EnvironmentEndpoints.php29 public $sql; variable in Google\\Service\\CloudDataplex\\GoogleCloudDataplexV1EnvironmentEndpoints
48 public function setSql($sql) argument
50 $this->sql = $sql;
57 return $this->sql;
/plugin/datatemplate/syntax/inc/
H A Dcache.php34 * @param string $sql stripped SQL for hash generation
37 public function checkAndBuildCache($data, $sql, &$dtlist) { argument
59 $cachefile = getCacheName($sql, '.datatemplate');
74 $res = $sqlite->query($sql);
99 $cache = $this->getData($sql);
117 * @param string $sql the stripped sql for the data request
120 public function getData($sql) { argument
121 $cachefile = getCacheName($sql, '.datatemplate');
/plugin/struct/meta/
H A DQueryBuilderWhere.php120 $sql = ' ';
121 if (!$first) $sql .= $this->type . ' ';
125 $sql .= '(';
127 $sql .= $where->toSQL($first);
130 $sql .= ' )';
132 $sql .= $this->statement;
135 return $sql;
H A DQueryBuilder.php207 * @return array ($sql, $vals)
229 $sql =
235 $sql .=
240 $sql .=
244 return [$sql, array_values($this->values)];
255 fixPlaceholders($sql) global() argument
/plugin/authgooglesheets/vendor/google/apiclient-services/src/Spanner/
H A DStatement.php31 public $sql; variable in Google\\Service\\Spanner\\Statement
64 public function setSql($sql) argument
66 $this->sql = $sql;
73 return $this->sql;
H A DPartitionQueryRequest.php33 public $sql; variable in Google\\Service\\Spanner\\PartitionQueryRequest
82 public function setSql($sql) argument
84 $this->sql = $sql;
91 return $this->sql;
/plugin/struct/helper/
H A Dimexport.php43 $sql = [];
44 $sql[] = "DELETE FROM schema_assignments_patterns WHERE tbl = '$schemaName'";
45 $sql[] = "DELETE FROM schema_assignments WHERE tbl = '$schemaName'";
48 $sql[] = "INSERT INTO schema_assignments_patterns (pattern, tbl) VALUES ('$pattern','$schemaName')";
51 $this->sqlite->doTransaction($sql);
69 $sql = 'SELECT pattern FROM schema_assignments_patterns WHERE tbl = ?';
70 $patterns = $this->sqlite->queryAll($sql, $schemaName);
/plugin/issuelinks/_test/
H A DhandleIssueLinkSyntax.test.php42 $sql = 'SELECT page, project_id, issue_id, type FROM pagerev_issues';
43 $pagerev_issues = $sqliteHelper->res2arr($sqliteHelper->query($sql, array()));
78 $sql = 'SELECT page, project_id, issue_id, type FROM pagerev_issues';
79 $pagerev_issues = $sqliteHelper->res2arr($sqliteHelper->query($sql, array()));
103 $sql = 'SELECT page, project_id, issue_id, type FROM pagerev_issues';
104 $pagerev_issues = $sqliteHelper->res2arr($sqliteHelper->query($sql, array()));
/plugin/bez/mdl/
H A DTaskFactory.php53 $sql = "SELECT task.id, task.type, task.content_html, task.state, task.cost, task.plan_date, task.close_date,
60 $stmt = $this->model->sqlite->query($sql, $thread->id);
82 $sql = "SELECT task_participant.user_id,
90 $r = $this->model->sqlite->query($sql, $from, $to);
92 $sql = "SELECT user_id,
99 $r = $this->model->sqlite->query($sql);
110 $sql = "SELECT task_program_name,
125 $r = $this->model->sqlite->query($sql, $from, $to);
127 $sql = "SELECT task_program_name,
141 $r = $this->model->sqlite->query($sql);
[all...]
/plugin/guestbook/
H A Dbasic.class.php75 $sql = "SHOW TABLES";
76 $result = mysql_query($sql);
137 $result = mysql_query($sql);
175 $sql = "SELECT * FROM wiki_guestbook WHERE ID=" . intval($admin) . "; ";
176 $data=mysql_fetch_array(mysql_query($sql));
254 $sql = "DELETE FROM wiki_guestbook WHERE ID=" . intval($_POST['guestDelete']) . ";";
255 mysql_query($sql);
267 mysql_query($sql);
279 mysql_query($sql);
314 mysql_query($sql);
[all …]

12345678