I have table "Jobs" having a field called "empids". we are storing comma separated employee ids in this field, for ex. 1,12,56. I am trying to return JSON using with() method by making belongsTo relation ship between Job and employee…
I have read many posts on similar problem... nothing works. 1/ I installed the package with composer. composer require barryvdh/laravel-dompdf 2/ Created app/Http/Controllers/PdfController.php namespace AppHttpControllers; use PDF; use IlluminateHttpRequest; class PdfController extends Controller { public function index() { $pdf =…
form models { //filters search if(isset($filters['search']) ? $filters['search'] : false){ return $query->where('tittle','like','%' . $filters('search') . '%') ->orWhere('body', 'like', '%' .$filters('search') . '%'); } } and from controller "posts" => Post::latest()->filter(request(['search']))->get() and i get Array callback must have exactly two elements…
I was trying to add a new column as a foriegn key in existing table in laravel 9. But, it continuously giving SQL error. I want to create a simple category_id as a foreign_key in brand table. The below code…
I want to use SQLite on laravel so I try to use php .artisan migrate and it give me an error ` IlluminateDatabaseQueryException could not find driver (SQL: PRAGMA foreign_keys = ON;) ` so I try to download sqlite3.dll from…
First important information: I’m new to Laravel, so your patience is appreciated. I’m currently migrating a framework of mine to Laravel and still in the early stages. I know that Laravel has it’s own database construction mechanism that is recommended…
Unable to prepare route [api/user] for serialization. Uses Closure. at vendor/laravel/framework/src/Illuminate/Routing/Route.php:1150
i got error 404 while applying route model binding , i am confused where i went wrong, even though i checked route and controller are correct this is my index coding ``` <h1 class="heading"> product <span>categories</span> </h1> <div class="box-container"> @foreach($kategori…
I ran into the error: ErrorException Undefined variable: pesan I have gone through similar problems solved here but none of the solutions have worked for me. The error is thrown from my RegisterController at bottom of the line. At the…
I am trying to figure out how to form my database query to build up a collection of projects, each of which has a set of personnel with their assigned working periods and the daily shift hours that they submit.…