Merhabalar bir site hazırlıyorum. Sitenin kategori kısmında alt kategorileri sağ tarafta listeliyorum alt kategoriye tıklandığında
Kategori linki
http://localhost/site/helpfulinformation/endise
şeklinde bir link alt kategoriye tıkladığımda yandaki alt kategorilerin listesi aynı kalacak şekilde açıklama kısmını değiştiriyorum
Alt Kategori linki
http://localhost/site/helpfulinformation/endise/kaygi-bir-hastalikmi
şeklinde de alt kategori linki var helpfulinformation un controller dosyası
<?php
!defined("GRIDUNYA_CONTROL") ? die("Hacking ?") : null;
class Helpfulinformation
{
public function index($getData = [])
{
$model = model('helpfulinformationmodel');
if (count($getData) > 0) {
if(isset($getData[0])){
$mainCat = $model->getHelpfulinformation($getData[0]);
if($mainCat){
$mainCatUrl = $mainCat->helpfulinformation_url;
$mainCatTitle = $mainCat->helpfulinformation_title;
$mainCatId = $mainCat->helpfulinformation_id;
$getHelpfulinformationReading = $model->getHelpfulinformationReading($mainCatId);
}else{
view('404');
}
}
if (isset($getData[0]) && !isset($getData[1])) {
$data = (object) [];
$data->title = $mainCat->helpfulinformation_title;
$data->keyw = $mainCat->helpfulinformation_keyw;
$data->desc = $mainCat->helpfulinformation_desc;
$data->h1 = $mainCat->helpfulinformation_title;
$getHelpfulinformationSidebar = $model->getHelpfulinformationSidebar($mainCat->helpfulinformation_id);
$mainCat->sidebar = $getHelpfulinformationSidebar;
$mainCat->url0 = $mainCatUrl;
$mainCat->title0 = $mainCatTitle;
$mainCat->readings = $getHelpfulinformationReading;
view('frontend/inc/header', $data);
view('frontend/helpfulinformation', $mainCat);
view('frontend/inc/footer');
}else{
view('404');
}
if(isset($getData[0]) && isset($getData[1])){
$getHelpfulinformation = $model->getHelpfulinformation($getData[1]);
if ($getHelpfulinformation) {
$data = (object) [];
$data->title = $getHelpfulinformation->helpfulinformation_title;
$data->keyw = $getHelpfulinformation->helpfulinformation_keyw;
$data->desc = $getHelpfulinformation->helpfulinformation_desc;
$data->h1 = $getHelpfulinformation->helpfulinformation_title;
$getHelpfulinformationSidebar = $model->getHelpfulinformationSidebar($getHelpfulinformation->helpfulinformation_cat);
$getHelpfulinformation->sidebar = $getHelpfulinformationSidebar;
$getHelpfulinformation->url0 = $mainCatUrl;
$getHelpfulinformation->title0 = $mainCatTitle;
$getHelpfulinformation->readings = $getHelpfulinformationReading;
view('frontend/inc/header', $data);
view('frontend/helpfulinformation', $getHelpfulinformation);
view('frontend/inc/footer');
} else {
view('404');
}
}else{
view('404');
}
}
}
}ayrıca helpfulinformation un model dosyası
<?php
class Helpfulinformationmodel extends Database{
public function getHelpfulinformation($url){
$query = "SELECT * FROM helpfulinformation_tbl WHERE helpfulinformation_url = ?";
$data = $this->getRow($query,array($url));
return $data;
}
public function getHelpfulinformationSidebar($cat){
$query = "SELECT * FROM helpfulinformation_tbl WHERE helpfulinformation_cat = ?";
$data = $this->getRows($query,array($cat));
return $data;
}
public function getHelpfulinformationReading($id){
$query = "SELECT readings_tbl.*, user_tbl.user_page_url FROM readings_tbl
INNER JOIN user_tbl ON readings_tbl.readings_user_id = user_tbl.user_id
WHERE readings_helpfulinformation_id = ?";
$data = $this->getRows($query,array($id));
return $data;
}
}bu şekilde yazdım hiç içime sinmiyor geleneksel sözümüz olan çalışıyorsa karışmayı mı uyguluyayım

veya
daha mantıklı bir çözüm önerisi olan var mı.
Teşekürler..