[RESOLVED] What am I doing wrong!! Possible PHP5 issue?

ehask

Ok I wrote a useronline class and everything is working except the function that builds the list of Username and IP Address.

Here is the snippit

	
                function uo_names() {
		$query = "SELECT * from online";
		$result = $this->_DB->get_results($query);
		$uo_users = array();
		foreach ($result as $res) {
			$uo_users[$res['username']] = $res['ipaddr'];
		}
		return $uo_users;

}

This results in
"Fatal error: Cannot use object of type stdClass as array in /opt/lampp/htdocs/ibanc/includes/classes/class.useronline.php on line 76"

Line 76 is this: $uo_users[$res['username']] = $res['ipaddr'];

I have googled away but all I have seen is issues with commercial software. I do I build this array inside my class?? My Dev server is running Xampp which is PHP5 is this the problem??

Thx for any help

Eric

jjfletch

What happens if you change:

 $uo_users[$res['username']] = $res['ipaddr'];

 $uo_users($res['username']) = $res['ipaddr'];

ehask

It returns this error

Fatal error: Can't use function return value in write context in /opt/lampp/htdocs/ibanc/includes/classes/class.useronline.php on line 76

jjfletch

What happens if you use curly brackets? Anything different?

ehask

Fatal error: Cannot use object of type stdClass as array in /opt/lampp/htdocs/ibanc/includes/classes/class.useronline.php on line 76

Hmmm I may have to rethink this.....

bpat1434

Okay, let's get to the root:
What does get_results($query) return?

Before you do your loop, echo out $result. Does it give you "Resource ID #XX" or "Array"?

If it gives you "Resource ID#XX" then you need to use the mysql_fetch_array() to loop through it...

If not, we'll go from there...

~Brett

ehask

print_r($result) :

Array
(
[0] => stdClass Object
(
[session_id] => 31ef7af1a63f484f0099610fc51f0458
[username] => ehask
[ipaddr] => 192.168.1.100
[lastvisit] => 2005-12-29 17:14:40
)

[1] => stdClass Object
    (
        [session_id] => 3ab953fb783cfaf9082a47b55ad40003
        [username] => Guest
        [ipaddr] => 127.0.0.1
        [lastvisit] => 2005-12-29 17:06:12
    )

)

So I guess I need to figure out how to rewrite the array without the stdClass Object ?? I have never seen this before. Is my DB Access class creating this or is it how I coded the function??

bpat1434

OKay....

at first glance I say it's your coding. You put a reference to an object that you didn't want...

Look at your query function, it's probably in there somewhere.

~Brett

ehask

Hmmm well I am using ezSQL Class to access the database

I started looking over the code for that class and found get_results defaulted to OBJECT instead of an array!!!

$query = "SELECT * from online";
$result = $db->get_results($query,ARRAY_A);
print_r($result);

Fixed it!!! Sorry guys!!