在我的網站上有一些我從 firebase 獲得的電影。電影的分數在 0 到 100 之間。我已經在我的網站上找到了所有電影。我還想按降序顯示它們。（例如，評分最高的 5 部電影）我怎樣才能做到這一點？感謝您的回答。
const app = initializeApp(firebaseConfig);
const db = getDatabase(app);
const auth = getAuth(app);
const firebaseRef= ref(getDatabase());
var body = document.getElementById('movies');
var body2 = document.getElementById('series');
function AddItemsToTable(name, score, img, id) {
var movies = `<div ><a href="movieDetail.html?movieId=${id}"><img src="${img}" ></a><p><a href="movieDetail.html?movieId=${id}">${name}</a></p> <p> <i id="star${id}"></i> <a >${score}%</a> </p> </div>`;
body.innerHTML =movies;
}
function AddItemsToTable2(name, score, img, id) {
var series = `<div ><a href="seriesDetail.html?seriesId=${id}"><img src="${img}" ></a><p><a href="seriesDetail.html?seriesId=${id}">${name}</a></p> <p> <i id="star2${id}"></i> <a >${score}%</a> </p> </div>`;
body2.innerHTML = series;
}
//*******************************I got the movies************************************************
function AddAllItemsToTable(TheMovies){
var counter=0;
TheMovies.forEach(element => {
if (counter===6) {
return;
}
AddItemsToTable(element.movieName, element.movieScore, element.movieImage, element.movieId);
counter ;
});
}
//************************I got tv series*********************************************
function AddAllItemsToTable2(TheSeries){
var counter=0;
TheSeries.forEach(element => {
if (counter===6) {
return;
}
AddItemsToTable2(element.seriesName, element.seriesScore, element.seriesImage, element.seriesId);
counter ;
});
}
function AddAllItemsToTable3(TheMovies){
var counter=0;
TheMovies.forEach(element => {
if (counter===6) {
return;
}
AddItemsToTable3(element.movieName, element.movieScore, element.movieImage, element.movieId);
counter ;
});
}
function getAllDataOnce(){
const dbRef=ref(db);
get(child(dbRef,"Movies"))
.then((snapshot)=>{
var movies=[];
snapshot.forEach(childSnapshot => {
movies.push(childSnapshot.val())
});
AddAllItemsToTable(movies);
});
}
function getAllDataOnce2(){
const dbRef=ref(db);
get(child(dbRef,"Series"))
.then((snapshot)=>{
var series=[];
snapshot.forEach(childSnapshot => {
series.push(childSnapshot.val())
});
AddAllItemsToTable2(series);
});
}
window.onload = (event) => {
getAllDataOnce();
getAllDataOnce2();
}; <div class="grid-container">
<header class="header">
<div class="solheader">
<a href="main.html" style="logo" class="big"> <img src="img/sonlogo3.png" alt="logo"></a>
<a href="main.html" style="logo" class="small"> <img src="img/logosmall.png" alt="logo" style="width:60px;height:48px;margin:5px;"></a>
</div>
<div class="ortaheader">
<input type="text" placeholder="Movies or TV series.." class="searchbox"><i class="fa fa-search arama"></i> </input>
<ul>
<li class="categories"><a href="#">Categories <i class="fa fa-caret-down" style="font-size:16px;"> </i></a>
<ul class="dropdown">
<li><a href="series.html">TV Series</a></li>
<li><a href="movies.html">Movies</a></li>
</ul>
</li>
</ul>
</div>
<div class="menu sagheader">
<ul>
<li>
<button class="ikon dropdown-toggle" type="button" data-toggle="dropdown"><i class="far fa-user"></i> </button>
<ul class="dropdown-menu">
<li class="accountname"><b><script>document.write(document.cookie.substring(5))</script></b></li>
<li class="login"><a href="login.html" style="color:red;"><i class="fa fa-sign-in-alt" style="color:red;"></i> Login</a> </li>
<li class="signup"><a href="signup.html" style="color:red;"><i class="fa fa-user-plus" style="color:red;"></i> Sign up</a> </li>
<li class="logout"><a onclick="deletecookie()" style="cursor:pointer;"><i class="fas fa-door-open" style="color:red;"></i> Log out</a></li>
</ul>
</li>
</ul>
</div>
</header>
<div class="body" id="body">
<div class="baslik">Movies</div>
<div class="baslik2"><a href="movies.html">See all</a></div>
<div id="movies">
</div>
<div class="baslik">Series</div>
<div class="baslik2"><a href="series.html">See all</a></div>
<div id="series">
</div>
<div class="baslik">Top Rated Movies</div>
<div class="baslik2"><a href="#">See all</a></div>
<div id="toprated">
</div>
</div>
<div class="footer">
<div class="">
<img src="img/sonlogo3.png" alt="logo">
<ul>
<li><a href="#">Help</a></li>
<li><a href="#">About</a></li>
<li><a href="#">Contact</a></li>
<li><a href="#">Terms and Policies</a></li>
</ul><br><br>
<ul>
<li>? 2021 Cinemeter</li>
<li class="destroy">|</li>
<li>All rights reserved.</li>
</ul>
</div>
</div>
</div>Firebase 資料庫
這是我的網站
uj5u.com熱心網友回復：
雖然 Firebase 可以對結果進行排序，但結果始終是升序的。如果要按降序顯示它們，則必須在應用程式代碼中反轉它們。
像這樣的東西：
const query = query(child(dbRef,"Movies"), orderByChild("movieScore"));
get(query).then((snapshot)=>{
var movies=[];
snapshot.forEach(childSnapshot => {
movies.push(childSnapshot.val())
});
movies.reverse
});
如果你想獲得最高分，你也可以limitToLast在查詢中使用：
const query = query(child(dbRef,"Movies"), orderByChild("movieScore"), limitToLast(5));
另請參閱有關排序和過濾資料以及限制結果數量的 Firebase 檔案。
關于您的資料結構的一些注意事項：
- 為節點使用順序數字鍵是 Firebase 中的一種反模式，通常最好使用 push keys。另請參閱最佳實踐：Firebase 中的陣列。
- 您將分數存盤為字串，這必然會導致問題，因為字串是按字典順序排序的。我建議轉換您的資料以將分數存盤為數字（因此不要
"在它們周圍加上引號）。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/401131.html
標籤：javascript html 火力基地 火力实时数据库