MichalOravec

It should be

$results = Wantad::where('price', '<=', 20000)->get();

Docs: https://laravel.com/docs/7.x/eloquent#retrieving-models

Use conditional clauses

Docs: https://laravel.com/docs/7.x/queries#conditional-clauses

Thrown your project to the trash and start again. And don't ask why, because it's obvious.

$this->trips()->whereNotNull('date_to')->where('date_to', '<=', Carbon::parse($date)->toDateString())->get();

@ethar Same way how you do it before.

Orders::with(['users:id,fname,lname,telno', 'products', 'admins', 'address.city'])

I do it just for users. So you can see that it's same.

@ethar You can read this for example https://phptherightway.com/

But in your case model should be in singular form.

Why your method is orderssearch for me would be better if it's just search method in OrdersController.

Next you have $request->product but actually it's just type of order DESC or ASC, so why you named it product?

View is admin.orders.indexorder why not just admin.orders.index or at least admin.orders.index-order with dash, because it's unreadble. Or if would be in search method then admin.orders.search.

@neeraj1005 If you have model for tbl_contacts use model. It's not necessary to do it in that way.

@neeraj1005 No they are same.

public function orderssearch(Request $request)
{
    $orders = Orders::with(['users', 'products', 'admins', 'address.city'])
        ->select('orders.*')
        ->join('products', 'products.id', '=', 'orders.products_id')
        ->when($request->product, function ($query, $by) {
            return $query->orderBy('products.num_sell', $by == 'sell_asc' ? 'asc' : 'desc');
        }, function ($query) {
            return $query->orderByDesc('orders.id');
        })->paginate(10);

    return view('admin.orders.indexorder', compact('orders'));
}

Docs: https://laravel.com/docs/7.x/queries#conditional-clauses

* But your naming of variables, models etc. is not good.

When you work with DB::tableyou get collection of stdClass instead of model.

So change it to this

$contacts = Tbl_contacts::where('active',1)->where(function ($query) {
    $query->where('uid', Auth::user()->id)->orWhere('uid',0);
})->get();

You can add this to your model

protected $withCount = ['favorites'];

You can add this to your model

protected $withCount = ['favorites'];

Use session for that

public function store(CheckoutRequest $request)
{
    // other code

    $request->session()->put('customerId', $customer->id);

    // other code
}

public function paymentDetails(Request $request)
{
    if ($request->session()->has('customerId')) {
        $customerId = $request->session()->get('customerId');
    }
}

Docs: https://laravel.com/docs/7.x/session

@mikegk It's almost same as this

https://laracasts.com/discuss/channels/laravel/how-to-deal-with-hashmakemd5password?page=1#reply=619442

@Camo It could be just

public function handle($request, Closure $next)
{
    $response = $next($request);

    $response->header('Access-Control-Allow-Origin', '*');

    return $response;
}

so without set

@j0wz The other way is doing it like this

$holding = Holding::create(['reference' => Str::uuid()]);

$user = $holding->users()->create([
    'firstname' => 'John',
    'lastname' => 'Doe',
    'email' => '[email protected]',
    'password' => bcrypt('password')
]);

@s4muel It would be work if he has hasMany relationship, but it's belongsTo.

@mubeenali Do you have some problem with spacebar?!

Look on this

https://laravel.com/docs/7.x/eloquent-relationships#updating-belongs-to-relationships

$user = User::create([
    'firstname' => 'John',
    'lastname' => 'Doe',
    'email' => '[email protected]',
    'password' => bcrypt('password')
]);

$holding = Holding::create(['reference' => Str::uuid()]);

$user->holding()->associate($holding);

$user->save();

You have two parameters which are required in your route.

<a href="{{ route('bank.edit_form', ['bank_name' => $bankname, 'bank_id' => $bank[0]['bankId']]) }}" >{{ $bankname }}<a>

Actually I don't know where you store your bank_name and bank_id in which variable.

You <select> should have multiple attribute

For example

<select name="pets" multiple>
    <option value="dog">Dog</option>
    <option value="cat">Cat</option>
</select>

Documentation: https://developer.mozilla.org/en-US/docs/Web/HTML/Element/select

<div class="form-group">
    <label for="campaign_provider">Client: </label>
    
    <select class="form-control" id="campaign_provider" name="campaign_provider" multiple disabled>
        @foreach($banks as $bank)
            <option value="{{ $bank['bank_id'] }}" {{ $campaign->contains('bank_id', $bank['bank_id'] ? 'selected="selected"' : '' }}
                {{ $bank['name'] }}
            </option>
        @endforeach
    </select>
</div>

For select multiple values you can use contains from collection.

Documentation: https://laravel.com/docs/7.x/collections#method-contains

In controller filter only for those units

$units = $units->filter(function ($item) {
    return in_array($item->unit, ['g', 'kg']);
});

Docs: https://laravel.com/docs/7.x/collections#method-filter

Remove your part in @php instead of use this

<option value="{{ $unit->unit }}" {{ $unit->unit == old('weight_unit') ? 'selected' : '' }}>{{$unit->unit}}</option>

Not response() but request()

if (request()->wantsJson()) {
    //
}

And wantsJson() not wantJson(), you miss s there.

I don't know what you have in $img->image->first()->url but it should be something like this

<img src="{{ asset('storage/'.$img->image->first()->url) }}">

use Illuminate\Validation\Rule;

$clientId; // your actual client id

$this->validate($request, [
    'email' => ['required', 'email', Rule::unique('customers')->where(function ($query) use ($clientId) {
        $query->where('client_id', $cliendId);
    })]
]);

Docs: https://laravel.com/docs/7.x/validation#rule-unique (look for Adding Additional Where Clauses)

Yes of course. But you can do what I posted before.

@nickywan123 You have belongsTo relationship for creator. So count is everytime just one for creator.

use Illuminate\Validation\Rule;

$clientId; // your actual client id

$this->validate($request, [
    'email' => ['required', 'email', Rule::unique('customers')->where(function ($query) use ($clientId) {
        $query->where('client_id', $cliendId);
    })]
]);

Docs: https://laravel.com/docs/7.x/validation#rule-unique (look for Adding Additional Where Clauses)

@nickywan123 You need to do something like this

$thread = Thread::with(['creator', 'replies' => function ($query) {
    $query->latest();
}])->withCount('replies')->get();

{{ $thread->creator->name }}

@if ($thread->replies->isNotEmpty())
    @foreach ($thread->replies as $reply)
        <!-- show reply -->
    @endforeach
@endif

$thread->replies() and this $thread->creator() return query builder which you have to finish with get(), first() etc. to retrieve data from the database.

Your example should be

foreach($thread->replies()->get() as $reply)

Here you work with query builder

$thread->replies()->count();

but here with collection

$thread->replies->count();

Same here this return query builder

$thread->creator()

but this return a relationship

$thread->creator

https://laravel.com/docs/7.x/eloquent-relationships#relationship-methods-vs-dynamic-properties

I recommend to you use this package

https://github.com/mcamara/laravel-localization

$reply->favorites()->delete();

$reply->delete();

Or if you want to run some events then

$reply->favorites->each->delete();

$reply->delete();

$reply->favorites()->delete();

$reply->delete();

Or if you want to run some events then

$reply->favorites->each->delete();

$reply->delete();

@sinnbeck Yes of course :)

Add this to your ForgotPasswordController

use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;

/**
 * Get the response for a successful password reset link.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  string  $response
 * @return \Illuminate\Http\RedirectResponse|\Illuminate\Http\JsonResponse
 */
protected function sendResetLinkResponse(Request $request, $response)
{
    // flash message or whatever here

    return $request->wantsJson()
                ? new JsonResponse(['message' => trans($response)], 200)
                : back()->with('status', trans($response));
}

var oldValue = 'https://nl.wikipedia.org/wiki/Republikeinwever';

var newValue = oldValue.replace('wikipedia', 'm.wikipedia');

$configuration = json_decode(shop()->setting->whatsapp_configuration, true)->send_message_via ?? null;

Then just use if statement.

In html

<div class="p-rating">
    <a data-value="1" class="btn RatingAjax1">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="2" class="btn RatingAjax2">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="3" class="btn RatingAjax3">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="4" class="btn RatingAjax4">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="5" class="btn RatingAjax5">
        <i class="fa fa-star-o fa-fade"></i>
    </a>
</div>

In js

$(function() {
    $(document).on('click', '.p-rating a', function(e) {
        e.preventDefault();

        var el = $(this);

        var value = el.data('value');

        alert(value);
    });
});

And then you get exact value.

In html

<div class="p-rating">
    <a data-value="1" class="btn RatingAjax1">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="2" class="btn RatingAjax2">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="3" class="btn RatingAjax3">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="4" class="btn RatingAjax4">
        <i class="fa fa-star-o"></i>
    </a>
    
    <a data-value="5" class="btn RatingAjax5">
        <i class="fa fa-star-o fa-fade"></i>
    </a>
</div>

In js

$(function() {
    $(document).on('click', '.p-rating a', function(e) {
        e.preventDefault();

        var el = $(this);

        var value = el.data('value');

        alert(value);
    });
});

And then you get exact value.

@mallaury Try it like this

$departmentLessons = auth()->user()->myDepartmentLessons()->with(['lesson' => function ($query) {
    $query->withCount('documents');
}])->get();

@mallaury Please consider marking the Best Reply above if your issue has been solved.

@mallaury Try it like this

$departmentLessons = auth()->user()->myDepartmentLessons()->with(['lesson' => function ($query) {
    $query->withCount('documents');
}])->get();

When you add this macro to your AppServiceProvider

use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Collection;

Collection::macro('paginate', function ($perPage, $total = null, $page = null, $pageName = 'page') {
    $page = $page ?: LengthAwarePaginator::resolveCurrentPage($pageName);

    return new LengthAwarePaginator($this->forPage($page, $perPage), $total ?: $this->count(), $perPage, $page, [
        'path' => LengthAwarePaginator::resolveCurrentPath(),
        'pageName' => $pageName,
    ]);
});

Then you can paginate on the collection.

You can use partials view there, for example

->editColumn('some-column', function ($item) {
    return view('partials.datatable.link', [
        'link' => route('some-route'),
        'text' => $iten->text
    ]);
})

View in views/partials/datatable/link.blade.php

<a href="{{ $link }}" target="{{ $target ?? '_self' }}">{{ $text }}</a>

@wahidulalam Maybe this could help to you

https://stackoverflow.com/questions/204765/elegant-way-to-search-for-utf-8-files-with-bom

@wahidulalam Which editor do you use?

If you have Sublime Text there you can save file just with UTF-8 without BOM.

And also you can search there with regular expression where you can put this

\s+<\?php

and it will search for all spaces before <?php

In toolbar Find -> Find in Files

https://www.youtube.com/watch?v=b0m_opKVpa8

Probably problem will be with UTF-8 with BOM. You have to save your files withou BOM.

Or check if you don't have space before <?php in your app.

It has to be on the first line of each php file without space there.

Yes, I so it. It looks like your server is really slow.

Also try to set your app to production.

Which version of Laravel do you use?

Or you don't use any middleware or package? Or you have something in the js?

Or you have set something wrong in the Apache server.

I tried this on windows 10 with browser chrome 84 and it works without showing that message.

public function index(Request $request)
{
    return redirect()->away('https://www.google.com');
}

So it's probably behaviour on the mobile phone. On pc or mac your don't see that message.

Which means you can't change it with code.