What I'm trying to do is this: I have two tables with One to Many relationship sectors id name position set_plan_id seat_plans id name order I want to sort all sectors based on the order field present in seat_plans (which…
By default, Laravel uses the email and password fields for authentication , I want to change the default fileds for authentication and set the code_massar , date_naissance fields as default any help !! Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name');…
I have problem with validating html select. I put rules and all other form controls work fine but only select not show validate message. Model class Post extends Model { protected $table = 'post'; static $rules = [ 'title' =>…
Below is my laravel 8 api route and middleware that I use Route::group(['middleware'=>['auth:api', 'StripScript'],'prefix' => 'v1'], function(){ Route::get('/list', [ListController::class, 'list']); }); I this I want to bypass middleware 'auth:api' if I get request from specific ip address so user doesn't…
I am trying to update image to image/brand/ folder but unexpectedly error is occurred. public function update(Request $request,$id){ $validated = $request->validate([ 'brand_name' => 'required|max:4', // 'brand_image' => 'required|mimes:jpg,jpeg,png', ]); $old_image=$request->old_image; $brandimage=$request->file('brand_image'); $image_gen=hexdec(uniqid()); $image_exten=strtolower($brandimage->getClientOriginalExtension()); $image_name=$image_gen.'.'.$image_exten; $image_location='image/brand/'; $image_uplioad= $image_location.$image_name; $brandimage->move($image_location,$image_name); unlink($old_image); Brand::find($id)->update([…
App For Rental Car : I need check car if available between 2 date and check quantity ("column name : qty"), There is no need for a car more than the available number of cars (number cars booking < QTY…
I am working on a blogging application in Laravel 8. The application gives the users rights by assigning them roles. Every role has a set of permissions. There is a many-to-many relationship between roles and permissions. In the user-rights view,…
How do I return the following response format using the code below: {"data":[],"meta":{"paging":{"links":[],"total":0},"time":0.079}} The controller code: public function someMethod() { $var=SomeModel::with(['status' => function ($query) { $query->where('name', 'like', '%Pending Payment%'); }])->get(); return [ 'data' => $var, ]; } Response am getting…
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'category_slug' cannot be null (SQL: update products set category_slug = ?, products.updated_at = 2022-12-23 12:06:26 where id = 1) How I get product category_slug colmun from category slug table. Categories Table: |id|name|slug | |4…
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…