Leaderboard
". mysqli_error());$db_select=mysqli_select_db($connection, $db_database);
$db_select=mysqli_select_db($connection, $db_database);
if (!$db_select) die ("Could not select the database:
". mysqli_error());
if (isset($_SESSION['uid'])) {
$sql = "SELECT team_name, affiliation FROM user_metadata WHERE usr_id = '".$_SESSION['uid']."';";
$result = mysqli_query($connection, $sql);
$row = mysqli_fetch_array($result);
$teamname = $row["team_name"];
$institution = $row["affiliation"];
$sql = "SELECT team_name, institution, date FROM team_result WHERE team_name = '".$teamname."' AND institution = '".$institution."' AND date = CURDATE();";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) == 0) {
$sql = "SELECT team_name, institution, MAX(date) AS 'Max Date' FROM team_result WHERE team_name = '".$teamname."' AND institution = '".$institution."';";
$result = mysqli_query($connection, $sql);
$row = mysqli_fetch_array($result);
$datetime = $row["Max Date"];
echo "
";
} else {
echo "
";
}
} else {
echo "
";
}
?>
| Team Name |
Institution |
AP |
ROCAUC |
\(R^2\) |
ERS |
10000000) {
$error = "Your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
if($FileType != $result_ext) {
$error = "Only '".$result_ext."' files are allowed.";
$uploadOk = 0;
}
// Upload result
$uploadOk = 1;
if ($uploadOk == 1) {
if (move_uploaded_file($_FILES['fileToUpload']["tmp_name"], $target_file)) {
// paths needs to be changed to fit in server directory hierarchy
$saved_file = "results/"."uid". $_SESSION['uid'] . "_" . $date . "." .$result_ext;
// paths needs to change to fit in server directory hierarchy
exec("cd python/;".$python." -W ignore evaluate.py --pred ../".$saved_file." 2>&1", $output);
//var_dump($output);
$returnval = round(floatval($output[0]), 4);
if ($returnval == 0){
$ap = round(floatval($output[1]), 4);
$auc = round(floatval($output[2]), 4);
$r2 = round(floatval($output[3]), 4);
/* Test whether user's data can be selected and inserted */
$query = "INSERT INTO team_result (`id`, `team_name`, `date`, `institution`, `ap`, `auc`, `r_squared`) VALUES (".$_SESSION['uid'].",'".$teamname."', CURDATE(), '".$institution ."', ".$ap.", ".$auc.", ".$r2.");";
$result = mysqli_query($connection, $query);
echo "Result upload successful. Your result is: AP = ".$ap.", AUC = ".$auc.", R^2 = ".$r2;
//echo "";
}
else{
$error = "Upload file is not valid! Valid submission should be a 5714 x 29 numerical csv file.";
}
} else {
$error = "Unknown problem when uploading your file, please contact administrator for help.";
}
}
if ($error) echo "Error: $error
";
}
$sql = "SELECT team_name, institution, ap, auc, r_squared, score FROM leaderboard ORDER BY score DESC;";
$result = mysqli_query($connection, $sql);
if( mysqli_num_rows($result) ) {
while ($row = mysqli_fetch_array($result)) {
echo "| ".$row["team_name"]." | ".$row["institution"]." | ".$row["ap"]." | ".$row["auc"]." | ".$row["r_squared"]." | ".$row["score"]." |
";
}
}
?>