• Categories
    • PHP
    • phpMyAdmin
    • PHPMailer
    • FFMpeg
    • PHPEXcel
    • PHPDoc
    • PHPUnit
    • CakePHP
    • CakePHP 2.0
    • Cake PHP 2.1
    • CakePHP Model
    • Facebook PHP SDK
    • composer-php
    • PHP 7
    • PHP GD
    All Categories
  • About

Laravel SQL query midnight time not showing

phplaraveleloquentphp-carbon


PHP Snippet 1:

DB::table('ferries')->groupBy('ferry_name')
->whereTime('departure_time', '>', Carbon::now()->toTimeString())
->whereIn('schedule_type', ['Weekday'])
->where('terminal_name',$terminal_name)->orderBy('departure_time')->get()->all()

PHP Snippet 2:

$posts =  DB::table('ferries')->orderBy('departure_time', 'asc')
            ->where('departure_time', '>', Carbon::now()->toTimeString())
            ->whereIn('schedule_type', ['Weekday'])
            ->where('terminal_name', $terminal_name)->get()->unique('ferry_name')->all();

Related Snippets

GA4 custom event from server side, can someone tell me how i can do the following code in php?

TesseractOCR not working for Laravel

How to change the app environment at run time?

Search for array row with specific column value and return another value from qualifying row

Backend cannot be reached after Typo3 login screen

wordpress : How to specify the cause "This site can’t be reached"

wp_remote_get() not passing authentication

Dynamic table in HTML using MySQL and php

Populate Dynamic Dropdowns List in Codeigniter

Adding one microsecond to Datetime object in PHP

How can I make a full text index of the column?

laravel controller function parameters

Filter WooCommerce products with post__in and additional meta queries

How to fix this error : Ask your hosting provider to use PHP 7.2.5 or higher for both HTTP and CLI?

Invalid value in field "itemtype" in Google Search Console

About Contact Privacy policy Terms and conditions