Esempio n. 1
0
/**
 * This file is a part of MyWebSQL package
 *
 * @file:      modules/queryall.php
 * @author     Samnan ur Rehman
 * @copyright  (c) 2008-2012 Samnan ur Rehman
 * @web        http://mywebsql.net
 * @license    http://mywebsql.net/license
 */
function processRequest(&$db)
{
    $query = v($_REQUEST["query"]);
    if (!$query) {
        createErrorGrid($db, $query);
        return;
    }
    //Session::set('select', 'query', $query);
    $temp = tmpfile();
    fwrite($temp, $query);
    fseek($temp, 0);
    include BASE_PATH . "/lib/sqlparser.php";
    $parser = new sqlParser($db);
    $parser->collectStats();
    if (!$parser->parseFile($temp)) {
        createErrorGrid($db, $parser->getLastQuery(), $parser->getExecutedQueries(), $parser->getRowsAffected());
    } else {
        $stats = $parser->getStats();
        if ($stats->dbAltered) {
            Session::set('db', 'altered', true);
        }
        createInfoGrid($db, $query, $parser->getExecutedQueries(), $parser->getRowsAffected(), false, $parser->getExecutedTime());
    }
}