使用PHP计算非空列

我认为你在表中有空值而不是空尝试这个

这将检查null和空

$persOnal= mysqli_query($con,"

     SELECT   father_name,
     mother_name,
     DOB,
     adhar_no,
     address,
     religion,
     CASE WHEN father_name IS NOT NULL AND father_name<>'' THEN 1 ELSE 0 END + 
     CASE WHEN mother_name IS NOT NULL AND mother_name<>'' THEN 1 ELSE 0 END + 
     CASE WHEN DOB IS NOT NULL AND DOB<>'' THEN 1 ELSE 0 END + 
     CASE WHEN adhar_no IS NOT NULL AND adhar_no<>'' THEN 1 ELSE 0 END +
     CASE WHEN address IS NOT NULL AND address<>'' THEN 1 ELSE 0 END +
     CASE WHEN religion IS NOT NULL AND religion<>'' THEN 1 ELSE 0 END AS personal
     FROM  user WHERE `user_authtoken` = '$user_ath'

     ") or die(mysqli_error($con));