$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]');