troubleshooting Question

Variable scope in php

Avatar of stargateatlantis
stargateatlantis asked on
13 Comments5 Solutions260 ViewsLast Modified:
I am trying to access the $db variable in my custom function but it isn't working not sure why.  It has something to do with scope but I would like the function to access the $db variable.

Here is my code below

/*Connect to the database.*/
$db=new db("mysql:host=localhost;dbname=mydb", "mydb", "mydb123");

/*Get database value*/
function retVal($table,$field,$val,$returnVal)
    $dataReturn = $db->select($table, $field."= '".$val."'");

    /*Loop THru array and load it with values */
    foreach ($dataReturn[0] as $key=>$value) {

    return $dataArray[$returnVal];

/*End function return value */
Mark Brady
Principal Data Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 5 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros