ajaxfulltext.php

<?php
/*

SQL Buddy - Web based MySQL administration
http://interruptorgeek.com/sql-buddy-ig-review/

ajaxfulltext.php
- fetches full text for browse tab

MIT license

Original : 2008 Calvin Lough <http://calv.in>
Reviewed : 2016 Carlos Martín Arnillas <https://interruptorgeek.com>

*/

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

$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>";
	}
}

?>