👁 View: queryall.php
Path: /home/thiqat5/admincrud.thiqatech.com/sql/modules/queryall.php
Size: 990 B · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
<?php
/**
 * This file is a part of MyWebSQL package
 *
 * @file:      modules/queryall.php
 * @author     Samnan ur Rehman
 * @copyright  (c) 2008-2014 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());
		}
	}
?>