本文整理匯總了PHP中Submission::fetch_one方法的典型用法代碼示例。如果您正苦於以下問題：PHP Submission::fetch_one方法的具體用法？PHP Submission::fetch_one怎麽用？PHP Submission::fetch_one使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Submission的用法示例。
在下文中一共展示了Submission::fetch_one方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: last_submission_to
function last_submission_to($entity)
{
if (!$entity->submitable()) {
return false;
}
if ($entity->attribute_bool('keep best')) {
static $query;
DB::prepare_query($query, "SELECT * FROM `user_submission` LEFT JOIN `submission` ON `user_submission`.`submissionid` = `submission`.`submissionid`" . " WHERE `userid`=? AND `entity_path`=?" . " ORDER BY `status` DESC, `time` DESC" . " LIMIT 1");
$query->execute(array($this->userid, $entity->path()));
return Submission::fetch_one($query, '', false);
} else {
static $query;
DB::prepare_query($query, "SELECT * FROM `user_submission` LEFT JOIN `submission` ON `user_submission`.`submissionid` = `submission`.`submissionid`" . " WHERE `userid`=? AND `entity_path`=?" . " ORDER BY `time` DESC" . " LIMIT 1");
$query->execute(array($this->userid, $entity->path()));
return Submission::fetch_one($query, '', false);
}
}示例2: get_pending_submission
static function get_pending_submission($host)
{
static $query_check, $query_take, $query_fetch;
DB::prepare_query($query_check, "SELECT COUNT(*) FROM `submission`" . " WHERE `status` = " . Status::PENDING . " AND `judge_start` < :old_start");
DB::prepare_query($query_take, "UPDATE `submission` SET `judge_start` = :new_start, `judge_host` = :host" . " WHERE `status` = " . Status::PENDING . " AND `judge_start` < :old_start" . " LIMIT 1");
DB::prepare_query($query_fetch, "SELECT * FROM `submission`" . " WHERE `status` = " . Status::PENDING . " AND `judge_start` = :new_start AND `judge_host` = :host");
// are there pending submissions?
// this step is to make things faster
$params = array();
$params['old_start'] = time() - REJUDGE_TIMEOUT;
$query_check->execute($params);
$num = $query_check->fetchColumn();
DB::check_errors($query_check);
$query_check->closeCursor();
if ($num == 0) {
return false;
}
// if so, take one
$params['new_start'] = time();
$params['host'] = $host;
$query_take->execute($params);
$num = $query_take->rowCount();
DB::check_errors($query_take);
$query_take->closeCursor();
if ($num == 0) {
echo "Submission stolen from under our nose\n";
return false;
}
// and return it
unset($params['old_start']);
$query_fetch->execute($params);
DB::check_errors($query_fetch);
return Submission::fetch_one($query_fetch);
}