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); }