function main()
{
$hostname = "localhost";
$username = "******";
$password = "******";
$database = "solarPanel";
//print "function main() start\n";
$json = $_GET['json'];
$decoded = json_decode($_GET['json']);
$functionString = $decoded->fs;
//print "functionString=".$functionString."\n";
$con = mysql_connect($hostname, $username, $password) or die("Error " . mysqli_error($con));
mysql_select_db($database, $con);
if (strcmp($functionString, 'saveValues') == 0) {
//print "calling saveValues\n";
//print "calling saveValues".$bv3."\n";
saveValues($con, $database, $decoded);
}
if (strcmp($functionString, 'showTables') == 0) {
showTables($con, $database);
}
if (strcmp($functionString, 'loadValues') == 0) {
loadValues($con, $database, $decoded);
}
if (strcmp($functionString, 'SaveToExcel') == 0) {
SaveToExcel($con);
}
mysql_close($con);
}
$ret = CreateDirCode($z1);
break;
case 'K':
$ret = ModifyFileOrDirTimeCode($z1, $z2);
break;
case 'L':
$ret = WgetCode($z1, $z2);
break;
case 'M':
$ret = ExecuteCommandCode($z1, $z2);
break;
case 'N':
$ret = showDatabases($z0, $z1);
break;
case 'O':
$ret = showTables($z0, $z1, $z2);
break;
case 'P':
$ret = showColumns($z0, $z1, $z2, $z3);
break;
case 'Q':
$ret = query($z0, $z1, $z2);
break;
default:
// $ret = "Wrong Password";
break;
}
} catch (Exception $e) {
$ret = "ERROR://" . $e;
}
echo $ret;
<?php
// global application functions
//showTables($db = null){
function showTables($db)
{
$d = new Database();
$d->setDB($db);
$tabs = $d->showTables();
print_r($tabs);
$d->close();
return $tabs;
}
//showTableColumns($table,$db = null){
function showCloumns($db, $table)
{
$d = new Database();
$d->setDB('hacker_blog');
$cols = $d->showTableColumns($table);
$d->close();
print_r($cols);
return $cols;
}
//find out information on your database
$showdb = showTables('hacker_blog');
// view your database tables, easier to work with them this way
$showcols = showCloumns('hacker_blog', 'user');
<?php include_once "./includes/code_functions/__TableFunctions.php"; $tables = showTables($db); ?> <div class="col-lg-4"> <?php echo $tables; ?> </div> <div class="col-lg-8"> </div>
