returning an array from a function

[TuMadre]

Hey all

I tried searching for a solution to my problem, but I could find any examples that matched my situation...

I have a function which pulls a single row from a table, and want to put the values into an array, and return that array so that it comes available to the script calling the function.

function GetCubeDetails($cid) {

global $CFG;

$db	= mysql_connect("$CFG->dbhost", "$CFG->dbuser", "$CFG->dbpass");
mysql_select_db("$CFG->dbname",$db);

$list_cube = "SELECT * FROM cube WHERE cube_id = '$cid'";
$list_cube_result = mysql_query( $list_cube ) or die ( "Error fetching cube..." );

while ($mycube = mysql_fetch_array($list_cube_result)) {

	$get_p_cube = "SELECT p_cid, auth FROM p_cube WHERE p_cid = '$mycube[cid]'";
	$get_p_cube_result = mysql_query( $get_p_cube ) or die ( "Error fetching parent cube..." );

	while ($my_parent	= mysql_fetch_array($get_p_cube_result)) {
		$parent_cube	= "$my_parent[auth]";
	}

	$this_cid = array (	'cube_height' => "$mycube[cube_height]",
											'cube_color' => "$mycube[cube_color]",
											'cube_mass' => "$mycube[cube_mass]",
											'admin_org' => "$parent_cube",
											'cube_state' => "$mycube[cube_state]");

}

//print_r($this_cid); 
return $this_cid;
}

when I uncomment print_r, I can see the contents of the array in the script that calls the function.

However, when try to print_r the returned array from with the script that calls the function, I get nothing.

Now I'm kinda new to PHP. I can do the regular PHP-stuff, but I'm probably missing something here.

Any1 here that can help me out?

thx!

[laserlight]

could you comment your script a little more?

For example, in
WHERE p_cid = '$myban[admin_id]'"

it seems that $myban is not defined, and I have no idea what is $myban in the first place.

[TuMadre]

Oops...

That was a typo (I replaced actual DB info with fake ones)

Thing is that all the mysql related stuff works... also creating the array works fine...

The actual problem is returning the array...

[laserlight]

could you simplify this to the simplest instance of the problem?

[TuMadre]

OK, Ill try.

Let's forget the mysql stuff...

Let's say I have a function which does the folling:

function GetCubeDetails() {
	$this_cid = array (	'cube_height' => "$mycube[cube_height]",
												'cube_color' => "$mycube[cube_color]",
												'cube_mass' => "$mycube[cube_mass]",
												'admin_org' => "$parent_cube",
												'cube_state' => "$mycube[cube_state]");

//print_r($this_cid); 
return $this_cid;
}

If I uncomment the print_r command in the above function, and call GetCubeDetails() from a php-script, I get the array printed.

However if I comment the print_r command in the function, and instead first call GetCubeDetails(), and then do "print_r($this_cid);"

I would expect to see the array in my browser. But instead I get nothing.

Briefly:
displaying the array in the function works, but returning the array from the function, and then displaying it does not work. It seems to me that I'm screwing something up in returning the array.

Hope this make things clearer... thx for your patience so far 🙂

[laserlight]

Try this code snippet:

<?php
function GetCubeDetails() {
	$this_cid = array (
		'cube_height' => "1",
		'cube_color' => "red",
		'cube_mass' => "2",
		'admin_org' => "admin_org",
		'cube_state' => "3"
		);
	print_r($this_cid);
	return $this_cid;
}
$cube_details = GetCubeDetails();
echo "<br>\n";
print_r($cube_details);
?>

What output do you get?

[TuMadre]

That's It!

I probably should be ashamed, but I'm too much of a newbie even for that...

Thx for your help!

[laserlight]

hmm... how exactly did I solve your problem?

I was just trying to lead you to discover what exactly was wrong, but I didnt expect the solution to come so fast 😕