I'm trying to build an application on Laravel 5.3 where my models, database and controllers are in separate folders. I have the following folder structure:
Nitseditor
System
Controllers
Database
2016_12_28_130149_create_domains_table.php
2017_01_06_193355_create_themes_table.php
2017_01_07_140804_create_themes_domains_table.php
Models
Domain.php
Theme.php
I'm making a relationship in domain with many to many relationship i.e.
public function themes()
{
return $this->belongsToMany('Nitseditor\System\Models\Domain');
}
I've named the table domain_theme inside the 2017_01_07_140804_create_themes_domains_table.php
Now I'm trying to get the theme name which belongs to the domain in the controller something like this:
$flashmesage = new Domain;
foreach ($flashmesage->themes as $theme)
{
return $theme->theme_name;
}
I'm getting an error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nitswebbuilder.domain_domain' doesn't exist (SQL: select
domains.*,domain_domain.domain_idaspivot_domain_idfromdomainsinner joindomain_domainondomains.id=domain_domain.domain_idwheredomain_domain.domain_idis null anddomains.deleted_atis null)
sorry for my short comment as answer... I have not enough reputation for comment,
change your themes() method to :
public function themes()
{
return $this->belongsToMany('Nitseditor\System\Models\Theme');
}
see Here for more info
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments