laravel

[Solved] Laravel Eloquent the same queries

by

In Either one of the code above, the query will just be 1 $a = Flight::find(1); is same as select * from `flights` where `flights`.`id` = 1 limit 1` Since $a & $b are 2 different variables, though they are calling the same Eloquent function, the queries are different. So the code above will result … Read more

[Solved] Laravel 8 (xampp)

by

You need to run the php artisan migrate command so that the tables should be created in your db currently, the tables are not created. Instead of migration you can also manually add all the tables by looking into the Modals but it is not preferred. solved Laravel 8 (xampp)

[Solved] how to upload a pdf document in Laravel

by

I have already uploaded a file with its name. If you want to specific name will be file name, then change $file->storeAs($filePath, $fileName=”RESUME”, ‘uploads’);.If you have any queries, feel free to comment below. Thanks protected function create(array $data){ $request = request(); $profileImage = $request->file(‘resumes’); $profileImageSaveAsName = time() . Auth::id() . “-profile.” . $profileImage->getClientOriginalExtension(); $upload_path=”resumes/”; $resumes= … Read more

[Solved] How to update array in laravel

by

public function edit(Filter $filter) { $colors = Color::all(); $categories = Category::lists(); $filters = Filter::with(‘category’)->whereHas(‘category’, function($query) use ($filter){ $query->whereIn(‘category_id’, [$filter->category_id]); })->get(); // I’m not sure what do you want by this instead of $filter->load(‘category’); return view(‘Admin.filters.edit’, compact(‘categories’, ‘colors’, ‘filter’, ‘filters’)); } public function update(Request $request, $id) { dd(‘ok’); } Blade File <form method=”post” action=”{{ route(‘filters.update’, $filter->id) … Read more

[Solved] How can i convert it to laravel

by

Holy Moly…. I highly recommend you to read the documentation. routes/web.php <?php Route::get(‘form’, ‘TestController@form’)->name(‘form’); Route::post(‘form’, ‘TestController@submit’); App\Http\Controllers\TestController.php <?php namespace App\Http\Controllers; use App\Http\Controllers\Controller; use Request; class TestController extends Controller { public function form() { return view(‘form’); } public function submit(Request $request) { $validator = $request->validate([ // validation here // ‘input’ => ‘rule’ ]); dd($validator); } } … Read more

[Solved] How to store array in table split by array_chunk in php? [closed]

by

You need to change your foreach to this to allow for the creation of new Model instance for each record set. foreach ($matches as $value) { $share_holder_info = new ShareHolderInfo(); $share_holder_info->trad_id = $rand_id; $share_holder_info->name = $value[0]; $share_holder_info->address = $value[1]; $share_holder_info->shares = $value[2]; $share_holder_info->save(); } You will need to change it to what ever your actual … Read more

[Solved] Laravel check if user exists

by

User with the same name, surname, and birthday $duplicate_user = \DB::table(‘users’) ->where(‘name’, ‘LIKE’, $new_name) ->where(‘surname’, ‘LIKE’, $new_surname) ->where(‘birthday’, ‘=’, $new_birthday) ->first(); if($duplicate_user) { return response(‘This user already exists’, 422); } solved Laravel check if user exists

[Solved] Mysql Query error in where clause on left join

by

I think there should be A.created_date instead of A.created_at select `plans`.`name`, `A`.`subscription_id`, `A`.`amount`, `A`.`created_date`, `A`.`end_date`, `A`.`subscription_status`, `users`.`email`, `A`.`plan_id`, `A`.`user_id`, `usage`.`created_at` as `usagedate`, COUNT(usage.id) as used_count from `subscriptions` A left join `users` on `users`.`id` = `A`.`user_id` left join `plans` on `A`.`plan_id` = `plans`.`Id` left join `usage` on `A`.`user_id` = `usage`.`user_id` where `usage`.`created_at` between A.created_date and A.end_date … Read more

[Solved] I need the way to aggregate based on column value using MySQL

by

Here is a way to aggregate based on column value. This query will give you count of on time and late student for a particular date. SELECT `Date`, DATE_FORMAT(`Date`, ‘%d’) AS Month_Date, — You can modify it as per your requirement SUM(IF(`Attendance` = ‘OnTime’, 1, 0)) AS OnTime_Count, SUM(IF(`Attendance` = ‘Late’, 1, 0)) AS Late_Count … Read more