function printDbList(&$db) { $dblist = getDbList($db); // if there is one database for the given userid, let's select it to cut out one extra step if (!Session::get('db', 'name')) { $stDb = 0; $selDb = ""; $stDbList = $db->getStandardDbList(); foreach ($dblist as $dbname) { if (in_array($dbname, $stDbList)) { $stDb++; } else { $selDb = $dbname; } } if (count($dblist) == $stDb + 1) { Session::set('db', 'name', $selDb); $db->selectDb(Session::get('db', 'name')); } } // --- end of automatic selection logic if (getDbName()) { $folder = $db->name(); echo view(array($folder . '/dblist', 'dblist'), array(), $dblist); } else { print '<span>' . __('Select a database to begin') . '.</span>'; } return $dblist; }
/** * This file is a part of MyWebSQL package * * @file: modules/describe.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { if (getDbName() == '' || !isset($_REQUEST['name'])) { echo view('invalid_request'); return; } if ($db->getTableDescription($_REQUEST['name'])) { createSimpleGrid($db, __('Table Description') . ': [' . htmlspecialchars(getDbName()) . ']'); } }
/** * This file is a part of MyWebSQL package * * @file: modules/infodb.php * @author Samnan ur Rehman * @copyright (c) 2008-2012 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { if (getDbName() == '') { echo view('invalid_request'); return; } if ($db->queryTableStatus()) { createSimpleGrid($db, __('Database summary') . ': [' . htmlspecialchars(getDbName()) . ']'); } }
function getDatabaseTreeHTML(&$db, $dblist = array()) { $folder = $db->name(); if (getDbName()) { $objects = $db->getObjectList(true); // sort the object listing based on user preferences $sort = Options::get('ui-tables-sort'); if ($sort && count($objects['tables']) > 1) { $objects['tables'] = sortTableListing($objects['tables'], $sort); } return view(array($folder . '/objtree', 'objtree'), array(), $objects); } return view(array($folder . '/dbtree', 'dbtree'), array(), $dblist); }
/** * This file is a part of MyWebSQL package * * @file: modules/infoserver.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { if (!$db->hasServer()) { echo view('infoserverless', array()); return; } if ($db->queryVariables()) { $folder = $db->name(); include find_view(array($folder . '/templates/variables', 'templates/variables')); $vars = parseVariables($db); $replace = $vars + array('JS' => ''); if (getDbName() == '') { // no database selected, hide menus that belong to a db only $replace['JS'] = 'parent.$("#main-menu").find(".db").hide();'; } echo view(array($folder . '/infoserver', 'infoserver'), $replace); } }
<meta http-equiv="Content-Type" content="text/html; charset='utf-8';" /> <title>MyWebSQL</title> <link rel="stylesheet" type="text/css" href="cache.php?css=theme,default" /> <link rel="SHORTCUT ICON" href="favicon.ico" /> <link rel="stylesheet" type="text/css" href="cache.php?css=menu,treeview,results,context,alerts" /> <script type="text/javascript" language="javascript" src="cache.php?script=jquery,mobile,<?php echo $DB->name(); ?> "></script> <!--[if lt IE 8]> <script type="text/javascript" language="javascript" src="cache.php?script=json2"></script> <![endif]--> </head> <body class="mainbody"> <?php if (!$DB->connect(DB_HOST, DB_USER, DB_PASS, getDbName())) { include BASE_PATH . "/modules/splash.php"; die(getSplashScreen(showDBError())); } if (Session::get('session', 'init') != '1') { // session just started, so we load information here Session::set('db', 'user', $DB->getCurrentUser(), true); Session::set('session', 'init', 1); } $KEY_CODES = getKeyCodes(); ?> <div id="editToolbar"> <div class="tb-header ui-widget-header"><span class="fname"></span></div> <div class="tb-row">Type: <span class="ftype"></span></div> <div class="tb-row">[ <?php echo str_replace('{{KEY}}', $KEY_CODES['KEYCODE_SETNULL'][1], __('Press {{KEY}} to set NULL'));
<?php /** * This file is a part of MyWebSQL package * * @file: modules/info.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ if (getDbName() != '') { include 'infodb.php'; } else { include 'infoserver.php'; }
public function getPrefix() { global $dbname, $table_prefix; return '`' . $this - getDbName() . '`.' . $table_prefix; }
if (isOK($response)) { printImageArrayResult($response, " ---- GETTING ITEM FAILED ---- ", " ---- GETTING ITEM SUCCESSFULLY COMPLETED ---- "); } else { echo $response->getMessage(); } break; case "getTrackingDatas": echo "Getting trackables..." . PHP_EOL; $email = getEMail(); $password = getPassword(); $dbName = getDbName(); $response = getTrackingDatas($email, $password, $dbName); if (isOK($response)) { printImageArrayResult($response, " ---- GETTING TRACKABLES FAILED ---- ", " ---- GETTING TRACKABLES SUCCESSFULLY COMPLETED ---- ", "trackable"); } else { echo $response->getMessage(); } break; case "getStats": echo "Getting Stats..." . PHP_EOL; $email = getEMail(); $password = getPassword(); $dbName = getDbName(); $response = getStats($email, $password, $dbName); if (isOK($response)) { printResult($response, " ---- GETTING STATS FAILED ---- ", " ---- GETTING STATS SUCCESSFULLY COMPLETED ---- ", true); } else { echo $response->getMessage(); } break; }