Passing MySQL Array to another function

[rkolbe]

So I know how to pass an array from one func to another by using return array and list (in the other func calling the array), but here is my situation (and I have yet to solve it) - how do I pass the mysql array results from func2() to somefunc(). somefunc() will echo them out essentially.

function somefunc(){
   func2(1);
}

function func2($var){

   $sql = "SELECT * FROM someTable WHERE id = '$var'";
   //does mysql query call
   $results = //mysql_fetch_array stuff here
   return $results;
}

Now I have tried just about everything from iterating over the mysql_fetch_array and putting it into a new type of array (non mysql - i dont know if it makes a difference).

Using var_dump in func2 with list($the var goes here) I come back with NULL. There is data in the table im pulling from and everything in my code looks to be correctly spelled.

[rkolbe]

So the manual says I cant pass arrays...is there a work around - I was thinking of using implode, but the mysql_fetch_array already creates an array...

[NogDog]

You could create an array of result rows:

function func2($var){
   $sql = "SELECT * FROM someTable WHERE id = '$var'";
   $result = mysql_query($sql) or die("Query failed ($sql): ". mysql_error());
   $output = array();
   while($row = mysql_fetch_assoc($result))
   {
      $output[] = $row;
   }
   return($output);
}

Now you can call your display function with the result array as a parameter:

function somefunc($data)
{
   echo "<table>\n";
   foreach($data as $row)
   {
      echo "<tr>";
      foreach($row as $value)
      {
         echo "<td>$value</td>";
      }
      echo "</tr>\n";
   }
   echo "</table>\n";
}

Sample usage:

$result = func2($_GET['id']);
if(count($result))
{
    somefunc($result);
}
else
{
   echo "<p>Sorry, no matches were found</p>\n";
}

[rkolbe]

NogDog, I did try that thinking it would work...it didnt...are the parens signifigant with return for that to work? That is the only difference in code I see from what I tried earlier this morning.

[rkolbe]

Ok, maybe I thought this would be something easily answered at the beginning...but since I left out a tad bit of info, it made it worse I guess (sorry 🙁 ).

Here is the actual code I am using right now (or trying) with your code incorporated a bit NogDog.

function viewEventDetails($eventID){

   echo "<table>\n";
   foreach(viewEventConfirmation($eventID, '') as $row)
   {
      echo "<tr>";
      foreach($row as $value)
      {
         echo "<td>$value</td>";
      }
      echo "</tr>\n";
   }
   echo "</table>\n";
}

function viewEventConfirmation($eventID, $userID){
	//no userID is set so we pull all records for a specific eventID
	if(!isset($userID)){
		$sql = "SELECT * FROM events_confirmed WHERE event_id = '$eventID' AND user_id != '0'";
	}else{
	//both vars are set, so we just use them and get specific event and see if user is confirmed for it
	$sql = "SELECT * FROM events_confirmed WHERE event_id = '$eventID' AND user_id = '$userID'";
	}

$result = db_query($sql); //db_query does query
$output = array();
 while($row = mysql_fetch_assoc($result))
   {
      $output[] = $row;
   }
   return($output);
}

//let's call it out
viewEventDetails($id);

Now this is not exactly how I am going to use it. The echo for the table and stuff will be done in a different way...but this is essentially it (not leaving out any important info now hehe).

I am wondering if it would be easier to write up a class.

[rkolbe]

Ok..think i found my REAL issue here....where I have:

if(!isset($userID)){
        $sql = "SELECT * FROM events_confirmed WHERE event_id = '$eventID' AND user_id != '0'"; 

I really need to add in this to the if statement:

if(!isset($userID) || empty($userID)

So now I am on my way with a class 😉 Just seems a bit easier this way. Thank you all!