Chapter 10 - Fetch data from Firebase performing Simple and compound queries using Laravel PHP

In this chapter, we will learn how to can fetch data from Firebase Cloud Firestore by performing simple and compound queries using Laravel PHP package.

Consider the list of Student in Firebase Cloud Firestore. We would fetch these student data using all example of queries.

Fetch the normal list

 $students = app('firebase.firestore')->database()->collection('Student')->documents();  
 print_r('Total records: '.$students->size());  
 foreach($students as $stu) {  
   if($stu->exists()){  
    print_r('Student ID = '.$stu->id());  
    print_r('Student Name = '.$stu->data()['name']);  
   }  
 }  

Now search query, search by name in student list

 $students = app('firebase.firestore')->database()->collection('Student')->documents()  
 ->where('name','==','John Doe');  

Remember there is no like query in firebase. We have to make exact match, even it is case sensitive. Example these search words would not work "John Doe" data:
"john doe", "John", "Doe", "Joh"

Using Sort Functionality, order by name in Ascending

 $students = app('firebase.firestore')->database()->collection('Student')->documents()  
 ->orderby('name','asc');  

Order by id in descending

 $students = app('firebase.firestore')->database()->collection('Student')->documents()  
 ->orderby('id','desc');  

Using limit and offset for implementing pagination

 $students = app('firebase.firestore')->database()->collection('Student')->documents()  
 ->offset(0)->limit(10);  

Now if you data get insert in your list when your fetching the list. So will use startAfter functionality. Consider this as next page token we use to get data from the last data of first request.

 $laststudent = false;  
 $morestudent = true;  
 while($morestudent) {  
   $students = app('firebase.firestore')->database()->collection('Student');  
   if($laststudent)  
      $students->startAfter($laststudent);  
   $students->limit(10)->documents();  
   print_r('Total records: '.$students->size());  
   if($students->size() > 0){  
     foreach($students as $stu) {  
       if($stu->exists()){  
         print_r('Student ID = '.$stu->id());  
         print_r('Student Name = '.$stu->data()['name']);  
       }  
     }  
   }else{  
     $morestudent = false;  
   }  
 }  

Now fetch by id detail of Student. The detail page of the student.

 app('firebase.firestore')->database()->collection('Student')->documents(<studentid>)->snapshot();  

Example

 $student = app('firebase.firestore')->database()->collection('Student')->document('defT5uT7SDu9K5RFtIdl')->snapshot();  
 print_r('Student ID = '.$student->id());  
 print_r('Student Name = '.$student->data()['name']);  

Hope the listing of data from Firebase Cloud Firestore is now clear. Please let us know in comments if you have any doubts.