michaelyuen

Untitled

Mar 26th, 2017
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.01 KB | None | 0 0
  1. if (ISSET($_POST['submit'])) {
  2.     if (ISSET($_FILES)) {
  3.         $img = $_FILES['img']['name'];
  4.         $img_name = time().'_'.$_FILES['img']['name'];
  5.         $img_tmp_name = $_FILES['img']['tmp_name'];
  6.         $img_type = $_FILES['img']['type'];
  7.         $image_dir = "images/";
  8.                 // find previous image
  9.                 $query = "SELECT `image` from `imag` WHERE id = $id LIMIT 1";
  10.                 if ($result = mysqli_query($query)) {
  11.                     if (mysqli_num_rows($result) == 1) {
  12.                         $row = mysqli_fetch_assoc($result);
  13.                         $previous_image = 'images/'.$row['image'];
  14.                         if (file_exists($previous_image)) {
  15.                             unlink($previous_image);
  16.                         }
  17.                     }
  18.                 }
  19.         $query = "UPDATE `imag` SET `image` = '$img_name' WHERE id = $id";
  20.         echo $query;
  21.         // if (move_uploaded_file($img_tmp_name,$image_dir.$img_name)) {
  22.             // if(!$run = mysqli_query($con,$query)) {
  23.                 // $error = 'Update Fail';
  24.             // }
  25.         // } else {
  26.             // $error = 'Fail to upload';
  27.         // }
  28.     }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment