Exemplo n.º 1
0
$sys_dbName = $_POST['db'] != '' ? $_POST['db'] : $lstParams['db'];
$db = new phpDBConnection($sys_dbType);
$db->connect($sys_dbIP, $sys_dbLogin, $sys_dbPass, $sys_dbName, $sys_dbPort);
require "features.php";
// -- special functions
if ($_POST['type'] != '') {
    $sql = stripslashes($_POST['sql']);
    switch ($_POST['type']) {
        case 'e':
            print "<textarea id=data>";
            // start timer
            list($usec, $sec) = explode(" ", microtime());
            $t1 = (double) $usec + (double) $sec;
            // GET TIME
            // execute script
            $rs = $db->Execute($sql);
            // check timer
            list($usec, $sec) = explode(" ", microtime());
            $t2 = (double) $usec + (double) $sec;
            // GET TIME
            $db_time = round(((double) $t2 - (double) $t1) * 1000) / 1000;
            if (!$rs) {
                $msg = "<span style='color: red'>" . $db->res_errMsg . "</span> ";
            } else {
                $msg = "Query Time: " . $db_time . "<br>Affected Rows: " . $db->res_affectedRows . "<br> Rows Returned: " . $db->res_rowCount . "<br> Fields Returned: " . $db->res_fieldCount . "";
            }
            print $msg;
            print "</textarea>";
            print "<script>\n\t\t\t\twindow.onload = pload;\n\t\t\t\tfunction pload() {\n\t\t\t\t\tparent.document.getElementById('display').innerHTML = '<div style=\"padding: 10px; line-height: 135%;\">'+ document.getElementById('data').value +'</div>';\n\t\t\t\t}\n\t\t\t</script>";
            die;
            break;