}
         $return_string = $return_string . ">" . "<table id=\"search_table\" class=\"report\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" . "<colgroup>" . "<col class=\"num\"/>" . "<col class=\"ExamName\"/>" . "<col class=\"ExamType\"/>" . "<col class=\"ExamStatus\"/>" . "<col class=\"ExamPassword\"/>" . "<col class=\"CreatedUser\"/>" . "<col class=\"CreatedTime\"/>" . "<col class=\"ExamEnd\"/>" . "<col class=\"ExamsAction\"/>" . "</colgroup>" . "<tr>" . "<th>编号</th>" . "<th>名称</th>" . "<th>类型</th>" . "<th>状态</th>" . "<th>密码</th>" . "<th>创建人</th>" . "<th>创建时间</th>" . "<th>最后截止日期</th>" . "<th>动作</th>" . "</tr>";
     }
     if ($page_count < $page_size) {
         $row = mysqli_fetch_assoc($result);
         $ExamId = $row["ExamId"];
         $ExamName = $row["ExamName"];
         $ExamTypeStr = get_exam_type_name_from_id($row["ExamType"]);
         $ExamStatus = $row["Status"];
         $ExamPassword = $row["ExamPassword"];
         $CreatedUserId = $row["CreatedUser"];
         $CreatedUserName = get_user_name($CreatedUserId);
         $CreatedTime = $row["CreatedTime"];
         $Duration = $row["Duration"];
         $ExamEnd = $row["ExamEnd"];
         $ExamEndWithOnlyDate = timestamp_to_datetime_with_only_date(strtotime($ExamEnd));
         $StatusStr = $ExamStatus == 0 ? "下架" : "上架";
         $StatusAction = $ExamStatus == 1 ? "下架" : "上架";
         $page_count_display = $page_count + 1;
         $return_string = $return_string . "<tr>" . "<td>{$page_count_display}</td>" . "<td><span class=\"ExamName fixWidth\">{$ExamName}</span></td>" . "<td><span class=\"ExamType fixWidth\">{$ExamTypeStr}</span></td>" . "<td><span class=\"ExamStatus fixWidth\">{$StatusStr}</span></td>" . "<td><span class=\"ExamStatus fixWidth\">{$ExamPassword}</span></td>" . "<td><span class=\"CreatedUser fixWidth\">{$CreatedUserName}</span></td>" . "<td><span class=\"CreatedTime fixWidth\">{$CreatedTime}</span></td>" . "<td><span class=\"ExamEnd fixWidth\">{$ExamEndWithOnlyDate}</span></td>" . "<td><A OnClick=\"actionSearchExams({$ExamId},{$ExamStatus});\">{$StatusAction}</A><br/>" . "<A OnClick=\"modifySearchExams({$ExamId});\">修改</A><br/>" . "<A OnClick=\"deleteSearchExams({$ExamId});\">删除</A><br/>" . "<A OnClick=\"uploadUserExams({$ExamId});\">上传考试人员名单</A></td>" . "</tr>";
         $i++;
         $page_count++;
         if ($page_count == $page_size) {
             $return_string = $return_string . "</table>" . "</div>\n";
             $page_no++;
             $page_count = 0;
         }
     }
 }
 if ($page_count > 0) {
     $return_string = $return_string . "</table>" . "</div>\n";
            }
        }
    }
}
$str_query1 = $str_query1 . " ORDER BY CreatedTime DESC";
//***Step16 页面搜索SQl语句 结束
/////////////////////
// prepare the SQL command and query DB
/////////////////////
$SelectedProbs = array();
if ($result = mysqli_query($link, $str_query1)) {
    $row_number = mysqli_num_rows($result);
    if ($row_number == 0) {
        echo ERR_NOT_ENOUGH_PROBLEM;
        return;
    }
    for ($i = 0; $i < $row_number; $i++) {
        $row = mysqli_fetch_assoc($result);
        array_push($SelectedProbs, new Problem($row["ProblemId"], $row["ProblemDesc"], $row["ProblemType"], $row["ProblemLevel"], timestamp_to_datetime_with_only_date(strtotime($row["CreatedTime"]))));
    }
} else {
    if ($link) {
        mysqli_close($link);
    }
    sleep(DELAY_SEC);
    echo -__LINE__;
    return;
}
$result = array("problems" => $SelectedProbs);
echo json_encode($result);
return;