Laravel - 选择要在表格中显示的数据

Question

I want to ask if ever I can limit my data in table. I want to remove one data out of my 6 data.

here is my table

Now I want to remove number 3 row which is SESSION_VALIDITY how can I remove that data and make it just 5 data in my table? I want to limit my data coz' I dont need to view SESSION_VALIDITY. help thanks

my Index

 @foreach ($settings as $setting)
                <tr>
                    <td>{{ $setting->settings_code }}</td>
                    <td>{{ $setting->subject}}</td>
                    <td>{{ $setting->description }}</td>

                    <td><a href="/admin/settings/{{ $setting->id }}/edit" class="fa fa-edit btn btn-info"></a></td>
                </tr>      
                @endforeach

my Controller

 public function index()
{
    $settings = Setting::all();
    return view('admin.settings.index', compact('settings'));
}

Answer 1

If you just want to not show that row in your $settings data, you can exclude it using your query like this.

public function index()
{
    $settings = Setting::where('settings_code', '<>', 'SESSION_VALIDITY')->get();
    return view('admin.settings.index', compact('settings'));
}

If you want to delete it entirely, you can run a one-time function to delete that row from the table.

public function deleteSessionValidity()
{
    $setting = Setting::where('settings_code', 'SESSION_VALIDITY')->first();
    $setting->delete();
}