<?php
error_reporting(E_ALL);
require 'class/sqlui.class.php';
function getmicrotime()
{
list($usec, $sec) = explode(" ", microtime());
return (double) $usec + (double) $sec;
}
$tempo_no_inicio = getmicrotime();
$sqlui = false;
if (!$sqlui) {
$sqlui = new SQLui();
}
$sqlui->Connect('root', 'pass');
//$sqlui->Database('sqlui');
$query = isset($_POST['query']) ? $_POST['query'] : '';
$command = $sqlui->Command($query);
$tempo = getmicrotime() - $tempo_no_inicio;
echo "<HTML>\n\t<HEAD>\n\t\t<TITLE>SQLui - SQL user interface for JSON</TITLE>\n\t\t<META http-equiv='Content-Type' content='text/html; charset=UTF-8'>\n\t\t<META name='Description' content='SQLui - SQL user interface for JSON'>\n\t\t<META name='Keywords' content='sqlui,database,sql,json,spiderpoison'>\n\t\t<META name='Author' content='*****@*****.**'>\n\t\t<STYLE>\n\t\t\t.title{background-color:silver;font:bold 100% Verdana;color:dimgray}\n\t\t\ttd{font:100% Verdana;color:gray}\n\t\t</STYLE>\n\t</HEAD>\n\t<BODY bgcolor=white link=darkorange vlink=orange topmargin=0 leftmargin=0 rightmargin=0 bottommargin=0>\n\t\t<TABLE border=1 cellspacing=0 width=100%>\n\t\t\t<TR class=title>\n\t\t\t\t<TD class=title>SQLui - SQL user interface for JSON</TD>\n\t\t\t</TR><TR>\n\t\t\t\t<TD><B>Query:</B> <form method=post style=display:inline><INPUT type=text name=query size=50 value=\"{$query}\"><input type=submit value=ok> {$tempo} Sec.</form></TD>\n\t\t\t</TR><TR>\n\t\t\t\t<TD><PRE>" . print_r($command, true) . "</PRE></TD>\n\t\t\t</TR>\n\t\t</TABLE>\n\t</BODY>\n</HTML>\n";
<?php
error_reporting(E_ALL);
require 'class/sqlui.class.php';
function CLui($variavel)
{
$resultado = '';
for ($i = 0; $i <= strlen($variavel); $i += 2) {
$resultado .= substr($variavel, $i + 1, 1) . '' . substr($variavel, $i, 1);
}
return $resultado;
}
$sqlui = false;
if (!$sqlui) {
$sqlui = new SQLui();
}
$sqlui->Connect('root', 'pass');
$query = isset($_POST['query']) ? $_POST['query'] : (isset($_GET['query']) ? $_GET['query'] : 'SHOW DATABASES');
if (isset($_REQUEST['query'])) {
$response = $sqlui->Command(CLui($query));
die(json_encode($response));
}
?>
<HTML>
<HEAD>
<TITLE>SQlui - SQL user interface for JSON</TITLE>
<META http-equiv='Content-Type' content='text/html; charset=UTF-8'>
<META name='Description' content='SQLui - SQL user interface for JSON'>
<META name='Keywords' content='sqlui,database,sql,json,spiderpoison'>
<META name='Author' content='*****@*****.**'>
<LINK rel='stylesheet' href='stylesheet/sqlui.css'>
