php - 获取用户和显示信息？

Question

所以我有这个输入，我可以在其中输入用户名，它将使用 $_POST 来获取我在输入框中输入的内容，但是我正在努力如何从我的数据库中获取与以下内容相关的所有信息这个用户名并显示它？

 <form action="ProcessPlayerSearch.php" method="POST">
     <div class="input-group input-group-sm">
                <input type="text" name="SearchUser" id="SearchUser" class="form-control">
                <span class="input-group-btn">
                  <button type="submit" class="btn btn-info btn-flat" type="button">Search</button>
                </span>
              </div>


     </h4>
            </form>

这是我的 ProcessPlayerSearch.php

function GetPlayerSearch(){
   global $database;
   $user = $_POST['Searchuser'];
   $q = "SELECT * FROM NEWPlayerInfo WHERE player=$user";
   $result = $database->query($q);
   /* Error occurred, return given name by default */
   $num_rows = mysqli_num_rows($result);
   if(!$result || ($num_rows < 0)){
      echo "User not found";
      return;
   }
   if($num_rows == 0){
      echo "User not found";
      return;
   }


   for($i=0; $i<$num_rows; $i++){
      mysqli_data_seek($result, $i);
      $row=mysqli_fetch_row($result);
      $uuid  = $row[0]; //UUID
      $player  = $row[1]; //player
      $kicks  = $row[2]; //kicks
      $bans  = $row[3]; //bans
      echo "$uuid<br>";
      echo "$player<br>";
      echo "$kicks<br>";
      echo "$bans<br>";
   }


}

我得到的错误是

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

但是我不明白为什么它会返回 bool 值？因为我在输入中输入了一个字符串？任何帮助谢谢。

Answer 1

由于您要显示单个用户数据，因此使用 for 循环会产生一点开销。现在我们从您的函数返回包含用户信息的数组:

function GetPlayerSearch($user){
   global $database;
   $user = $_POST['Searchuser'];
   $q = "SELECT * FROM `NEWPlayerInfo` WHERE player='$user'";
   $result = $database->query($q);
   /* Error occurred, return given name by default */
   $num_rows = mysqli_num_rows($result);
   $res =mysqli_fetch_assoc($result);
   $userinfo =array();
   if($num_rows>1){
      $userinfo[] = $res;
   }else{
      $userinfo[] = array();
   }
   return $userinfo;
 }

现在搜索用户:

if(isset($_POST['SearchUser'])){   
    $user = isset($_POST['SearchUser'])? $_POST['SearchUser']:'';
    $player = GetPlayerSearch($user);
}

显示单个玩家数据:

if(!empty($player)){ //you can also use array_filter()
      echo $player['UUID'].'<br>';
      echo $player['player'].'<br>';
      echo $player['kicks'].'<br>';
 }else{
      echo 'No user';
 }