MichalOravec

It's same what you have in Form::checkbox

The first code what I gave you is about ids. If you have an array with ids then just use whereIn

$deals = Deal::whereIn('id', session()->get('deals.recently_viewed', []));

@foreach($permission as $value)
    <input type="checkbox" name="permission[]" class="form-control name" value="{{ $value->id }}" {{ in_array($value->id, $rolePermissions) ? 'checked' : '' }}>
@endforeach

You need to append a query string q to the url in pagination links

$posts = Post::where('title', 'like', $q = "%{$request->q}%")
    ->orWhere('description', 'like', $q)
    ->paginate(4)
    ->withQueryString();

Docs: https://laravel.com/docs/8.x/pagination#appending-query-string-values

Because you can see it here that it works.

It's not about where, if you check only id it;s better to use find() or findOrFail()

If you need to get a collection then use where

$raterTypeSchools = RaterTypeSchool::withCount('raterLists')->where('column', 'something')->get();

$raterTypeSchool = RaterTypeSchool::withCount('raterLists')->findOrFail(1);

$raterTypeSchool->rater_lists_count;

You need to add this route

Route::get('services/deleted', '[email protected]')->name('services.deleted');

before

Route::get('services/{service}', '[email protected]')->name('services.show');

So your routes order should be

Route::get('services', '[email protected]')->name('services.index');
Route::get('services/create', '[email protected]')->name('services.create');
Route::post('services','[email protected]')->name('services.store');

Route::get('services/deleted', '[email protected]')->name('services.deleted');
Route::get('services/{service}', '[email protected]')->name('services.show');
Route::get('services/{service}/edit', '[email protected]')->name('services.edit');
Route::patch('services/{service}','[email protected]')->name('services.update');
Route::delete('services/{service}', '[email protected]')->name('services.destroy');

Probably yes, I'm busy right now.

$dealIds = collect(session()->get('deals', []))->pluck('id');

if ($dealIds->contains($deal->getKey()) && $index = $dealIds->search($deal->getKey())) {
    session()->pull("deals.{$index}");
}

session()->push('deals', $deal);

Oh ok, you have same uri contact there in both routes. The second one replace the first one.

So change it

Route::get('contact', '[email protected]')->name('contact.index');
Route::get('contact'/create, '[email protected]')->name('contact.create');

Oh ok, you have same uri contact there in both routes. The second one replace the first one.

So change it

Route::get('contact', '[email protected]')->name('contact.index');
Route::get('contact'/create, '[email protected]')->name('contact.create');

Run this command

php artisan route:clear

https://laravel.com/docs/8.x/routing#route-caching

You forget to add use to pass variable to the closure.

$post = Post::find(1);
    
return Category::whereDoesntHave('posts', function ($query) use ($post) {
    $query->where('id', $post->id);
})->get();

You forget to add use to pass variable to the closure.

$post = Post::find(1);
    
return Category::whereDoesntHave('posts', function ($query) use ($post) {
    $query->where('id', $post->id);
})->get();

It doesn't matter if you have Laravel 8 or not. It's same on all Laravel versions.

The main point is the order of your routes.

https://laravel.com/docs/7.x/controllers#restful-supplementing-resource-controllers

Yes getKey() returns just primary key of your table, usually an id.

If you want to do that, just add $deal to the session, but then you need to use a collection to apply same logic in_array, array_search etc.

Don't use wildcard *, be more specific to which view you want to add it.

View::composer([
    'includes.interested.SOMETHING'
], InterestedComposer::class);

The code in the controller should be something like this

if (in_array($deal->getKey(), $deals = session()->get('deals.recently_viewed', []))) {
    $index = array_search($deal->getKey(), $deals);

    session()->pull("deals.recently_viewed.{$index}");
}

session()->push('deals.recently_viewed', $deal->getKey());

I think a problem is that you have other routes after resource controller

Docs: https://laravel.com/docs/8.x/controllers#restful-supplementing-resource-controllers

Don't use wildcard *, be more specific to which view you want to add it.

View::composer([
    'includes.interested.SOMETHING'
], InterestedComposer::class);

The code in the controller should be something like this

if (in_array($deal->getKey(), $deals = session()->get('deals.recently_viewed', []))) {
    $index = array_search($deal->getKey(), $deals);

    session()->pull("deals.recently_viewed.{$index}");
}

session()->push('deals.recently_viewed', $deal->getKey());

You need to append a query string q to the url in pagination links

$posts = Post::where('title', 'like', $q = "%{$request->q}%")
    ->orWhere('description', 'like', $q)
    ->paginate(4)
    ->withQueryString();

Docs: https://laravel.com/docs/8.x/pagination#appending-query-string-values

Because you can see it here that it works.

In the service provider where you register your composer add this to register method

But it probably doesn't cause that problem.

/**
 * Register the application services.
 *
 * @return void
 */
public function register()
{
    $this->app->singleton(InterestedComposer::class);
}

And I guess you have to check existense of that id in deals.recently_viewed, if it exists there you have to remove it and add it to the end.

You don't have to mark me again. I saw it. If I knew an answer I would reply to you.

This should work

return $now->diffInDays($this->ends_at) . trans_choice('day|days', $now->diffInDays($this->ends_at));

This should work

return $now->diffInDays($this->ends_at) . trans_choice('day|days', $now->diffInDays($this->ends_at));

Check this out

https://laravel.com/docs/8.x/localization#pluralization

I recommend to you use template engine, for example Handlebars. Instead of concating html in js.

https://handlebarsjs.com/

Add ...$guards to the handle method in your middleware

public function handle(Request $request, Closure $next, ...$guards)
{
    // in $guards you have current guards
}

You have there an array, so it has to be like this

public function rules()
{
    return [
        'title.*' => 'required',
        'link.*' => 'required',
    ];
}

Docs: https://laravel.com/docs/8.x/validation#validating-arrays

Create your own helper.

https://laravel-news.com/creating-helpers

Where is a validation? Add it and you avoid this problems.

https://laravel.com/docs/8.x/validation

@devhoussam123 Why? You can't do it better.

@devhoussam123 I really don't know what you were thinking about when you had the correct answer in your question...

Just add nullable and required_without there.

'bannUntil' => 'nullable|required_without:permanentBan|date_format:d.m.Y H:i',
'permanentBan' => 'nullable|required_without:bannUntil|accepted',

@godzilaravel You need to add another join with alias name, because it's same table.

Certificate::select('certifications.*')
    ->join('users', 'users.id', '=', 'certifications.user_id')
    ->join('users as directors', 'directors.id', '=', 'users.director_id')
    ->orderBy('directors.first_name')
    ->get();

That's correct.

I would start with PHP journey and then go into Laravel journey

https://laracasts.com/skills/php

https://laracasts.com/skills/laravel

@godzilaravel You need to add another join with alias name, because it's same table.

Certificate::select('certifications.*')
    ->join('users', 'users.id', '=', 'certifications.user_id')
    ->join('users as directors', 'directors.id', '=', 'users.director_id')
    ->orderBy('directors.first_name')
    ->get();

It's same way, just use directory_id

$result = DB::table('table_name')->sum('star_value');

Just replace table_name with your table from database.

$result = DB::table('table_name')->sum('star_value');

Just replace table_name with your table from database.

You need to use joins for that

Certificate::select('certifications.*')
    ->join('users', 'users.id', '=', 'certifications.user_id')
    ->orderBy('users.first_name')
    ->get();

Docs: https://laravel.com/docs/8.x/queries#joins

For API I'd use Route::apiResource, it's without create and edit method.

Docs: https://laravel.com/docs/8.x/controllers#api-resource-routes

@sr57 What do you want to say with a link to another thread?

@vincej I would use ternary operator instead of if in checkbox.

<input type="checkbox" name="staff" value="1" {{ $child->staff ? 'checked' : '' }}>

I guess you need to do nested eager loading

https://laravel.com/docs/8.x/eloquent-relationships#nested-eager-loading

You don't know a loop variable?

https://laravel.com/docs/8.x/blade#the-loop-variable

And those queries are not related to the code you showed.

It has to be something else, because this code is correct.

public function index()
{
    $jobs = Job::with(['company', 'location',  'category', 'tags'])
        ->orderByDesc('updated_at')
        ->where('active', 1)
        ->paginate(15);

    return view('job.index', compact('jobs'));
}

@foreach ($jobs as $job)
    {{ $job->title }}

    {{ $job->company->name }}

    {{ $job->location->name }}
@endforeach

What do you have in job.index.blade.php

Because your main problem is locations table. And in your code is nothing with that table.

Seriously? How can we help you without code? Even in the OP you have different query...

How I said Those queries are not related to the code you showed.

That key is real video.

<iframe width="580" height="360" src="https://www.youtube.com/embed/QRfj1VCg16Y"></iframe>

So

<iframe width="580" height="360" src="https://www.youtube.com/embed/{{ $key }}"></iframe>

Where is a variable where you have code from youtube, use your variable.