I have a User model which has a hasMany relationship to a Brands model and I am having issues updating the Brands for a user properly. I have a form which allows a user to enter / delete / update…
My Product Model is public function IncomeRepo(){ return $this->hasMany(Income::class,'Product'); } My Income Report Model Is public function ProductData(){ return $this->belongsTo(Product::class,'Product','id'); } My Query is public function SearchIncomeData(Request $request){ $GetFromDate = $request->FromDate; $GetToDate = $request->ToDate; $ProductData = Product::with('IncomeRepo')->whereBetween('created_at', [$GetFromDate, $GetToDate])->get(); return…
The following are the function that I am trying to make work. I think I have the information required correct and the corresponding data also exist in the table but it is showing the error as above. Below are the…
I am trying to work through the below code and it is giving me the error as above in postman. I thought that by storing AttendanceRecord in a variable should've sufficed. I wonder what did I do wrong ? Below…
I am currently developping a crud application with Laravel. I have an Ad class that contains a user_id and a model_id. I want to filter my ads with user and model table fields. I managed to do the request with…
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…