Asynchronous query to load products from laravel controller
Your example:

public function ajax(Request $request){ 
$data['products'] = Product::select('products.id', 'products.name', 'products.banner')-&gt;get();

foreach ($data['products'] as $product){
    echo $product-&gt;name;
}


Attn: I omit commented string.

You do not need to get the query results into $data, especially if before you perform $data = $request-&gt;all();. Use another variable, in this case the $products may be okay.

If your 'Product' model is correct, then in the query you not need to use products.id - i.e. table name, need just field name.

Next, when you want pass the result to view, you need to do so as described in Doc:

return view('your_view_name', ['products' =&gt; $products]);

As described in official documentation  - versions there are from 5.0 up to 5.8, choose any you need.

So, this part of your code becomes:

public function ajax(Request $request){ 
    $products = Product::select('id', 'name', 'banner')-&gt;get();
    return view('your_view_name', ['products' =&gt; $products]);
}


Remember 2 things: 


With that query you'll get all products from DB and there may be a huge number of results.
the view has to be a blade type of template.


In your 'view' I see this line:

@foreach($leedManufacturers as $leedsManufacturer)

but I do not see a variable $leedManufacturers in the controller so you have no data for it.

To show $products result use the same but for $products, like:

&lt;ol&gt;
    @foreach($products as $product)
        &lt;li&gt;
            &lt;div&gt;id: {{$product-&gt;id}}, name: {{$product-&gt;name}}&lt;/div&gt;
            &lt;div&gt;{{$product-&gt;banner}}&lt;/div&gt;
        &lt;/li&gt;
    @endforeach
&lt;/ol&gt;


Also, when you need , you may use this (example)

@if (xxxxxxxxx === 1)
    I have one record!
@elseif (yyyyyyyyyy &gt; 1)
    I have multiple records!
@else
    I don't have any records!
@endif


https://laravel.com/docs/5.3/blade#if-statements

And in view you can use even

@php
    pure php code here
@endphp