mardi 17 juillet 2018

base table for dropdown list

I want to create a dropdown which loads data from database. I want to create dropdown with key and data as ID and BookName from books table. I followed the tutorial from https://www.youtube.com/watch?v=G_cMkETK330

Steps I've followed.

//created model
<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class AppDropdown extends Model
{
    protected $table = 'books';
}

then created provider

//created provider
<?php
namespace App\Providers;
use App\AppDropdown; // write model name here 
use Illuminate\Support\ServiceProvider;

class DynamicDDServiceProvider extends ServiceProvider
{
    public function boot()
    {
        view()->composer('*',function($view){
            $view->with('arrayname', AppDropdown::all());
        });
    }

}

then registered the provider in config/app.php

now in my view page ,

<select name="sel_bookID" id="sel_bookID" >
                                    @foreach ($arrayname as $data)                                       
                                        <option value=""></option>                                                      
                                    @endforeach
 </select>

But I am getting error as ::

 Illuminate \ Database \ QueryException (42S02)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lsapp.app_dropdowns' doesn't exist (SQL: select * from `app_dropdowns`)

How does the SQL query creating app_dropdowns as table? In model, I've mentioned the table name as books.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire