I'm trying to do a mass-update of an enum column's value in my Laravel 9 project through tinker, my model is called Domain and I have an enum column called status with different values. I'd like to select all entries…
I have 2 different tables data has order_id and I want to sort it in laravel blade foreach. My Controller: $questions = Question::where('quiz_id', $quiz->id)->orderBy('order_id', 'asc')->get(); $explanations = Explanations::where('quiz_id', $quiz->id)->orderBy('order_id', 'asc')->get(); My Blade: (I want to sort this 2 foreach by…
I face some jQuery problem on my laravel 7 version. When I add Excel, PDF, print button and pagination at a time. It didn't work. But I need both at a time. When I add bfrtip on jQuery, it works…
I want to print variable value inside string quote this is my variable var id = $(this).val(); how can i print this variable to this string $('#button_cetak').html('<a href="{{route('report.pdf',[$user->nip,'//this is place i wanna print'])}}" class="btn btn-warning btn-block"><i class="fas fa-print"></i> Cetak</a>'); thanks
I am stuck with a problem where I have a table with JSON column like this: ID|VALUE 1 |{"a":"text1234","b":"default"} 2 |{"a":"text1234","b":"default"} 3 |{"a":"text1234","b":"text234"} 4 |{"a":"text1234","b":"default2"} 5 |{"a":"text1234","b":"default2"} I would like to get all rows where value "b" is duplicate, so…
I am attempting to create a subscription to a product in Stripe in the same step as the user registration. I'm ultimately trying to avoid having them first create an account, and then entering their payment details once an account…
Before looking for a page I wanted to check if the id exists, so if I don't find it, give up looking I tried as follows: My controller product public function search(Request $request) { $id = $request->input('id'); if($produto = Produto::find($id))…
I am making laravel API to reset password by diverting laravel standard password reset function. This is controller <?php namespace AppHttpControllersApiAuth; use AppHttpControllersController; use IlluminateFoundationAuthResetsPasswords; use IlluminateHttpRequest; use IlluminateSupportFacadesPassword; use IlluminateSupportFacadesLog; class ResetPasswordController extends Controller { use ResetsPasswords; public function…
How can I write a query that will get the first active game_id that does not occur twice in the table below?
I am new to Laravel and looked already for a similiar thread but I didnt find something. I want to use Eloquent and I got 3 Models and Tables: Testseries, Devices and Users. The Users has a many to many…