$excludeString = @$_REQUEST['exclude'];
$dbname = @$_REQUEST['dbname'];
$table = @$_REQUEST['tables'];
$column = @$_REQUEST['column'];
$out = "";
if ($command == 'structure') {
$out = getStructure($db, $dbname);
} else {
if ($command == 'indexies') {
$out = getIndexies($db, $dbname);
} else {
if ($command == 'keys') {
$out = getForeginKey($db, $dbname);
} else {
if ($command == 'tables') {
$out = getTableNames($db, $dbname, $table);
} else {
if ($command == 'databases') {
$out = getDatabaseNames($db, $dbname, $table);
} else {
if ($command == 'search' && trim($word) != "" && strlen(trim($word)) > 2) {
$dbnames = array();
$tables = array();
$columns = array();
if ($selector != "") {
$parts = explode("|", $selector);
if (isset($parts[0])) {
$dbnames = explode(",", $parts[0]);
}
if (isset($parts[1])) {
$tables = explode(",", $parts[1]);
$post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT);
die($post_data);
} else {
$query = "SELECT * FROM mdl_attendance";
$result = mysqli_query($conn, $query);
if (!$result) {
$post_data = array('message' => 'no table found in sql database', 'comment' => 'No Attendance Plugin found on Moodle Host');
$post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT);
die($post_data);
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if (isset($_GET['method']) && $_GET['method'] != "") {
switch ($_GET['method']) {
case 'get_table_names':
getTableNames($conn);
break;
case 'get_table_columns':
if (isset($_GET['table_name']) && $_GET['table_name'] != "") {
getTableColumns($conn, $_GET['table_name']);
} else {
$post_data = array('message' => 'missing parameters', 'comment' => 'require param [table_name]');
$post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT);
echo $post_data;
}
break;
case 'get_table_data':
if (isset($_GET['table_name']) && $_GET['table_name'] != "") {
getTableData($conn, $_GET['table_name']);
} else {
$post_data = array('message' => 'missing parameters', 'comment' => 'require param [table_name]');
