Viewing file:  ajaxfulltext.php (1.17 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/*
SQL Buddy - Web based MySQL administration
http://www.sqlbuddy.com/
ajaxfulltext.php
- fetches full text for browse tab
MIT license
2008 Calvin Lough <http://calv.in>
*/
include "functions.php";
loginCheck();
if (isset($db))
$conn->selectDB($db);
if (isset($_POST['query'])) {
$queryList = splitQueryText($_POST['query']);
foreach ($queryList as $query) {
$sql = $conn->query($query);
}
}
if ($conn->getAdapter() == "mysql") {
$structureSql = $conn->describeTable($table);
while ($structureRow = $conn->fetchAssoc($structureSql)) {
$types[$structureRow['Field']] = $structureRow['Type'];
}
}
if ($conn->isResultSet($sql)) {
$row = $conn->fetchAssoc($sql);
foreach ($row as $key => $value) {
echo "<div class=\"fulltexttitle\">" . $key . "</div>";
echo "<div class=\"fulltextbody\">";
$curtype = $types[$key];
if (strpos(" ", $curtype) > 0) {
$curtype = substr($curtype, 0, strpos(" ", $curtype));
}
if ($value && isset($binaryDTs) && in_array($curtype, $binaryDTs)) {
echo '<span class="binary">(' . __("binary data") . ')</span>';
} else {
echo nl2br(htmlentities($value, ENT_QUOTES, 'UTF-8'));
}
echo "</div>";
}
}
?>
|