Scope of variable in php

Question

i have following simple class with static method in php which check if record exist then return the record otherwise return false

  class db{

      public static function isRecord($q,$parameters){  
        $a=self::getinstance()->prepare($q);
        $a->execute($parameters);
        $r=$a->fetch(PDO::FETCH_NUM);
        if($r[0]) return $r[0]; 
        if(!$r[0] || $r[0]==0 ) return false;
     }
  }

usage

  $e=db::isRecord("SELECT itemdesc FROM temptable WHERE invuser=? ",array($invuser));

returns $e as expected.

but if i use with in simple function like this

function canEnterincart(){
    return db::isRecord("SELECT itemdesc FROM temptable WHERE invuser=? ",array($invuser));
}

var_dump(canEnterincart()) always return false even if the record exist.

Is this something wrong with the code?

Where do you think `$invuser` is coming from inside that function? — deceze, Mar 23 '14 at 08:31
Good one I was about to ask the same the array($invuser) inside the function canEnterincart() will be empty if this is the same code being used and hence query will fail. — Abhik Chakraborty, Mar 23 '14 at 08:33
@deceze it is defined out of the function, Ohh seems like you pointed out one issue — Muhammad Haseeb Khan, Mar 23 '14 at 08:33
stackoverflow is always helpful even in case of such stupidities. thank you all — Muhammad Haseeb Khan, Mar 23 '14 at 08:35

score 0 · Accepted Answer · answered May 29 '14 at 19:46

0

You should pass the variable as a parameter of the method, like this:

function canEnterincart($invuser){
    return db::isRecord("SELECT itemdesc FROM temptable WHERE invuser=? ",array($invuser));
}

answered May 29 '14 at 19:46

clami219

2,958
1
31
45

Scope of variable in php

1 Answers1