how to retrieve an array from php function?

Question

i get list of students from database in array and return it with function:

class StudentClass
{
    public function getAllStudent()
    {
        $host = "localhost";
        $database = "mms_db";
        $username = "root";
        $password = "";
        $dns = "mysql:host=$host; dbname=$database";
        $connect = new PDO($dns, $username, $password);
        $connect->query("set names utf8");
        $connect->query("set charset utf8");
        $sql = "select * from students";
        $result = $connect->prepare($sql);
        $result->execute();
        $starraye = $result->fetchAll();
        return $starraye;
    }
}

now i want to retrieve this array and echo with foreach():

<?php
    include ("StudentClass.php");
    $student_object = new StudentClass();
    $student_object->getAllStudent();
    foreach ($starraye as $rows)
    {
        echo $rows['fname'];
    }

but i get error:

tanks!

you need to store the return value $starraye = $student_object->getAllStudent(); — kamal pal
– kamal pal, Commented May 25, 2016 at 9:45

Murad Hasan · Accepted Answer · 2016-05-25 09:45:43Z

2

You need to store the return array, After a function call you have to store the return data in any variable. You did't make it so the error shows up.

include ("StudentClass.php");
$student_object = new StudentClass();
$starraye = $student_object->getAllStudent(); //store here
foreach ($starraye as $rows)
{
    echo $rows['fname'];
}

answered May 25, 2016 at 9:45

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

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

Comments

Brijal Savaliya · Accepted Answer · 2016-05-25 09:49:17Z

1

Function getAllStudent is returning data as array so you have to store the return array in some variable and you can use that variable...

So Use it like

$output_array = $student_object->getAllStudent();
if($output_array!= false)
{
    foreach ($output_array as $rows)
    {
        echo $rows['fname'];
    }
}

answered May 25, 2016 at 9:49

Brijal Savaliya

1,0919 silver badges19 bronze badges

Collectives™ on Stack Overflow

how to retrieve an array from php function?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related