I have a variable that I would like to pass in a joined RAW query. How can I do that ? $current_user_id = Auth::user()->id; $query = DB::table('users as u') ->selectRaw(' ROW_NUMBER() OVER (ORDER BY u.id) AS No, u.id, u.username, l.level…
I have a table in my database that stores a student's progress in a course. Schema::create('course_student', function (Blueprint $table) { $table->primary(['course_id', 'user_id']); $table->char('user_id'); $table->char('course_id'); $table->timestamp('lesson_timestamp')->nullable(); $table->text('course_progress')->nullable(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreign('course_id')->references('id')->on('courses')->onDelete('cascade'); $table->timestamps(); }); Course progress is stored as a JSON object and consists…
I am sure there is a similar question, but I am unsure what to search to find my answer (If you know what I am looking for, please just comment with the link or whatever you do). I need a…
I am learning laravel. Right now working on a project with inertia. Have created a model, controller and view in default settings. I am able to create user with the built-in user manager. But getting 403 error while creating records…
My question is relevant to the concept of searching data. I am developing a project with Laravel. The question is, which is efficient? Get data from the database and search through PHP, Or prepare the SQL command and search inside…
So I have a many-to-many table with created_at and the foreign keys student_id and status_id. For each student, I want to retrieve an entry only if the latest one has status_id = 1. I tried it like this: (it's a…
I use Laravel Eloquent ORM in my project. I need to duplicate a base query in order to create different queries, and as a by-product I have a problem with the order of some JOIN statements. In order to simplify…
I have this relation in my model... $this->hasMany('AppInventory')->where('status',1) ->whereNull('deleted_at') ->where(function($query){ $query ->where('count', '>=', 1) ->orWhere(function($aQuery){ $aQuery ->where('count', '=' , 0) ->whereHas('containers', function($bQuery){ $bQuery->whereIn('status', [0,1]); }); }); }) ->orderBy('updated_at','desc') ->with('address', 'cabin'); And Sql query generated are : select * from `inventories`…
why this is not working?? anything else i need to doo??? (note: i don't want to call any boot method from model). in models its working fine with booted method // route Route::get('/tests', function () { return Test::find(1)->update([ 'name' =>…
so im trying to update my data, and it shows this: IlluminateDatabaseQueryBuilder::cleanBindings(): Argument #1 ($bindings) must be of type array, null given so when i try to look into it, the error is here $tradeSetup->tags()->whereNotIn('user_tag_id', $request->userTag)->delete(); weird thing is, i…