Arrays, Objects, and Functions Oh My!!

Anon

This is where the array of "objects" is generated:

while ($row = mysql_fetch_object ($result,MYSQL_ASSOC)) {
$my_array[] = $row;
}

Next I want to pass the array of objects to a function an process every object and add a data element to each object:

$vb_dblink = do_db_connect ($GLOBALS['vb_dbhost'],$GLOBALS['vb_dbname'],$GLOBALS['vb_dbusername'],$GLOBALS['vb_dbpassword']);

foreach ($my_array as $row) {
$row = vb_get_replycount ($vb_dblink,$row);
}

mysql_close ($vb_dblink);

The problem is that in my function vb_get_replycount the OBJECTS are not being updated!

Here is the function:
function vb_get_replycount ($vb_dblink, $row) {

foreach ($array as $row) {
$sql = "select replycount from thread where thread.threadid=\"$row->vb_threadid\"";
print "SQL = $sql ";
if (!($result_row = mysql_query ($sql, $vb_dblink))) {
$row->replycount = "N/A";
}
else {
$object = mysql_fetch_object ($result_row,MYSQL_ASSOC);
$row->replycount = $object->replycount;
}
print "COUNT = $row->replycount ";
}
}

The problem is that back in main program $row->replycount isn't there?

Any ideas?

Thanks!

Anon

Actually this can be greatly SIMPLIFIED to the following:

Array of objects generated thus:

while ($row = mysql_fetch_object ($result,MYSQL_ASSOC)) {
$news_array[] = $row;
}

Next I iterate over the objects and add a variable "FOO":

foreach ($news_array as $row) {
$row->FOO = "BAR";
print "$row->FOO ";
}

$row->FOO prints in this loop, BUT WONT PRINT ONCE THE LOOP IS FINISHED. Its like the assignement "$row->FOO = "BAR";" never happened once the loop is finished.

This code will generate errors:

foreach ($news_array as $row) {
print "$row->FOO ";
}

Warning: Undefined property: FOO

Any Ideas??

Thanks!

[deleted]

Looks like you are not passing the parameters 'by reference'

http://www.php.net/manual/en/language.references.pass.php

Anon

In the function:

function vb_get_replycount ($vb_dblink, $row) {

foreach ($array as $row) {
-----------^
Where is $array being defined? foreach looping through an array takes the array and then the identifier you would like to place it in second. Maybe you got these mixed up.

$sql = "select replycount from thread where thread.threadid=\"$row->vb_threadid\"";
print "SQL = $sql ";
if (!($result_row = mysql_query ($sql, $vb_dblink))) {
$row->replycount = "N/A";
-----^
Again, the $row that would be here is not an object.

Hope that helps!

Chris King

Anon

Here's the solution ... it was multi-dim array that I was filling improperly:

$array_count = count($news_array);

for ($i=0; $i<$array_count;$i++) {
$news_array[$i]->FOO = "BAR";
}

foreach ($news_array as $row) {
print "$row->FOO ";
}

This works. Its prolly not optimal solution, but it works.

🙂