[SOLVED] Dumping a table into a variable.

[Cenron]

Hey guys me again this time around I am trying to dump my entire user table into a variable so I can go through them with foreach

 

so for example I want do something like this.

 

$result = mysql(query for user data);

foreach($result as $users)
{
   echo $users['user'];
}

 

and so forth any idea guys?

[trq]

<?php

  if ($result = mysql_query("SELECT uname FROM users") && mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      echo $row['uname'];
    }
  }

?>

 

If this is not what you want to do you'll need to explain in English. Your pseudo code does nothing to help.

[Cenron]

Well see what I want to do is dump all the info in the user table into one big array instead of pulling one row at a time like your doing it.

 

The reason I want to do that is because I am using this for a template engine I am writing...so I need to use foreach(); instead of any other loop.

[dymon]

<?php

  if ($result = mysql_query("SELECT uname FROM users") && mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      $results[] = $row['uname'];
    }
  }

?>

 

And now you can extract from the results array using a foreach loop.

[Cenron]

You guys are awesome! I have never been part of a forum that actually helps the beginners instead of flaming them, right on guys.

[per1os]

<?php

  if ($result = mysql_query("SELECT uname FROM users") && mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      $results[] = $row['uname'];
    }
  }

?>

 

And now you can extract from the results array using a foreach loop.

 

On that note if you use that alot it might be wise to create a function.

 

<?php
function fetch_multi_array($sql) {
// see if a valid resource was passed in
$result = (strstr($sql, "Resource"))?$sql:mysql_query($sql);

$i=0; // use $i to have some type of an index.
while ($row = mysql_fetch_assoc($result)) {
	$return[$i] = $row;
	$i++;
}

mysql_free_result($result); // free the result
return $return;
}

?>

 

It still has yet to fail me and makes it very easy to not have to duplicate code.

[dymon]

You don't have to use $return[$i], where $i is a counter, as far as $return[] does the same, and if it will be used many times it will save some executing script time.

[per1os]

You don't have to use $return[$i], where $i is a counter, as far as $return[] does the same, and if it will be used many times it will save some executing script time.

 

It seems I stand corrected, for some reason in the past (maybe with an older php version) using the [] often times did not produce "correct results" at any rate here is a revised function.

 

<?php
function fetch_multi_array($sql) {
// see if a valid resource was passed in
$result = (strstr($sql, "Resource"))?$sql:mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {
	$return[] = $row;
}

mysql_free_result($result); // free the result
return $return;
}

?>

 

But as for the execution time, I doubt it would make a difference unless you are returning like 5,000+ rows each run. Even then I do not think it would slow it down and make the script less efficient.