/** * This file is a part of MyWebSQL package * * @file: modules/query.php * @author Samnan ur Rehman * @copyright (c) 2008-2012 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { // first time query will be from request, then we will get it from session (applying limit scenario) $table_select = v($_REQUEST["id"]) == 'table' ? true : false; if ($table_select) { $query = selectFromTable($db); } else { $query = simpleQuery($db); } if (!$query) { createErrorGrid($db, $query); return; } loadDbVars($db); if ($db->query($query)) { if (!$db->hasResult()) { $info = getCommandInfo($query); if ($info['dbAltered']) { Session::set('db', 'altered', true); } else { if ($info['setvar'] == TRUE) { setDbVar($info['variable'], $info['value']); } } createInfoGrid($db); } else { createResultGrid($db); } } else { createErrorGrid($db, $query); } }
/** * This file is a part of MyWebSQL package * * @file: modules/query.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { // first time query will be from request, then we will get it from session (applying limit scenario) $table_select = v($_REQUEST["id"]) == 'table' ? true : false; if ($table_select) { $query = selectFromTable($db); } else { $query = simpleQuery($db); } if (!$query) { createErrorGrid($db, $query); return; } loadDbVars($db); if ($db->query($query)) { if (!$db->hasResult()) { $info = getCommandInfo($query); if ($info['dbAltered']) { Session::set('db', 'altered', true); } else { if ($info['setvar'] == TRUE && is_scalar($info['variable']) && is_scalar($info['value'])) { setDbVar($info['variable'], $info['value']); } } createInfoGrid($db); } else { // if it is a data result set, show it as result grid, otherwise in simple grid layout $query_type = getQueryType($query); if ($query_type['can_limit']) { createResultGrid($db); } else { createSimpleGrid($db, __('Query') . ': ' . $query); } } } else { createErrorGrid($db, $query); } }