window.location="../appointment_details.php?msg1=failure";'; // if everything is ok, try to upload file } else { if (move_uploaded_file($_FILES["mem_file"]["tmp_name"], $target_file)) { mysqli_query($conn, "update tbl_member set upload_photo='$file_name' where id='$mem_id'"); echo ''; } else { echo ''; } } }elseif(isset($_POST['delete'])){ $mem_id = $_POST['mem_id']; $get_fi = mysqli_query($conn, "select upload_photo from tbl_member where id='$mem_id' "); $get_file = mysqli_fetch_array($get_fi, MYSQLI_ASSOC); $file_name = "../uploads/".$get_file['upload_photo']; unlink($file_name); $check=mysqli_query($conn, "update tbl_member set upload_photo=NULL where id='$mem_id'"); if($check){ echo ''; }else{ echo ''; } } ?>