显示Echo如果列为空，请显示另一个回声

Question

我写了此代码，但是有一些错误，即使列不是空的，它也仅显示第一个回声。

i如果列Subuser1为空，则将显示Echo" 1"代码否则显示Echo" 2"如果列SubuSer1不是空的。

  <?php
  include_once 'dbconnect.php';
   // Create connection
  $conn = new mysqli(DBHOST,DBUSER,DBPASS,DBNAME);
// Check connection
if ($conn->connect_error) {
 die("Connection failed: " . $conn->connect_error);
}  
$sql= ("SELECT subuser1 FROM users WHERE id=".$_SESSION['user']  );
$result = $conn->query($sql);

$subuser1 = $row["subuser1"];

if ($result->num_rows > 0) {
if (empty($subuser1)) {
echo "subuser1 is either 0, empty, or not set at all";
}
 } else {
echo " subuser1 not empty";

Answer 1

我解决了它的解决，如果有人需要它，它可以完美地工作。

 <?php
 $userR= 0 ;
 include_once 'dbconnect.php';
 // Create connection
 $conn = new mysqli(DBHOST,DBUSER,DBPASS,DBNAME);
 // Check connection
if ($conn->connect_error) {
 die("Connection failed: " . $conn->connect_error);
}  
$sql= ("SELECT * FROM users WHERE id=".$_SESSION['user']  );
$result = $conn->query($sql);
if ($result->num_rows > 0) {
 while($row = $result->fetch_assoc()) {  
  if ($row["subuser1"] == NULL ){
 echo "";  }
   else {
echo " bla bla bla "
}
}
?>