本文整理汇总了PHP中app\Photo::orderBy方法的典型用法代码示例。如果您正苦于以下问题:PHP Photo::orderBy方法的具体用法?PHP Photo::orderBy怎么用?PHP Photo::orderBy使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\Photo
的用法示例。
在下文中一共展示了Photo::orderBy方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: handle
/**
* Execute the job.
*
* @return void
*/
public function handle()
{
$recordsPerPage = 3;
$offset = ($this->page - 1) * $recordsPerPage;
$count = Photo::count();
if ($this->page > 1) {
$previousPage = $this->page - 1;
} else {
$previousPage = null;
}
if ($this->page * $recordsPerPage < $count) {
$nextPage = $this->page + 1;
} else {
$nextPage = null;
}
$photos = Photo::orderBy('posted_date', 'desc')->skip($offset)->take($recordsPerPage)->get();
//$previousUrl = action('PhotosController@index', ['page' => $previousPage]);
//$nextUrl = action('PhotosController@index', ['page' => $nextPage]);
if ($previousPage) {
$previousUrl = url('photos/display/' . $previousPage);
} else {
$previousUrl = null;
}
if ($nextPage) {
$nextUrl = url('photos/display/' . $nextPage);
} else {
$nextUrl = null;
}
return ['photos' => $photos, 'previousUrl' => $previousUrl, 'nextUrl' => $nextUrl];
}
示例2: index
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return view('photos', ['photos' => Photo::orderBy('created_at', 'asc')->get()]);
}
示例3: date
$date = date("Y-m-d");
$heure = date("H:i:s");
$iduser = Auth::user()->idutilisateur;
$anecdote = new Anecdote();
$anecdote->anecdote = $request->anecdote;
$anecdote->idperle = $request->input('idperle');
$anecdote->dateanecdote = $date;
$anecdote->heureanecdote = $heure;
$anecdote->idutilisateur = $iduser;
if ($anecdote->save()) {
return view('accueil_bootstrap');
}
});
// Rècupere aléatoirement des photos dans la base de données afin de la afficher sur la page d'accueil (bandeau à droite)
Route::get('/photosaleatoires', function () {
$photos = Photo::orderBy(DB::raw('RAND()'))->get();
/* $photos= DB::table('photos')
->select(['nomphoto'])
->orderBy('RAND()'); */
echo json_encode($photos);
});
// Affiche la page de consultation
Route::get('/consulter', function () {
$perles = Perle::get();
return view('consulter_perle');
});
/* --------------- FORMULAIRE DE CONSULTATION ------------------- */
// Affiche au format JSON de toutes les catégories
Route::get('/categoriesREST', function () {
$categories = Categorie::get();
echo json_encode($categories);
示例4: index
/**
* Display view for homepage
*
* @param Photo $images
* @return $this
*/
public function index(Photo $images)
{
return view('welcome')->with('images', $images->orderBy('created_at', 'desc')->paginate(20));
}