Example #1
0
<?php 
require_once "db.class.php";
$dbObj = new ms_new_mysql("210.43.79.196", "root", "123456", "judge", "", "utf-8", "0");
$sql = "SELECT * FROM `solution` WHERE problem_id>= 1000  ORDER BY `solution_id` DESC LIMIT 20";
$res = $dbObj->query($sql);
$rows_cnt = mysql_num_rows($res);
//echo '<pre>'.print_r(mysql_fetch_array($res)).'</pre>';
$RESULT = array(0 => "Accepted", 1 => "Presentation Error", 2 => "Time Limit Exceeded", 3 => "Memory Limit Exceeded", 4 => "Wrong Answer", 5 => "Runtime Error", 6 => "Output Limit Exceeded", 7 => "Complie Error", 8 => "System Error", 9 => "Security Error", 10 => "Unknown Error", 11 => "Waiting", 12 => "Running");
$LANG = array(1 => "GCC", 2 => "G++", 3 => "Pascal", 4 => "Java", 5 => "Python");
$view_status = array();
for ($i = 0; $i < $rows_cnt; $i++) {
    $row = mysql_fetch_array($res);
    $view_status[$i][0] = $row['solution_id'];
    $view_status[$i][1] = $row['problem_id'];
    $view_status[$i][2] = $row['user_id'];
    $view_status[$i][3] = $RESULT[$row['result']];
    $view_status[$i][4] = $row['time'];
    $view_status[$i][5] = $row['memory'];
    $view_status[$i][6] = $LANG[$row['language']];
    $view_status[$i][7] = '<a href=viewcode.php?sid=' . $row['solution_id'] . '>' . $row['code_length'] . '</a>';
    $view_status[$i][8] = $row['in_date'];
}
?>

<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>AcmSuperX</title>