I am currently working on a Laravel project and encountering an issue with Eloquent relationships. I have two models, User and Post, and I'm trying to establish a one-to-many relationship between them. However, I'm facing issues when trying to retrieve…
I need to find all results that include this substring (note the leading zero): $code = '02549'; Nomenclature::where('code', 'like', '%' . $code . '%')->get(); With such a builder, I get the correct request: select * from `nomenclatures` where `code` like…
I have an Array like below, is there any way to count the total number of occurrences of CID. For example: CID = 992010000021102 I want to count the result as 2 - Laravel 6, php 7.4 { "status": true,…
Laravel version: 6.20.44 I have the following command with an optional date param: protected $signature = 'do-my-thing {--date?=}'; I look to see if the option has been set: $dateToDoThing = $this->option('date'); and if it set, I want to use the…
I am trying to pull the data from two tables by joining the data, but the sql query executed is dead slow. The idea is to pull all users and then combine with the created_at date from points table. Pulling…
I zipped my project folder and uploaded to the Document Root for the subdomain. I have all my CSS and JS files inside the Public folder. On XAMPP it is working just fine, but when I upload it to my…
I'm writing a function to create and display a pdf file using Dompdf in a Laravel 6 project using PHP 8. I tried with many tutorials and even the official documentation from GitHub for the normal Dompdf version and it's…
Running php artisan dusk get the error: FacebookWebDriverExceptionUnknownErrorException: unknown error: net::ERR_CONNECTION_REFUSED (Session info: headless chrome=85.0.4183.83) Versions: OS: Windows 10 v1903 build 18362.1016 Chrome: 85.0.4183.83 Laravel: v6.18.37 Dusk: v5.11.0 Phpunit: v8.5.8 Tried: Disable firewall Set test website to use localhost (was…
I am using laravel 6.I have created a table called 'student', where the value increment of the 'id' column is supposed to happen but is not happening. This is my migration file: <?php use IlluminateDatabaseMigrationsMigration; use IlluminateDatabaseSchemaBlueprint; use IlluminateSupportFacadesSchema; class…
As you know Redis could have several databases, in my laravel setup ive defined 3 of them and using 2 at least '0' (default) '1' (cache) '2' (queue) Thats what ive set in config/database.php Furthermore, due to certain need I…