while循环只显示1个结果(While loop only showing 1 result)

 我有一个脚本，用于检查数据库中的dupe值，并循环查看结果并使用json回应该值。 但是，它只显示1条记录，而不是3条发送到php。 如果有人能指出我的错误，我将不胜感激。 谢谢 
 
$boxitems = mysqli_real_escape_string($conn, $_POST['box']);
$array = array();
$array = $boxitems;

foreach ($array as $boxes) {

    $sql = "SELECT item FROM act WHERE item = '".$boxes."' GROUP BY item HAVING COUNT(*) > 1";
    $result = mysqli_query($conn, $sql) or die('Error selecting item: ' . mysqli_error());
    $num_rows = mysqli_num_rows($result);
      if($num_rows) {
        while ($row = mysqli_fetch_array($result)) {
              $data[] =  $row['item'];
          }
          echo '<div style="width: 50%; margin-bottom: 20px; border-radius: 5px; border: 1px solid black; background: red; font-size: 16px; color: white; height: 50px; padding: 15px; line-height: 1.3;">';
          echo json_encode($data)  . ' already exists. Please enter a unique box reference.';
          echo '</div>';
          exit;
        } else {
          echo '<div style="width: 50%; margin-bottom: 20px; border-radius: 5px; border: 1px solid black; background: #63c84c; font-size: 16px; color: white; height: 50px; padding: 15px; line-height: 1.3;">';
          echo 'No dupes found in database.';
          echo '</div>';
          exit;
        }
    }
 
  
 
 更新的屏幕截图 
 
  

I have a script that checks for dupe values in db and loops through the result and echoes the value using json. However, it is only displaying 1 record instead of 3 which is being sent to php. I would be grateful if someone could point out my error. Thanks
 
$boxitems = mysqli_real_escape_string($conn, $_POST['box']);
$array = array();
$array = $boxitems;

foreach ($array as $boxes) {

    $sql = "SELECT item FROM act WHERE item = '".$boxes."' GROUP BY item HAVING COUNT(*) > 1";
    $result = mysqli_query($conn, $sql) or die('Error selecting item: ' . mysqli_error());
    $num_rows = mysqli_num_rows($result);
      if($num_rows) {
        while ($row = mysqli_fetch_array($result)) {
              $data[] =  $row['item'];
          }
          echo '<div style="width: 50%; margin-bottom: 20px; border-radius: 5px; border: 1px solid black; background: red; font-size: 16px; color: white; height: 50px; padding: 15px; line-height: 1.3;">';
          echo json_encode($data)  . ' already exists. Please enter a unique box reference.';
          echo '</div>';
          exit;
        } else {
          echo '<div style="width: 50%; margin-bottom: 20px; border-radius: 5px; border: 1px solid black; background: #63c84c; font-size: 16px; color: white; height: 50px; padding: 15px; line-height: 1.3;">';
          echo 'No dupes found in database.';
          echo '</div>';
          exit;
        }
    }
 
 
UPDATED screen shot
 

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