本文整理匯總了PHP中CQuery::query方法的典型用法代碼示例。如果您正苦於以下問題：PHP CQuery::query方法的具體用法？PHP CQuery::query怎麽用？PHP CQuery::query使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類CQuery的用法示例。
在下文中一共展示了CQuery::query方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getFields
/**
* @return CArrayList
*/
public function getFields()
{
if (is_null(self::$_fields)) {
self::$_fields = new CArrayList();
}
if (!self::$_fields->hasElement($this->name)) {
$fields = new CArrayList();
$query = new CQuery();
$query->query("DESCRIBE " . $this->name);
foreach ($query->execute()->getItems() as $field) {
$fields->add($field["Field"], new CDbTableField($field));
}
self::$_fields->add($this->name, $fields);
}
return self::$_fields->getItem($this->name);
}示例2: showVisitorsList
function showVisitorsList()
{
$cq = new CQuery();
$sql_result = $cq->query("SELECT * FROM `" . $this->sqlSettings['tableVisitorsList'] . "`");
echo <<<HTML
\t\t\t\t<table>
\t\t\t\t\t<tr>
\t\t\t\t\t\t<td class="header">Id</td>
\t\t\t\t\t\t<td class="header">Ip Address</td>
\t\t\t\t\t\t<td class="header">Country</td>
\t\t\t\t\t\t<td class="header">Exploited</td>
\t\t\t\t\t</tr>
HTML;
while ($row = $cq->fetchassoc($sql_result)) {
$sql_result2 = $cq->query("SELECT * FROM `" . $this->sqlSettings['dbVisitorsExploits'] . "` WHERE visitor_id ='" . mysql_real_escape_string($row['id']) . "'");
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['ipAddress'] . "</td>";
echo "<td>";
echo $row['country'] . "</td>";
echo "<td>";
if ($row['exploited']) {
echo "YES";
} else {
echo "NO";
}
echo "</td>";
echo "</tr>";
}
echo "</table>";
}示例3: commit
/**
* Фиксация транзакции
*/
public function commit()
{
$query = new CQuery();
$query->query("COMMIT;")->execute();
}