Laravel & sql project help

[isurutmv]

mekayi mcn seen eka database eke table tikak thiyenawa me widihata

• distric
• distric-town
• ads
• ads-catagory

meke distric kiyana table eke thiyenne distric_id & distric_name


meke distric-town kiyana table eke thiyenne distric_id,town_id,town_name


ads kiyana table eke ad_id,ad_name,.....,town_id kiyala thiyenawa


ads_category eke ad_id,category_id,category_name kiyala thiyenawa


ethakota mcn man hadana app eke user select karanne distric eka user distric eka select karama ee distric ekata adala town tika distric_town table eken aragena ee town walata adaala ads tika ads table eken filter karala ganna oone ieetapasse ee filter wela ena ads tiken category_id=5567 wechcha ads tika witharak filter karala userta pennanna oone


man danata meka karala thiyenne me widihata bn


distric model

class district extends Model
{    
protected $table = 'district';

    public function area_list()
   {     
  return $this->hasMany(district_town::class);
   }
}

distric_town model

class district_town extends Model
{   
 protected $table = 'district_town';

    public function district()  
  {       
 return $this->belongsTo(district::class);
    }
    public function ads()  
  {      
  return $this->hasMany(ads::class, 'town_id', 'id');
    }

}

ads_catagory model

class ads_category extends Model
{        
protected $table = 'ads_category';

            public function ads() 
  {     
  return $this->hasMany(ads::class,'ad_id','ad_id'); 
  }
}

ads model

class ads extends Model
{    
protected $table = 'ads';   
 protected $primaryKey = 'ad_id';     
public $incrementing = false;

        public function ads_category()   
 { 
 return $this->hasMany(ads_category::class,'ad_id','ad_id'); 
   }
    public function area_list()   
 {       
 return $this->belongsTo(area_list::class, 'id', 'business_city_id'); 
   }
}

controller eka

public function distric($id) 
   {      
  $distric = district::find($id);             
   return view('ads',compact('distric'));
    }

view eka

foreach($distric->distric_town as $distric_town)   
 {
 foreach($distric_town->ads as $ads)        
    {        
foreach($ads->ads_category as $ads_category)   
                 {        
 if($ads_category->sub_category_id == '557057')   
                         {
                                //display ads

                                                            }    
                } 
           }
    }

meken mata oone wade wenawa bn eeth me widiata loop thunak yana eka sahenna awul meka me widihata nathuwa karanna wena widihak nadda bn

 

[nuwan91]

join dala ganin

 

[nimesha95]

mekayi mcn seen eka database eke table tikak thiyenawa me widihata

• distric
• distric-town
• ads
• ads-catagory

meke distric kiyana table eke thiyenne distric_id & distric_name


meke distric-town kiyana table eke thiyenne distric_id,town_id,town_name


ads kiyana table eke ad_id,ad_name,.....,town_id kiyala thiyenawa


ads_category eke ad_id,category_id,category_name kiyala thiyenawa


ethakota mcn man hadana app eke user select karanne distric eka user distric eka select karama ee distric ekata adala town tika distric_town table eken aragena ee town walata adaala ads tika ads table eken filter karala ganna oone ieetapasse ee filter wela ena ads tiken category_id=5567 wechcha ads tika witharak filter karala userta pennanna oone


man danata meka karala thiyenne me widihata bn


distric model

class district extends Model
{    
protected $table = 'district';

    public function area_list()
   {     
  return $this->hasMany(district_town::class);
   }
}

distric_town model

class district_town extends Model
{   
 protected $table = 'district_town';

    public function district()  
  {       
 return $this->belongsTo(district::class);
    }
    public function ads()  
  {      
  return $this->hasMany(ads::class, 'town_id', 'id');
    }

}

ads_catagory model

class ads_category extends Model
{        
protected $table = 'ads_category';

            public function ads() 
  {     
  return $this->hasMany(ads::class,'ad_id','ad_id'); 
  }
}

ads model

class ads extends Model
{    
protected $table = 'ads';   
 protected $primaryKey = 'ad_id';     
public $incrementing = false;

        public function ads_category()   
 { 
 return $this->hasMany(ads_category::class,'ad_id','ad_id'); 
   }
    public function area_list()   
 {       
 return $this->belongsTo(area_list::class, 'id', 'business_city_id'); 
   }
}

controller eka

public function distric($id) 
   {      
  $distric = district::find($id);             
   return view('ads',compact('distric'));
    }

view eka

foreach($distric->distric_town as $distric_town)   
 {
 foreach($distric_town->ads as $ads)        
    {        
foreach($ads->ads_category as $ads_category)   
                 {        
 if($ads_category->sub_category_id == '557057')   
                         {
                                //display ads

                                                            }    
                } 
           }
    }

meken mata oone wade wenawa bn eeth me widiata loop thunak yana eka sahenna awul meka me widihata nathuwa karanna wena widihak nadda bn

machan oya $distric kiyana ekata dd ekak deela balanna. Array ekak ne enne, ethanin direct elements (index eken) access karla eka loop ekakin monahari karaganan puluwan wei. Dan nam wela na, welawak tibboth balannam.

 

[isurutmv]

machan oya $distric kiyana ekata dd ekak deela balanna. Array ekak ne enne, ethanin direct elements (index eken) access karla eka loop ekakin monahari karaganan puluwan wei. Dan nam wela na, welawak tibboth balannam.

dd ekak dala baluwa mcn array eke enne distric_id & name eka witharayi attributes widihata ieeta amatharawa relations tika enawa