public function html($val)
{
return Sitengine_String::html($val);
}
public static function getHidden($name, $value)
{
$value = is_object($value) ? '' : (string) $value;
$t = '<input';
$t .= ' name="' . (string) $name . '"';
$t .= ' value="' . Sitengine_String::html($value) . '"';
$t .= ' type="hidden"';
$t .= ' />';
$t .= "\n";
return $t;
}
public static function printQuery(Zend_Db_Adapter_Abstract $database, $query)
{
try {
$s = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';
$s .= '<html>';
$s .= '<head>';
$s .= '<meta http-equiv="content-type" content="text/html; charset=utf-8" />';
$s .= '</head>';
$s .= '<body>';
$statement = $database->prepare($query);
$statement->execute();
$result = $statement->fetchAll(Zend_Db::FETCH_ASSOC);
$s .= "<table width=600 border=1>";
$s .= "<tr><th colspan=\"2\" align=\"left\" bgcolor=\"#eeeeee\"><h2>Database - Select Query</h2></td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Database Class</nobr></nobr></td><td>" . get_class($database) . " </td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Statement Class</nobr></td><td>" . get_class($statement) . " </td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Rows</nobr></td><td>" . sizeof($result) . " </td></tr>";
#$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Columns</nobr></td><td>".$numCols." </td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Query</nobr></td><td>" . Sitengine_String::html($query) . " </td></tr>";
$s .= "</table><br />";
$count = 0;
if (sizeof($result) > 0) {
$s .= "<table border=1>";
foreach ($result as $row) {
if ($count == 0) {
# column index
$colCount = 0;
$s .= "<tr>";
foreach ($row as $k => $v) {
$s .= '<th align="left" bgcolor="#eeeeee">' . $colCount++ . '</th>';
}
$s .= "</tr>";
# column names
$s .= "<tr>";
foreach ($row as $k => $v) {
$s .= '<th align="left" bgcolor="#eeeeee">' . Sitengine_String::html($k) . '</th>';
}
$s .= "</tr>";
}
$s .= "<tr>";
foreach ($row as $k => $v) {
$v = mb_substr($v, 0, 100);
$s .= '<td>' . Sitengine_String::html($v) . ' </td>';
}
$s .= "</tr>";
$count++;
}
$s .= "</table><br />";
}
# EXPLAIN
$statement = $database->prepare('EXPLAIN ' . $query);
$statement->execute();
$result = $statement->fetchAll(Zend_Db::FETCH_ASSOC);
$count = 0;
if (sizeof($result) > 0) {
$s .= "<table border=1>";
foreach ($result as $row) {
if ($count == 0) {
# column names
$s .= "<tr>";
foreach ($row as $k => $v) {
$s .= '<th align="left" bgcolor="#eeeeee">' . Sitengine_String::html($k) . '</th>';
}
$s .= "</tr>";
}
$s .= "<tr>";
foreach ($row as $k => $v) {
$v = mb_substr($v, 0, 100);
$s .= '<td>' . Sitengine_String::html($v) . ' </td>';
}
$s .= "</tr>";
$count++;
}
$s .= "</table><br />";
}
$s .= '</body>';
$s .= '</html>';
print $s;
} catch (Exception $exception) {
$s = "<table width=600 border=1>";
$s .= "<tr><th colspan=\"2\" align=\"left\" bgcolor=\"#eeeeee\"><h2>Database - Select Query</h2></td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Database Class</nobr></td><td>" . get_class($database) . " </td></tr>";
#$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Statement Class</nobr></td><td>".get_class($result)." </td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Code</nobr></td><td>" . $exception->getCode() . " </td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Error</nobr></td><td>" . $exception->getMessage() . " </td></tr>";
#$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Native Code</nobr></td><td>".$this->getNativeErrorCode()." </td></tr>";
#$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Native Error</nobr></td><td>".Sitengine_String::html($this->getNativeError())." </td></tr>";
$s .= "<tr><th valign=\"top\" align=\"left\" bgcolor=\"#eeeeee\"><nobr>Query</nobr></td><td>" . Sitengine_String::html($query) . " </td></tr>";
$s .= "</table><br />";
print $s;
}
}
public function html($val)
{
require_once 'Sitengine/String.php';
return Sitengine_String::html($val);
}
