本文整理汇总了PHP中App\Http\Controllers\DB::count方法的典型用法代码示例。如果您正苦于以下问题：PHP DB::count方法的具体用法？PHP DB::count怎么用？PHP DB::count使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类App\Http\Controllers\DB的用法示例。
在下文中一共展示了DB::count方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: SubmitScoreFinal
public function SubmitScoreFinal(Requests\ScoreEntryFinalRequest $request)
{
$input = $request->all();
\DB::$user = 'euro2016';
\DB::$password = 'hllau860509';
\DB::$dbName = 'Euro2016';
$row = \DB::queryFirstRow("select * from Scores where MatchID = %i and UserID = %i", $request->matchid, Auth::user()->id);
$count = \DB::count();
//Log::info($count.' '.$request->matchid);
\DB::startTransaction();
if ($count == 0) {
\DB::insert('Scores', array('MatchID' => $request->matchid, 'UserID' => Auth::user()->id, 'CountryHome' => $request->CountryHomeScore, 'CountryAway' => $request->CountryAwayScore));
} else {
\DB::update('Scores', array('CountryHome' => $request->CountryHomeScore, 'CountryAway' => $request->CountryAwayScore), "ID=%i", $row['ID']);
}
$affectedcount = \DB::affectedRows();
\DB::update('Matches', array('CountryHomeID' => $request->CountryHomeID, 'CountryAwayID' => $request->CountryAwayID), "MatchID=%i", $request->matchid);
\DB::commit();
\DB::disconnect();
// retrieve country names and flag
$countrynamehome = \DB::queryFirstRow("select CountryName, Flag from Countries where CountryID = %i", $request->CountryHomeID);
$countrynameaway = \DB::queryFirstRow("select CountryName, Flag from Countries where CountryID = %i", $request->CountryAwayID);
$input['CountryHomeID'] = $countrynamehome['CountryName'];
$input['CountryAwayID'] = $countrynameaway['CountryName'];
$input['CountryHomeImage'] = $countrynamehome['Flag'];
$input['CountryAwayImage'] = $countrynameaway['Flag'];
//$input['CountryHID'] = $request->CountryHomeID;
//$input['CountryAID'] = $request->CountryAwayID;
return json_encode($input);
}示例2: Scores
private function Scores()
{
\DB::$user = 'euro2016';
\DB::$password = 'hllau860509';
\DB::$dbName = 'Euro2016';
$adminscore = \DB::query("select * from Scores where UserID = 4");
$NoOfMatches = \DB::count();
$userscore = \DB::query("select * from Scores where UserID = %i", Auth::user()->id);
$totalscore = 0;
foreach ($adminscore as $ascore) {
foreach ($userscore as $uscore) {
if ($uscore['MatchID'] == $ascore['MatchID']) {
if ($uscore['CountryHome'] == $ascore['CountryHome'] && $uscore['CountryAway'] == $ascore['CountryAway']) {
$totalscore += 3;
} else {
if ($uscore['CountryHome'] > $uscore['CountryAway'] && $ascore['CountryHome'] > $ascore['CountryAway']) {
$totalscore += 1;
} else {
if ($uscore['CountryHome'] < $uscore['CountryAway'] && $ascore['CountryHome'] < $ascore['CountryAway']) {
$totalscore += 1;
} else {
if ($uscore['CountryHome'] == $uscore['CountryAway'] && $ascore['CountryHome'] == $ascore['CountryAway']) {
$totalscore += 1;
}
}
}
}
}
}
}
return $totalscore;
// return View('Game.Scores', ['adminscore' => $adminscore, 'userscore' => $userscore, 'totalscore' => $totalscore]);
}