PHP RecordSet::free_result示例

function ResetContest(&$arg)
{
    $cid = safefetch($arg, 'cid');
    global $conn;
    $rs = new RecordSet($conn);
    $str = "delete from ranklist where cid = {$cid}";
    $rs->Query($str);
    $str = "delete from contest_status where cid = {$cid}";
    $rs->Query($str);
    $str = "update problems set accepted = 0, submissions = 0 where cid = {$cid}";
    $rs->Query($str);
    $rs->free_result();
    MsgAndRedirect("contests.php", "Contest has benn reset.");
}

示例#2

显示文件

文件： action.php 项目： thezawad/Sicily

function QueryStatus(&$arg)
{
    $sid = intval(safefetch($arg, 'sid', "Fail"));
    global $conn;
    $rs = new RecordSet($conn);
    $rs->Query("SELECT sid, uid, status, run_time, run_memory, failcase FROM status WHERE sid = {$sid}");
    if (!$rs->MoveNext()) {
        Fail("Invalid run id");
    }
    Output("status", $rs->Fields["status"]);
    Output("run_time", $rs->Fields["run_time"]);
    Output("run_memory", $rs->Fields["run_memory"]);
    Output("case_num", $rs->Fields["failcase"]);
    Output("uid", $rs->Fields["uid"]);
    Output("sid", $rs->Fields["sid"]);
    $rs->Query("select count(*) from queue");
    $rs->MoveNext();
    Output("queue_size", intval($rs->Fields[0]) + 1);
    $rs->free_result();
}

示例#3

显示文件

文件： contest_detail.php 项目： thezawad/Sicily

if (!$problem->GetByFields(array())) {
    error("No problem found");
}
global $conn;
$rs = new RecordSet($conn);
$rs->Query("SELECT cpid, COUNT(*) AS num FROM contest_status left join status on contest_status.sid = status.sid " . "WHERE cid = {$cid} and status = 'Accepted' GROUP BY cpid ORDER BY cpid");
$ac_num = array();
while ($rs->MoveNext()) {
    $ac_num[$rs->Fields['cpid']] = intval($rs->Fields['num']);
}
$rs->Query("SELECT cpid, COUNT(*) AS num FROM contest_status " . "WHERE cid = {$cid} GROUP BY cpid ORDER BY cpid");
$sm_num = array();
while ($rs->MoveNext()) {
    $sm_num[$rs->Fields['cpid']] = intval($rs->Fields['num']);
}
$rs->free_result();
?>

<script type="text/javascript" src="js/cproblem_list.js"> </script>
<script type="text/javascript" src="js/jquery.dataTables.min.js" > </script> 
<link type="text/css" rel="stylesheet" href="css/data_table.css"/>

<div id="problem_list"> 
    <h1><?php 
echo $contest->detail['title'];
?>
</h1>

    <table class="display advtable_fix ui-widget-content">
        <thead class="tr_header"><tr><th><?php 
echo _("Status");