I am new to Laravel and I am using Laravel as an API for my Angular project. I have no problem when I am using the Laravel upon retrieving data using the get method but I have a big problem…
i have three migrations 2022_09_20_021431_create_posts_table.php Schema::create('posts', function (Blueprint $table) { $table->increments('id'); $table->string('title', 100); $table->text('body'); }); 2022_09_21_021455_create_category_posts_table.php Schema::create('category_posts', function (Blueprint $table) { $table->unsignedBigInteger('category_id')->nullable(); $table->unsignedBigInteger('post_id')->nullable(); $table->primary(['category_id', 'post_id']); $table->foreign('category_id')->references('id')->on('categories')->onUpdate('cascade')->onDelete('cascade'); $table->foreign('post_id')->references('id')->on('posts')->onUpdate('cascade')->onDelete('cascade'); }); 2022_09_28_021507_create_categories_table.php Schema::create('categories', function (Blueprint $table) { $table->increments('id'); $table->string('name', 100); }); i found…
I have the following custom login controller; But I want to lock the user out for an hour, at the moment it just locks them out for about 60 seconds or so, is this possible? public function login(Request $request) {…
I have three tables: Products id other values Downloads id user_id product_id Users id name I'd like to fetch last X Download table rows, get their product_id & user_id, product_id match Product table as user_id match User table, then make…
please help me I made a chart, but there is a problem when I want to display the data, why is it compacted? example code controller : if(Auth::user()->hasRole('Super Admin')) { $user = User::where('id', Auth::user()->id)->first(); $jumlah_user = User::orderBy('id', 'ASC')->get()->count(); $data =…
I added sentry.io integration to a Laravel application public function register() { $this->reportable(function (Throwable $e) { if (app()->bound('sentry')) { app('sentry')->captureException($e); } }); } If works fine if there are exceptions. I have a problem with Websocket authentication using Laravel's broadcasting…
I use Laravel Framework 9.31.0 on win11 I used action syntax in the file routesweb.php: Route::get('role', [TestController::class, 'index']); or full path to controller: => 'appHttpControllersTestController@index' or like this: use appHttpControllersTestController; Also I declared variable $namespace in the file appProvidersRouteServiceProvider.php and…
I have a report area for which I am using livewire, I need the reports to be filtered by product category, this works for me as long as the 'all' option that I have inside a select is not selected:…
I am making a laravel application where i have 2 tables: folder: id, name subfolder: id, name, folder_id 'folder_id' is linked to the id of the folder table. Now i have a page with all the folder's. and a click…
I have a users table, I need to pull out the count by year of birth. SQL example: -- years = [1999, 1997, 1996, ..., 1990] example SELECT u.city, count(*) -- all count SUM(IF(u.born_date between '1999-01-01' and '1999-12-31', 1, 0))…