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