Search
 
SCRIPT & CODE EXAMPLE
 

PHP

laravel db query

$users = DB::table('users')
            ->where('votes', '>', 100)
            ->orWhere(function($query) {
                $query->where('name', 'Abigail')
                      ->where('votes', '>', 50);
            })
            ->get();
Comment

laravel query latest

Prices::where('product_id', $product->id)->get()->latest('id');
Comment

query string in laravel

$request->query('queryName');
Comment

laravel elequent query

Model::where(function ($query) {
    $query->where('a', '=', 1)
          ->orWhere('b', '=', 1);
})->where(function ($query) {
    $query->where('c', '=', 1)
          ->orWhere('d', '=', 1);
});
Comment

Laravel when query

$query = Author::query();

$query->when(request('filter_by') == 'likes', function ($q) {
    return $q->where('likes', '>', request('likes_amount', 0));
});
$query->when(request('filter_by') == 'date', function ($q) {
    return $q->orderBy('created_at', request('ordering_rule', 'desc'));
});

$authors = $query->get();
Comment

laravel find query

// Retrieve a model by its primary key...
$flight = AppModelsFlight::find(1);

// Retrieve the first model matching the query constraints...
$flight = AppModelsFlight::where('active', 1)->first();

// Shorthand for retrieving the first model matching the query constraints...
$flight = AppModelsFlight::firstWhere('active', 1);
Comment

laravel find query

php artisan make:model Flight --migration

php artisan make:model Flight -m
Comment

laravel find query

return Destination::orderByDesc(
    Flight::select('arrived_at')
        ->whereColumn('destination_id', 'destinations.id')
        ->orderBy('arrived_at', 'desc')
        ->limit(1)
)->get();
Comment

laravel find query

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Flight extends Model
{
    /**
     * The primary key associated with the table.
     *
     * @var string
     */
    protected $primaryKey = 'flight_id';
}
Comment

laravel find query

foreach (Flight::where('foo', 'bar')->cursor() as $flight) {
    //
}
Comment

laravel query when

$users = DB::table('users')
                ->when($role, function ($query, $role) {
                    $query->where('role_id', $role);
                })
                ->get();
Comment

query builder laravel

use IlluminateDatabaseEloquentBuilder;

public function scopeFakePersons(Builder $query): Builder
{
  return $query->where('is_fake', 1);
}
Comment

LARAVEL QUERY

<?php

Route::get('games', function () {
    
    $games = DB::table('games')->get();
    
    return view('games', ['games' => $games]);
});
Comment

laravel find query

$model = AppModelsFlight::where('legs', '>', 100)->firstOr(function () {
        // ...
});
Comment

How to write this query in Laravel Eloquent

Visitor::select('country')
     ->withCount('id')
     ->groupBy('country')
     ->latest()
     ->get()
  
  //or
  
  Visitor::query()->groupBy('country')->orderByDesc('count')->select('country' ,DB::raw('COUNT(1) as count'))->get()
Comment

laravel find query

<?php

$flights = AppModelsFlight::all();

foreach ($flights as $flight) {
    echo $flight->name;
}
Comment

laravel find query

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Flight extends Model
{
    /**
     * The connection name for the model.
     *
     * @var string
     */
    protected $connection = 'connection-name';
}
Comment

laravel find query

foreach ($flights as $flight) {
    echo $flight->name;
}
Comment

Laravel query

//select specified colomns from all users
Employee::get(['name','email','title']);
Comment

laravel find query

use AppModelsDestination;
use AppModelsFlight;

return Destination::addSelect(['last_flight' => Flight::select('name')
    ->whereColumn('destination_id', 'destinations.id')
    ->orderBy('arrived_at', 'desc')
    ->limit(1)
])->get();
Comment

PREVIOUS NEXT
Code Example
Php :: product slider shortcode woocommerce 
Php :: read file and convert each line in array php 
Php :: php send values in $_SESSION to other page 
Php :: laravel except route 
Php :: artisan command to add resources to controller 
Php :: my xampp 
Php :: Paginating API HTTP Response in Laravel 
Php :: regex sl nic validation laravel 
Php :: can you call a javascript cookie using php 
Php :: How to protect your website from DDos Attack? 
Php :: can i install php7.4 inside vagrant homestead 
Php :: php artisan migrate error 
Php :: how to convert string to int in php laravel 
Java :: android.support.design.widget.coordinatorlayout androidx 
Java :: java get class by string 
Java :: how to play sounds on java 
Java :: circular imageview android 
Java :: know the version of maven 
Java :: default structure of java 
Java :: remove double quote java 
Java :: allow internet permission android 
Java :: java remove first character from string 
Java :: string to int java 
Java :: random string method java 
Java :: stream distinct by property 
Java :: get epoch time in java 
Java :: maven spring-boot-configuration-processor install 
Java :: dialog with edittext android 
Java :: pytho count avro file 
Java :: regex get string between quotes java 
ADD CONTENT
Topic
Content
Source link
Name
9+4 =