我想从 Firebase 数据库中导入排序后的数据。
举个例子:我有一家小公司,我需要导入所有雇主的数据。我owner_01
这意味着我必须导入其子owner_uid
owner_01
匹配的所有用户。
这些数据将在网站上使用,这意味着我将使用javascript
。
这里有 JSON :
{
"Owner_users" : {
"owner_01" : {
"email" : "owner_01@gmail.com",
"uid" : 123
},
"owner_02" : {
"email" : "owner_02@gmail.com",
"uid" : 12345
}
},
"Users" : {
"user_01" : {
"Email" : "asd@ghita.com",
"Name" : "asd",
"age" : 23,
"owner_uid" : 123,
"uid" : "asd"
},
"user_02" : {
"Email" : "all@gmail.com",
"Name" : "all",
"age" : 49,
"owner_uid" : 123,
"uid" : "asdfg"
},
"user_03" : {
"age" : 60,
"email" : "ovenre@gmail.com",
"owner_uid" : 12345,
"uid" : "sdfzsvsvsd"
}
}
}
检查此 URL 以查看数据库的结构。更新:
网页代码:
<table class="mdl-data-table mdl-js-data-table ">
<thead>
<tr>
<th class="mdl-data-table__cell--non-numeric">Email</th>
<th>Age</th>
<th>uid</th>
</tr>
</thead>
<tbody id="usersData">
</tbody>
</table>
JS代码
var usersRef = firebase.database().ref('Users')
var query = usersRef.orderByChild('owner_uid').equalTo('123');
query.on("child_added", function(snapshot) {
var email = snap.child("Email").val;
var name = snap.child("Name").val;
var uid = snap.child("uid").val;
$("#usersData").append("<tr><td" + email + "</td><td>" + name + "</td><td>" + uid + "</td></tr>");
});
var usersRef = firebase.database().ref('Users')
var query = usersRef.orderByChild('owner_uid').equalTo('YOUR UID HERE');
query.on("child_added", function(snapshot) {
console.log(snapshot.val().uid);
});