PHP / MYSQL查询作为多用途函数(PHP/MYSQL Query as a Function for Multi-Use)

 我试图在网站的大约15页内清理大量的选择查询，我想使用一个函数，然后我可以使用它来调用所有不同的查询和表，将减少一堆杂乱。 
 
 我遇到了一个问题，似乎无法找到一种方法来纠正它。 
 
 这是功能： 
 
function dbGet($conn, $table, $select, $where, $cond) {
   require($conn);
   if ( $stmt = $db->prepare(" SELECT $select FROM `" . $table . "` WHERE $where=? ")) {
      $stmt->bind_param("i", $cond);
      $stmt->execute();
      $result = $stmt->get_result();
      $rowNum = $result->num_rows;

      if ( $rowNum > 0 ) {
         while( $data = $result->fetch_assoc() ){
            return $data;
         }
      }
      $stmt->close();
   } else {
      die($db->error);
   }
   $db->close();
}
 
 以下是我在各种不同页面中调用该函数的方法： 
 
$settings = dbGet('php/connect.php', 'settings', '*', 'userId', $sessionId);
echo $settings->toName;
 
 我遇到的问题是，它只显示设置表中的第一条记录。 我以为在函数中使用while循环会返回所有记录。 事实上，如果我为$ data而不是return返回print_r，我会获得所有记录。 如何将所有记录传递到要在任何其他页面中访问的返回$数据？ 
 
 或者如果你们碰巧对现有功能的任何建议都是高度重视和真实的，我可以实施而不是自己编写，请告诉我。 
 
 谢谢。 

I am trying to clean a ton of select queries inside about 15 pages of a website and I thought using a function that then I can use to call all the different queries and tables, would reduce the clutter a bunch. 
 
I am running into a problem and can't seem to figure out a way to get it right. 
 
Here is the function:
 
function dbGet($conn, $table, $select, $where, $cond) {
   require($conn);
   if ( $stmt = $db->prepare(" SELECT $select FROM `" . $table . "` WHERE $where=? ")) {
      $stmt->bind_param("i", $cond);
      $stmt->execute();
      $result = $stmt->get_result();
      $rowNum = $result->num_rows;

      if ( $rowNum > 0 ) {
         while( $data = $result->fetch_assoc() ){
            return $data;
         }
      }
      $stmt->close();
   } else {
      die($db->error);
   }
   $db->close();
}
 
And here is how I call the function in the various different pages:
 
$settings = dbGet('php/connect.php', 'settings', '*', 'userId', $sessionId);
echo $settings->toName;
 
The problem I am running into, is that it is only displaying the first record from the settings table. I thought using the while loop in the function would return all the records. As a matter of fact, if I do a print_r for $data instead of return, I get all the records. How can I pass along all the records into the return $data to be access in any other page?
 
OR If you guys happen to have any suggestions of an existing function that is highly regarded and true-and-tested that I can implement instead of writing my own, please let me know.
 
Thanks.

原文：https://stackoverflow.com/questions/45282796