Tuto's Laravel Corner•3y ago

n+1

public function index(Request $request)
{
$search_query = $request->get('search');

$nebulizations = Nebulization::query();

if ($search_query){
$nebulizations->search($search_query);
}

$nebulizations = $nebulizations->with(['patient','nurse','medicineNebulizations'])->latest()->paginate(10)->withQueryString();

return view('nebulizations.index', compact('nebulizations'));
}

this gives me 10queries, and it takes 1s to load a single record. the medicine relations are coming from MedicineNebulization

tuto1902

T

tuto1902•10/6/23, 3:36 PM

can you share the @foreach on the template?

shaan

S

shaanOP•10/6/23, 8:55 PM

Now the problem solved. But got more.

shaan

S

shaanOP•10/6/23, 8:55 PM

shaan

S

shaanOP•10/6/23, 8:56 PM

shaan

S

shaanOP•10/6/23, 8:56 PM

, how to load the old values from a dynamic input fields? here is the code.

tuto1902

T

tuto1902•10/7/23, 12:52 AM

I think I already replied to this one but again, you can use to render the old value from a field. Is not loading the value?

shaan

S

shaanOP•10/7/23, 2:48 AM

Not working

shaan

S

shaanOP•10/7/23, 4:37 AM

@foreach($nebulization->medicineNebulizations as $medicine_used)
<tr>
<td class="pl-4 w-[45%] py-2">
<select id="medicine"
name="medicine[]"
class="font-thin text-sm w-full p-2 border border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
@foreach( $medicines as $medicine )
<option value="{{ $medicine->id }}" @selected($medicine_used->id == $medicine->id)>{{ $medicine->name }}</option>
@endforeach
</select>
</td>
<td class="pl-4 w-[45%] py-2">
<input type="text" name="amount[]" value="{{ $medicine_used->amount }}"
placeholder="eg: 5m l, 3 gm, 5 ltr"
class="font-thin text-sm w-full p-2 border border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
</td>

shaan

S

shaanOP•10/7/23, 4:38 AM

This is the edit form

shaan

S

shaanOP•10/7/23, 4:38 AM

Its loading the amount correct

shaan

S

shaanOP•10/7/23, 4:38 AM

But the medicine

shaan

S

shaanOP•10/7/23, 4:38 AM

tuto1902

T

tuto1902•10/11/23, 4:43 PM

Can you share the definition of the Nebulization model class? I want to take a peek into the relationship names. Also, you can use three backticks (`) and the language name to share code with proper highlight, like this

   var tr = `<tr class="pb-4">
                <td class="pl-4 w-[45%] py-2">
                <select id="medicine"
                name="medicine[]"
                class="font-thin text-sm w-full p-2 border border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
                        <option value="[]" selected disabled>Select a medicine</option>
                        @foreach( $medicines as $medicine )
                            <option value="{{ $medicine->id }}" {{ old("medicine.0") == $medicine->id ? 'selected' : '' }}> {{ $medicine->name }}</option>
                        @endforeach
                </select>
                </td>
                <td class="pl-4 w-[45%] py-2">
                        <input type="text" name="amount[]" placeholder="eg: 5m l, 3 gm, 5 ltr"  value="{{ old("amount.0") }}"  class="font-thin text-sm w-full p-2 border rounded border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm"></td>
                 <td>
                     <a href="javascript:void(0)" id="deleteRow"
                        class="">
                         <svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-circle-minus text-rose-600" width="25" height="25" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
                             <path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
                             <path d="M12 12m-9 0a9 9 0 1 0 18 0a9 9 0 1 0 -18 0"></path>
                             <path d="M9 12l6 0"></path>
                         </svg>
                     </a>
                 </td>
                </tr>`;

   var tr = `<tr class="pb-4">
                <td class="pl-4 w-[45%] py-2">
                <select id="medicine"
                name="medicine[]"
                class="font-thin text-sm w-full p-2 border border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
                        <option value="[]" selected disabled>Select a medicine</option>
                        @foreach( $medicines as $medicine )
                            <option value="{{ $medicine->id }}" {{ old("medicine.0") == $medicine->id ? 'selected' : '' }}> {{ $medicine->name }}</option>
                        @endforeach
                </select>
                </td>
                <td class="pl-4 w-[45%] py-2">
                        <input type="text" name="amount[]" placeholder="eg: 5m l, 3 gm, 5 ltr"  value="{{ old("amount.0") }}"  class="font-thin text-sm w-full p-2 border rounded border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm"></td>
                 <td>
                     <a href="javascript:void(0)" id="deleteRow"
                        class="">
                         <svg xmlns="http://www.w3.org/2000/svg" class="icon icon-tabler icon-tabler-circle-minus text-rose-600" width="25" height="25" viewBox="0 0 24 24" stroke-width="2" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round">
                             <path stroke="none" d="M0 0h24v24H0z" fill="none"></path>
                             <path d="M12 12m-9 0a9 9 0 1 0 18 0a9 9 0 1 0 -18 0"></path>
                             <path d="M9 12l6 0"></path>
                         </svg>
                     </a>
                 </td>
                </tr>`;

```php
 <tbody class="pb-8 pl-4">
                            <tr>
                                <td class="pl-4 w-[45%] py-2">
                                    <select id="medicine"
                                            name="medicine[]"
                                            class="font-thin text-sm w-full p-2 border border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
                                        <option value="" selected disabled>Select a medicine</option>

                                        @foreach( $medicines as $medicine )
                                            <option
                                                value="{{ $medicine->id }}"  {{ old("medicine.0") == $medicine->id ? 'selected' : '' }}>{{ $medicine->name }}</option>
                                        @endforeach
                                    </select>
                                </td>
                                <td class="pl-4 w-[45%] py-2">
                                    <input type="text" name="amount[]" placeholder="eg: 5m l, 3 gm, 5 ltr"
                                           value="{{ old("amount.0") }}"
                                           class="font-thin text-sm w-full p-2 border  border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
                                </td>
                                <td class="pl-4">
                                </td>
                            </tr>

                        </tbody>

```php
 <tbody class="pb-8 pl-4">
                            <tr>
                                <td class="pl-4 w-[45%] py-2">
                                    <select id="medicine"
                                            name="medicine[]"
                                            class="font-thin text-sm w-full p-2 border border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
                                        <option value="" selected disabled>Select a medicine</option>

                                        @foreach( $medicines as $medicine )
                                            <option
                                                value="{{ $medicine->id }}"  {{ old("medicine.0") == $medicine->id ? 'selected' : '' }}>{{ $medicine->name }}</option>
                                        @endforeach
                                    </select>
                                </td>
                                <td class="pl-4 w-[45%] py-2">
                                    <input type="text" name="amount[]" placeholder="eg: 5m l, 3 gm, 5 ltr"
                                           value="{{ old("amount.0") }}"
                                           class="font-thin text-sm w-full p-2 border  border-gray-200 focus:border-indigo-500 focus:ring-indigo-500 rounded-md shadow-sm">
                                </td>
                                <td class="pl-4">
                                </td>
                            </tr>

                        </tbody>