How to access multiple variables outside foreach loop in php

Question

I am not a php pro and have already explored different online search forums but could not find any suitable answer and that's why posting my question here.

Function One: Runs a query to database and define variables in foreach loop as follows:

function myFunction(){
 $dbinfo = get_db_info();
 $users = $dbinfo->get_results("
    SELECT 
       Email,
       ID,
       Name,
       Address
        FROM Database_table
        WHERE ID = 5
    ");
    
    if($users) {
        $output = '';
        foreach($users as $user) {
            $ID = $user->ID;
            $dname = $user->Name;
            $email = $user->Email;
            $address = $user->Address;
        }else{
            $output .= 'No user found';
        }

    }//endif
    return $output;
}

Function two: Now I want to get the values of those variables in another function as follows:

function dislayData(){

    $values = myFunction();
    echo $values=>$email;

}

But it does not work. It seems I may need to wrap variables in the foreach loop into an array. I don't understand how to do that.

Any help here would be highly appreciated.

Thanks in advance.

Bakar

what is echo $values=>$email;?

Sumit Wadhwa
– Sumit Wadhwa

2020-10-06 18:37:04 +00:00
Commented Oct 6, 2020 at 18:37 — Sumit Wadhwa
– Sumit Wadhwa, Commented Oct 6, 2020 at 18:37

Dark Knight · Accepted Answer · 2020-10-06 18:28:09Z

2

function myFunction(){
    $dbinfo = get_db_info();
    $users = $dbinfo->get_results("SELECT Email, ID, Name, Address
                                    FROM Database_table
                                    WHERE ID = 5");
    
    if($users) {
        $arrOutput = [];
        foreach($users as $user) {
            $arrOutput[]    =   [
                'ID'    =>  $user->ID,
                'dname' =>  $user->Name,
                'email' =>  $user->Email,
                'address'   =>  $user->Address
            ];
        }
        return $arrOutput;
    }
    else{
        return false;
    }
}

function dislayData(){

    $values = myFunction();

    if($values !== false){
        foreach($values as $user){
            // Now you can access property of each uesr
            echo $user['email'];
        }
    }
}

answered Oct 6, 2020 at 18:28

Dark Knight

6,6211 gold badge22 silver badges40 bronze badges

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

Comments

MFR096 · Accepted Answer · 2020-10-06 18:27:24Z

1

I think you forgot to store the users data in the variable "output".

answered Oct 6, 2020 at 18:27

MFR096

193 bronze badges

Collectives™ on Stack Overflow

How to access multiple variables outside foreach loop in php

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