View all";
$linkProd.=!empty($_SESSION[mainstyle])? "&mn=".$_SESSION[mainstyle]:"";
$ncat= $_GET['catid'] ;
$sqltxt=$conn->query("select c.th_name as catTh, c.en_name as catEn from category c where c.catid=".$ncat);
if($sqltxt && $sqltxt->num_rows>0){
$n=$sqltxt->fetch_array();
$linkProd.=isset($_GET['catid'])? "&catid=".$ncat : "";
$navTitle=(!empty($ncat) && $_SESSION['lang']=='en')? $n['catEn']:$n['catTh'];
$navi.=" ".$navTitle."";
}
$nicat=$_GET['subid'] ;
$sqltxt=$conn->query("select c.th_name as catTh, c.en_name as catEn from sub_category c where c.subid=".$nicat);
if($sqltxt && $sqltxt->num_rows>0){
$n[icat]=$sqltxt->fetch_array();
$linkProd.=isset($_GET['subid'])? "&subid=".$nicat : "";
$navTitle=(!empty($nicat) && $_SESSION['lang']=='en')? $n['icat']['catEn'] : $n['icat']['catTh'];
$navi.=" ".$navTitle."";
}
/*$nicat2=$_GET['sub2id'];
$sqltxt=$conn->query("select c.th_name as catTh, c.en_name as catEn from sub_category2 c where c.sub2id=".$nicat2);
if($sqltxt && $sqltxt->num_rows>0){
$n[icat2]=$sqltxt->fetch_array();
$linkProd.=isset($_GET['sub2id'])? "&sub2id=".$nicat2 : "";
$sty=" style='font-size:13px;font-family:tahoma;' class='link_w' ";
$navTitle=(!empty($nicat2) && $_SESSION['lang']=='en')? $n['icat2']['catEn'] : $n['icat2']['catTh'];
$navi.=" -> ".$navTitle."";
}*/
$nid=(isset($_GET['id']))? $_GET['id']:"";
$strtxt.="select p.itemcode,p.modelcode, p.nameTh, p.nameEn, p.titleTh, p.titleEn, p.yeeho_id, y.th_name as th_yeeho, y.en_name as en_yeeho
, c.catid, c.th_name as catTh, c.en_name as catEn, s.subid, s.th_name as subTh, s.en_name as subEn
from products p
left join category c on p.category_id=c.catid
left join sub_category s on p.subcate_id=s.subid
left join yeeho y on p.yeeho_id=y.catid
where p.id=".$nid;
$sqltxt=$conn->query($strtxt);
if($sqltxt && $sqltxt->num_rows>0){
$n=$sqltxt->fetch_array();
$CatTitle=($_SESSION['lang']=='en')? $n[catEn]:$n[catTh];
$SubTitle=($_SESSION['lang']=='en')? $n[subEn]:$n[subTh];
$YeeTitle=($_SESSION['lang']=='en')? $n[th_yeeho]:$n[en_yeeho];
$ProTitle=($_SESSION['lang']=='en')? strip_tags($n[nameEn]):strip_tags($n[nameTh]);
$linkProd.=isset($n[yeeho_id])? "&yeeho=".$n[yeeho_id] : "";
$navi.=(!empty($n[th_yeeho]))? " ".$YeeTitle."":"";
$navi.=(!empty($n[itemcode]))? " ".$n['itemcode']:"" ;
}
$yeehoid=isset($_GET['yeeho'])? $_GET['yeeho']:0;
if(!empty($yeehoid) && empty($nid)){
$yqry=$conn->query("select catid, th_name, en_name from yeeho where catid=".$yeehoid);
if($yqry && $yqry->num_rows>0){
list($yid, $yth_name, $yen_name)=$yqry->fetch_array();
$YeehoTitle=($_SESSION['lang']=='en')? $yen_name:$yth_name;
$linkProd.=isset($yid)? "&yeeho=".$yid : "";
$navi.=!empty($navi)? " ":"";
$navi.=(!empty($yid) && $yid>0)? "".$YeehoTitle."":"" ;
}
}
$titleAllproduct=($_SESSION['lang']=='th')? "สินค้าทั้งหมด":"All Products";
$titleAllproduct="".$titleAllproduct."";
$navi=empty($navi)? $titleAllproduct:$navi;
$navi=(!empty($srcProd))?"Results: ".$srcProd."":$navi;
?>
Fatal error: Uncaught Error: Call to undefined function TitleBarPage() in /var/www/vhosts/psbedding.co.th/www/products.php:127
Stack trace:
#0 {main}
thrown in /var/www/vhosts/psbedding.co.th/www/products.php on line 127