php - 我如何从数据库中选择并使用函数将值存储在数组中？

Question

我想从一个表中选择，获取所有值并将它们放入一个数组中，返回函数，并在另一个文件中调用它，然后遍历数组，同时我调用另一个函数并为其提供数组值.谢谢

<?php
function getusers()
 {
 //db parameters here    
mysql_connect($dbhost, $dbuser, $dbpass) or die("MySQL Error: " . mysql_error());  
mysql_select_db($dbname) or die("MySQL Error: " . mysql_error());  
$query  = "SELECT user_name FROM userinfo";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

  return $final[] = $row['user_name'];
}     
    mysql_Close ($conn);
 }
 ?>

getusers() 返回一个数组，我在另一个文件中调用它

 include('usernames.php');
 getusers();
 while!(end of [$final] array)
 {
    getTax($final[]);
  }

  function getTax($final)
  {
     //statement here
  } 

Answer 1

function getusers()
{
  //db parameters here    
  mysql_connect($dbhost, $dbuser, $dbpass) or die("MySQL Error: " . mysql_error());  
  mysql_select_db($dbname) or die("MySQL Error: " . mysql_error());  
  $query  = "SELECT user_name FROM userinfo";
  $result = mysql_query($query);
  $return = array();
  while($row = mysql_fetch_array($result, MYSQL_ASSOC))
   {
     $return [] = $row['user_name'];
   }     
 mysql_Close ($conn);
 return $return;
}

在其他文件中:

$final = getusers();
foreach ($final as $user) {
  /*do what you want*/
}