Starting: 1st of Every Month 
+91 8409492687 | 
Contact@DevOpsSchool.com
Laravel Database Queries
Query 12=>Show or get recently or last 6 data entered by user
Three method : first method
$dogs = Package::orderBy(‘id’, ‘desc’)->take(5)->get(); return $dogs;Second Method
$dogs = Package::latest()->take(5)->get(); return $dogs;third Method
$dogs= Package::orderBy(‘id’, ‘DESC’)->limit(5)->get(); return $dogs;Query 13=>Get all data except skip 4 first data which is added by tour Operator
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $dogs = Package::where('operator_email','dharmendra.cotocus@gmail.com') | |
| ->skip(4)->take(PHP_INT_MAX)->get(); | |
| ) | |
| return $dogs; | |
by Query 14=>Get single data which trip is recently added by Tour Operator
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $dog = Package::where('operator_email','dharmendra.cotocus@gmail.com' | |
| ->latest(); | |
| $dogs=$dog->first(); |
Query 15=>Get single data which trip is recently added by Tour Operator and email is Dharmendra.cotocus@gmail.com
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $dog = Package::where('operator_email','dharmendra.cotocus@gmail.com' | |
| ->latest(); | |
| $dogs=$dog->first(); |
Query 16=>Get trip detail, image detail iternary detail wich following details
- Publish trip and email is ajay.cotocus@gmail.com
- Publish trip and email is dharmendra.cotocus@gmail.com
- Publish trip and email is vijay.cotocus@gmail.com
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $dog = DB::table('packages') | |
| ->leftJoin('addimages','packages.TripTitle', '=', 'addimages.trips') | |
| ->leftJoin('iternaries','packages.TripTitle', '=', 'iternaries.trips') | |
| ->where('packages.publish','1')-> | |
| orwhere('packages.operator_email','ajay.cotocus@gmail.com')-> orwhere('packages.operator_email','vijay.cotocus@gmail.com')-> orwhere('packages.operator_email','dharmendra.cotocus@gmail.com')-> | |
| get(); | |
Query 16=>Get trip details image detail iternary detail with following detail
- The country is india and email dharmendra.cotocus@gmail.com
- The country is malysia and email ajay.cotocus@gmail.com
- The country is india and email vijay.cotocus@gmail.com
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $dog = DB::table('packages') | |
| ->leftJoin('addimages','packages.TripTitle', '=', 'addimages.trips') | |
| ->leftJoin('iternaries','packages.TripTitle', '=', 'iternaries.trips') | |
| ->where('slug','India') | |
| ->orwhere('packages.operator_email', 'dharmendra.cotocus@gmail.com') | |
| ->where('slug','Malaysia') | |
| ->orwhere('packages.operator_email','ajay.cotocus@gmail.com')-> | |
| ->where('slug','India') | |
| orwhere('packages.operator_email','vijay.cotocus@gmail.com')-> | |
| get(); |