PHP Function not return array or int

Asked Oct 25 '16 at 19:59

Active Oct 25 '16 at 20:05

Viewed 34 times

I have this function, but don't "return" any data;

function getCategoryParent($db,$id,$count = 12){
$parentID=0;
$inner = "";
for ($i=2; $i<=$count; $i++){
    $inner .=' INNER JOIN services_categories as x'.$i.' ON x'.$i.'.sc_id=x'.($i-1).'.sc_top_id ';
}
$sql='SELECT x'.$count.'.* FROM services_categories as x1 ' .$inner. ' WHERE x1.sc_id="'.$id.'" LIMIT 1';
$query=$db->query($sql,PDO::FETCH_ASSOC);
if($query->rowCount()){
    foreach ($query as $key) {
        $parentID=$key["sc_id"];
        return $parentID;

    }
}else{
    getCategoryParent($db,$id,$count-1);
} }

I want return sc_id or all query data. it's working with echo

edited Oct 25 '16 at 20:05

asked Oct 25 '16 at 19:59

Eren Özkul

From where are you calling this function ? "getCategoryParent" – Nandan Bhat Oct 25 '16 at 20:05
service single page $pid = getCategoryParent($db,$id); $query = $db->query("SELECT * FROM services_categories WHERE sc_id='$pid'",PDO::FETCH_ASSOC); – Eren Özkul Oct 25 '16 at 20:06
3

Have you tried putting "return getCategoryParent($db,$id,$count-1); " in the else case ? – Nandan Bhat Oct 25 '16 at 20:10
Thank @Nandan it's woking – Eren Özkul Oct 25 '16 at 20:14
you're doing recursion, but never bother returning the value returned by the recursive call... – Marc B Oct 25 '16 at 20:15
You are Welcome :) – Nandan Bhat Oct 25 '16 at 20:16
@ErenÖzkul you have logic error in your code – Mo Shal Oct 25 '16 at 20:18

PHP Function not return array or int

0 Answers0