本文整理汇总了PHP中Datasource::query方法的典型用法代码示例。如果您正苦于以下问题:PHP Datasource::query方法的具体用法?PHP Datasource::query怎么用?PHP Datasource::query使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Datasource
的用法示例。
在下文中一共展示了Datasource::query方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: _getTables
/**
* _getTables
* @return array
*/
protected function _getTables()
{
$this->tables = array();
$tables = Set::extract('/TABLE_NAMES/.', $this->_db->query('SHOW TABLES'));
foreach ($tables as $table) {
$this->tables = array_merge($this->tables, array_values($table));
}
return $this->tables;
}
示例2: _loadOptions
/**
* Loads the options from the DB
*/
public function _loadOptions()
{
$this->_realmOptions = array();
$rows = Datasource::query("select * from " . $this->_optionRealm . "_options where id=" . $this->_internalID);
// First build up from defaults
foreach (array_keys($this->_realmConfig) as $optionKey) {
$this->_realmOptions[$optionKey] = $this->_realmConfig[$optionKey]["default"];
}
foreach ($rows as $row) {
$this->_realmOptions[$row["optionname"]] = $this->_getOptionValue($row["optionvalue"], $this->realmConfig[$row["optionname"]]["type"]);
}
}
示例3: cacheTable
private function cacheTable($tbName)
{
ob_start();
echo "<?class ModelCache_" . $tbName . " extends ModelCache {\n";
echo "public function ModelCache_{$tbName}() {\n";
echo "\t\$this->modelSource = '{$tbName}';\n";
$rs = Datasource::query("describe " . Datasource::escape($tbName));
foreach ($rs as $row) {
echo "\$this->modelStructure['" . $row["Field"] . "'] = array();\n";
echo "\$this->modelStructure['" . $row["Field"] . "']['is_id'] = " . ($row["Key"] == 'PRI' ? "true" : "false") . ";\n";
echo "\$this->modelStructure['" . $row["Field"] . "']['type'] = '" . $this->parseType($row["Type"]) . "';\n";
echo "\$this->modelStructure['" . $row["Field"] . "']['null'] = " . ($row["Null"] == 'NO' ? "false" : "true") . ";\n";
echo "\$this->modelStructure['" . $row["Field"] . "']['maxlength'] = " . $this->parseLength($row["Type"]) . ";\n";
echo "\$this->modelStructure['" . $row["Field"] . "']['default'] = " . $this->getDefault($row) . ";\n";
}
echo "}\n";
echo "\n}?>\n";
$cacheContents = ob_get_contents();
ob_end_clean();
$cachePointer = fopen(WEBAPP_ROOT . "/tmp/modelcache/" . md5($tbName) . ".php", "w");
fwrite($cachePointer, $cacheContents);
flush($cachePointer);
fclose($cachePointer);
}