Returns multiple values from a PHP function

Question

Apologize for the repeated question. Return multiple values from database with function. I tried executing code, the function returns one value, where I want all the values of id and name.

Database: id and name has 9 rows. Is there anything I was missing in my code.

function readdata() { 
    $sth = $db->execute('SELECT * FROM mynumbers m WHERE m.id>1 ORDER BY m.id ASC');
    foreach ($sth as $s) {
       $object = new stdClass();
       $object->id = $s->id;
       $object->name = $s->name;
       return $object;    
    }              
}

$rd = readdata();
echo $rd->id;
echo $rd->name;

You should have a look at this : stackoverflow.com/questions/12709866/… — Romain VDK
– Romain VDK, Commented May 25, 2020 at 5:54

Serghei Leonenco · Accepted Answer · 2020-05-25 05:20:10Z

2

May be something like this:

function readdata() { 
    $sth = $db->execute('SELECT * FROM mynumbers m WHERE m.id>1 ORDER BY m.id ASC');
    $out = [];
    foreach ($sth as $s) {
       $object = new stdClass();
       $object->id = $s->id;
       $object->name = $s->name;
       $out[] =  $object;    
    } 
    return $out;             
}
$rd = readdata();
//and here
foreach($rd as $obj){
   echo $obj->id;
   echo $obj->name;
}

answered May 25, 2020 at 5:20

Serghei Leonenco

3,5272 gold badges11 silver badges17 bronze badges

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

Comments

Markus Zeller · Accepted Answer · 2020-05-25 12:37:53Z

2

This is more a suggestion than an answer. Why re-inventing the wheel? PDO already is capable of returning classes and also fetching all results into an array.

function readdata(PDO $db): array
{
  $sth = $db->prepare('SELECT * FROM mynumbers m WHERE m.id>1 ORDER BY m.id ASC');
  $sth->execute();
  return $sth->fetchAll(PDO::FETCH_CLASS);
}

$objects = readdata($db);

$objects is now an array. Each element contains a stdClass object with each column name as property.

foreach($objects as $object) {
   echo $object->id, PHP_EOL;
   echo $object->name, PHP_EOL;
}

edited May 25, 2020 at 12:37

answered May 25, 2020 at 6:27

Markus Zeller

9,2142 gold badges34 silver badges39 bronze badges

Comments

P2000 · Accepted Answer · 2020-05-25 05:18:59Z

0

Your foreach loop intends to run through all values of the array $sth, but returns only with the FIRST one.

You can just return $sth to get the whole array, or build a new array and append to it:

$ret = array();
foreach ($sth as $s) {
  ...
  $ret[] = $object;
  }

and then return $ret;

answered May 25, 2020 at 5:18

P2000

1,0728 silver badges14 bronze badges

Collectives™ on Stack Overflow

Returns multiple values from a PHP function

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related