|
Server IP : 103.53.40.154 / Your IP : 3.145.34.51 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/ppcad7no/parthaquafresh.com/includes/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$id_array=array();
function has_child($catid){
$sql="SELECT COUNT(category_id) FROM tbl_category WHERE 1 AND category_parent_id='$catid' AND category_status='Active' AND category_for_stock='No' ";
$count=db_scalar($sql);
if($count>0){
return true;
}else{
return false;
}
}
function getIds($catid){
$sql="SELECT category_id FROM tbl_category WHERE 1 AND category_parent_id='$catid' AND category_status='Active' AND category_for_stock='No' ";
$data_ids=db_query($sql);
while($rec_ids=mysqli_fetch_array($data_ids)){
if(has_child($rec_ids['category_id'])){
$id_array[]=getIds($rec_ids['category_id']);
}else{
$id_array[]=$rec_ids['category_id'];
}
}
return @implode(",",$id_array);
}
?>