problem in variables scope in PHP

Question

I wrote this code

require('Database.class.php');



     function get_info (){



        $db = new Database($config['server'], $config['user'], $config['pass'], $config['database'], $config['tablePrefix']);
        $db->connect();


        $sql = $db->query('SELECT * FROM ja_cat');
        while ($options = $db->fetch_array($sql)) {

            $cat[].=" ".$options['title'];
        }
        $db->close();
        return $cat;

then I get this Mysql error

Mysql Error : No database selected .

but when I put the require instruction inside the function it's work fine

cletus · Accepted Answer · 2009-08-27 15:31:50Z

4

My guess is Database.class.php creates some variables that are probably global in scope that it relies upon. If you require it inside the function and it works, that supports that theory. Is that your class? Can you change it? Can you post it?

Basically $config needs a global qualifier inside the function.

answered Aug 27, 2009 at 15:31

cletus

627k169 gold badges922 silver badges945 bronze badges

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

2 Comments

Waseem Over a year ago

here it is ricocheting.com/scripts/php_mysql_wrapper.php , Andrew solved the problem

Andrew G. Johnson Over a year ago

Ya he wrote out the reason and I wrote out the fix, I suppose I should have elaborated as to the WHY behind my HOW.

Andrew G. Johnson · Accepted Answer · 2009-08-27 15:32:21Z

3

Make this the first line IN your get_info() function:

global $config;

Also, you may want to define $db outside of the function at the start of the code and then close the connection at the end, instead of having to re-connect multiple times.

answered Aug 27, 2009 at 15:32

Andrew G. Johnson

27.1k30 gold badges94 silver badges138 bronze badges

Comments

Ionuț G. Stan · Accepted Answer · 2009-08-27 15:32:49Z

2

You have to import the global variable $config into the scope of the function:

function get_info() {
    global $config;
}

answered Aug 27, 2009 at 15:32

Ionuț G. Stan

180k19 gold badges196 silver badges206 bronze badges

1 Comment

Ionuț G. Stan Over a year ago

You guys just don't see the problem? Isn't it?

Collectives™ on Stack Overflow

problem in variables scope in PHP

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related