Calling Array from class PHP

Question

So I'm trying to call an array which is generated from a database, here is the function in the class file:

public function select($array) 
{
   try 
   {
       $result ="SELECT id,make,model FROM cars";

       $stmt = $this->db->query($result);
       $array = $stmt->fetchAll();
   } 
   catch (PDOException $e) 
   {
       echo $e->getMessage();
   }
}

and here i'm trying to call the array, at least I am, quite new to this.

    include ('CarsDb.class.php');
    $db = new CarsDb();
    $db->connect();
    $carArray = $db->select($array);
    var_dump($carArray);

Now the var_dump just shows NULL, however if I put a var_dump in the function it'll show the array on my page, so can anyone help me?

return statement is missing in select function ...

Rajeev Ranjan
– Rajeev Ranjan

2014-04-28 08:49:31 +00:00
Commented Apr 28, 2014 at 8:49 — Rajeev Ranjan
– Rajeev Ranjan, Commented Apr 28, 2014 at 8:49

Jay Bhatt · Accepted Answer · 2014-04-28 08:49:56Z

3

You need to return a value from your function. Do this.

public function select($array) {
    try {
        $result ="SELECT id,make,model FROM cars";
        $stmt = $this->db->query($result);
        return $stmt->fetchAll(); //Return value here
    } catch (PDOException $e) {
        echo $e->getMessage();
    }
}

And now this should work.

include ('CarsDb.class.php');
$db = new CarsDb();
$db->connect();
$carArray = $db->select($array);

answered Apr 28, 2014 at 8:49

Jay Bhatt

5,6715 gold badges44 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Daryl Smith Over a year ago

That's got it working, thank you very much, saved me a lot of hair pulling.

Rajeev Ranjan Over a year ago

@JayBhatt please consider the case when try block fails.

Jay Bhatt Over a year ago

@RajeevRanjan The array returned by the function is initialized only if the query succeeds. If an exception is thrown the array will be empty. Rather then returning empty values the code should handle exceptions.

Rajeev Ranjan · Accepted Answer · 2014-04-28 09:00:27Z

0

Return array from the select function

public function select($array=array()) {
try {

    $result ="SELECT id,make,model FROM cars";

    $stmt = $this->db->query($result);
    $array = $stmt->fetchAll();



} catch (PDOException $e) {
    echo $e->getMessage();
}
return $array;

}

edited Apr 28, 2014 at 9:00

answered Apr 28, 2014 at 8:50

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

Collectives™ on Stack Overflow

Calling Array from class PHP

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related