Basic Query in Laravel PHP Framework Advance

2Aug - by dharmendra - 0 - In laravel

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

Query 14=>Get single data which trip is recently added by Tour Operator

Query 15=>Get single data which trip is recently added by Tour Operator and email is Dharmendra.cotocus@gmail.com

Query 16=>Get trip detail, image detail iternary detail wich following details

  1. Publish trip and email is ajay.cotocus@gmail.com
  2. Publish trip and email is dharmendra.cotocus@gmail.com
  3. Publish trip and email is vijay.cotocus@gmail.com

Query 16=>Get trip details image  detail  iternary detail with following detail

  1. The country is india and email dharmendra.cotocus@gmail.com
  2.   The country is malysia and email ajay.cotocus@gmail.com
  3.   The country is india and email vijay.cotocus@gmail.com

Facebook Comments