本文整理匯總了PHP中XDB::insertID方法的典型用法代碼示例。如果您正苦於以下問題：PHP XDB::insertID方法的具體用法？PHP XDB::insertID怎麽用？PHP XDB::insertID使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類XDB的用法示例。
在下文中一共展示了XDB::insertID方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: vote
public function vote($answer)
{
XDB::startTransaction();
XDB::execute('INSERT INTO qdj_votes
SET qdj = {?}, uid = {?}, rank = 0, rule = "null"', $this->id(), S::user()->id());
$vote = XDB::insertID();
// Get the rank
$rank = XDB::query('SELECT COUNT(*)+1
FROM qdj_votes
WHERE qdj = {?} AND rank != 0', $this->id())->fetchOneCell();
if ($rank == 1) {
if ($this->writer === null) {
$this->select(QDJSelect::all());
}
XDB::execute('INSERT INTO qdj_votes
SET qdj = {?}, uid = {?}, rank = 0, rule = 10', $this->id(), $this->writer->id());
}
$rule = null;
switch ($rank) {
case 1:
$rule = '1';
break;
case 2:
$rule = '2';
break;
case 3:
$rule = '3';
break;
case 13:
$rule = '4';
break;
case 42:
$rule = '5';
break;
case 69:
$rule = '6';
break;
case 314:
$rule = '7';
break;
case substr(strrchr(IPAddress::get(), '.'), 1):
$rule = '8';
break;
case date('d') + date('m'):
$rule = '9';
break;
}
XDB::execute('UPDATE qdj_votes
SET rank = {?}, rule = {?}
WHERE vote_id = {?}', $rank, $rule, $vote);
XDB::commit();
if ($answer == 1) {
XDB::execute('UPDATE qdj SET count1 = count1+1 WHERE id={?}', $this->id());
} else {
XDB::execute('UPDATE qdj SET count2 = count2+1 WHERE id={?}', $this->id());
}
}