I have an application with a Laravel backend using Sanctum. For the frontend, I use Nuxt3 with nuxt-auth-sanctum. When I run the frontend and backend on my local machine, everything works fine, and I can log in. For the local…
I have a query with multiple joins. Most joins are a 1 to 1 but two are 1 to man. My sql query returns results as expected with data from the 1 to many joins flattened into a single value.…
For my Laravel application, I have created a bitbucket-pipeline : image: php:8.0 pipelines: branches: stage: - step: name: Install Dependencies caches: - composer - node script: - apt-get update && apt-get install -y unzip libpng-dev libjpeg-dev libfreetype6-dev - docker-php-ext-configure gd…
I am currently learning Laravel Filament, but suddenly there is an error like this. Previously, I fixed the error, but the result was not as expected. This is a screenshot of the error result and its code. Error Filament public…
I want to create a nested JSON object, something like this: [ { "age": 8, "countAll": 3, "gender": [ { "genderName": "male", "countGender": 2 }, { "genderName": "female", "countGender": 1 }, ] }, { "age": 10, "countAll": 1, "gender": […
I don't understand how to add data to tables. I know I can use DB::insert to do it, but I also know that data should be added through seeders. I don't want to call a seeder from a migration because…
$period = new DatePeriod( new DateTime( '2024-03-20 00:00:00' ), new DateInterval('P1D'), new DateTime( '2024-03-28 23:59:59' ) ); $orders = OrderProduct::where ('brand','<>','NULL'); foreach ($period as $date){ $labels[] = $date->format('d-m-Y'); $searchDate = $date->format('Y-m-d'); **//This doesn't work** //$searchDate = '2024-03-26'; **//This works** $order…
I'm developing a Laravel application that requires different levels of access for different users, such as admins, editors, and regular users. What is the best way to implement a roles and permissions system in Laravel ?
i have a problem with redirect of controller or URL request, i have two api route for example: API No. 1: Route::prefix('v1')->group(function () { Route::controller('handelProController')->group(function () { Route::post('products/all/list', 'getList'); }); }); API No. 2: Route::prefix('v2')->group(function () { Route::controller('anotherProController')->group(function () {…
I'd like to insert the user-id of the current user into a table in column "user_id". The field is a relation to the user table. Migration / database schema Schema::create('pdlocations', function (Blueprint $table) { $table->id(); $table->timestamps(); $table->decimal('lon', 10, 7); $table->decimal('lat',…