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'> <SCRIPT src='javascript/box.js'></SCRIPT> <SCRIPT src='javascript/basic.js'></SCRIPT> <SCRIPT src='javascript/sqlui.js'></SCRIPT> </HEAD>
<?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";