How can i return more than 1 values from a foreach loop using PHP

Question

Here's my function

function GetUser($id)
{
    global $pdo;
    $stmt = $pdo->prepare('SELECT lname,fname,mi FROM user WHERE id = :id LIMIT 1');
    $stmt->execute(array(':id'=>$id));
    foreach($stmt as $name){
        $lname = $name['lname'];
        $lname = $name['fname'];
        $mi = $name['mi'];
    }

    return //what to put here?
}

Here's my code to use the function

include 'function.php';
$names = GetUser($_SESSION['id']);
//what's next?

How can i retrieve the $lname,$fname and $mi from the function? Need any help and suggestions. Thank you :)

I recommend taking an object-oriented approach and creating a User object which wraps the user values. Alternatively, you can just return the three values in an array. — FThompson
– FThompson, Commented Aug 26, 2012 at 14:45

Community · Accepted Answer · 2017-05-23 11:49:06Z

4

For starters don't use the global keyword, but inject the variable you need. Second why don't you return an array?:

function getUser($pdo, $id)
{
    $stmt = $pdo->prepare('SELECT lname,fname,mi FROM user WHERE id = :id LIMIT 1');
    $stmt->execute(array(':id'=>$id));

    $result = array();
    foreach($stmt as $name){
        $result['lname'] = $name['lname'];
        $result['fname'] = $name['fname'];
        $result['mi']  = $name['mi'];
    }

    return $result;
}

$result = getUser($pdo, 1);
var_dump($result);

Note that this will only return the last result. If you want it all:

function getUser($pdo, $id)
{
    $stmt = $pdo->prepare('SELECT lname,fname,mi FROM user WHERE id = :id LIMIT 1');
    $stmt->execute(array(':id'=>$id));

    return $stmt->fetchAll();
}

$result = getUser($pdo, 1);
var_dump($result);

Also note that I have made your function name starting with a normal letter instead of a capital. The "normal" naming convention is that classes start with a capital, but function / methods with a normal one.

If you want to retrieve the information based on the first solution you would do:

echo $result['lname'];

If you want to retrieve the information based on the second solution you would do:

echo $result[0]['lname'];

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Aug 26, 2012 at 14:47

PeeHaa

73.1k60 gold badges195 silver badges264 bronze badges

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

3 Comments

Sui Go Over a year ago

yes i am a starter. why should I not use global? i have many functions that's why I use global so that i will not use that same line of code over and over again? hehe :) thanks

PeeHaa Over a year ago

No worries. Everybody has to start somewhere. :-) See the linked post at the top of my answer and also see the comments/discussion underneath that answer.

Sui Go Over a year ago

thanks sir! but how can i retrieve every each of the values like i want to echo the names: echo $lname.', '.$fname.' '.$mi.'.'?

Derik Nelson · Accepted Answer · 2012-08-26 15:22:35Z

3

function GetUser($id)
{
    global $pdo;
    $stmt = $pdo->prepare('SELECT lname,fname,mi FROM user WHERE id = :id LIMIT 1');
    $stmt->execute(array(':id'=>$id));
    foreach($stmt as $name){
        $lname = $name['lname'];
        $lname = $name['fname'];
        $mi = $name['mi'];
    }

    return array(
        "$lname" => $lname,
        "$fname" => $fname,
        "$mi" => $mi
     );
}

This is what's next part:

include 'function.php';
$myArray = GetUser($_SESSION['id']);
$fname = $myArray["$fname"];
$lname = $myArray["$lname"];
$mi = $myArray["$mi"];

Or:

include 'function.php';
$myArray = GetUser($_SESSION['id']);
$fname = $myArray[0];
$lname = $myArray[1];
$mi = $myArray[2];

edited Aug 26, 2012 at 15:22

answered Aug 26, 2012 at 14:59

Derik Nelson

393 bronze badges

3 Comments

Derik Nelson Over a year ago

see the revised version above. @SuiGo

Derik Nelson Over a year ago

choose this one as answer if it helped you @SuiGo :)

PeeHaa Over a year ago

@DerikNelson You are running your return array() { } as a function which it isn't

Sepster · Accepted Answer · 2012-08-26 14:48:23Z

1

return array(
    "lname" => $lname,
    "fname" => $fname,
    "mi" => $mi
);

answered Aug 26, 2012 at 14:48

Sepster

4,86823 silver badges40 bronze badges

Comments

OptimusCrime · Accepted Answer · 2012-08-26 14:48:42Z

1

function GetUser($id) {
    global $pdo;
    $stmt = $pdo->prepare('SELECT lname,fname,mi FROM user WHERE id = :id LIMIT 1');
    $stmt->execute(array(':id'=>$id));
    return $stmt;
}


include 'function.php';
$names = GetUser($_SESSION['id']);
foreach($names as $name){
    $lname = $name['lname'];
    $lname = $name['fname'];
    $mi = $name['mi'];
}

Not tested, but I think it should work

answered Aug 26, 2012 at 14:48

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

Comments

Samson · Accepted Answer · 2012-08-26 14:49:25Z

1

function GetUser($id)
{
    global $pdo;
    $stmt = $pdo->prepare('SELECT lname,fname,mi FROM user WHERE id = :id LIMIT 1');
    $stmt->execute(array(':id'=>$id));
   return count($stmt)==1?$stmt[0]:null; //you may have nothing returned from the database so return null
}

Then:

include 'function.php';
$names = GetUser($_SESSION['id']);
if ($names){   //if this is not null then get the properties
echo $names['fname'];
echo $names['lname'];
echo $names['mi'];
}

answered Aug 26, 2012 at 14:49

Samson

2,8317 gold badges40 silver badges55 bronze badges

1 Comment

Sui Go Over a year ago

thanks, but which is better using this type of approach or the array ? :)

Collectives™ on Stack Overflow

How can i return more than 1 values from a foreach loop using PHP

5 Answers 5

3 Comments

3 Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

3 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related