php 检查用户是否上传了个人资料图片

Question

你好如何检查用户是否上传了个人资料图片...我试过这个代码但只显示默认图片而不是其他部分...请帮助...这是我的代码$check_pic = mysqli_query($conn,"SELECT image FROM users WHERE id='$id'");$get_pic_row = mysqli_fetch_assoc($check_pic);$profile_pic_db = $get_pic_row['image'];$pro_num = mysqli_num_rows($profile_pic_db);if ($pro_num == 0) {    $profile_pic = "http://localhost/Ramdhenu/images/default_propic.png";} else {    $profile_pic = "http://localhost/Ramdhenu/userdata/Author_images/".$profile_pic_db ;}

Answer 1

您需要检查列的值，而不是是否返回任何行。您还应该改用准备好的语句。

$stmt = $conn->prepare("SELECT image FROM users WHERE id=?");

$stmt->bind_param("s", $id);

$stmt->execute();

$stmt->bind_result($image);

if ($stmt->fetch()) {

    if (empty($image)) {

        $profile_pic = "/Ramdhenu/images/default_propic.png";

    } else {

        $profile_pic = "/Ramdhenu/userdata/Author_images/".$image; 

    }

} else {

    // No user by that ID

}

$stmt->close();

Answer 2

您将始终获得 $pro_num !=0 ，如果您对列进行图像处理，则需要检查默认值，假设默认值为 NULL ，

     $check_pic = mysqli_query($conn,"SELECT image FROM users WHERE id='$id'");

        $get_pic_row = mysqli_fetch_assoc($check_pic);

        $profile_pic_db = $get_pic_row['image'];

        $pro_num = mysqli_num_rows($profile_pic_db);

    if($pro_num == 1){

    if ($profile_pic_db == null) {

            $profile_pic = "http://localhost/Ramdhenu/images/default_propic.png";

        } else {

            $profile_pic = "http://localhost/Ramdhenu/userdata/Author_images/".$profile_pic_db ;

        }

    }else{

//user not found

}