prepare("select * from documents where regno = '$client_id'") ; $getfile->execute() ; if($getfile->rowcount() > 0) { $row = $getfile->fetch(pdo::FETCH_ASSOC) ; $img = $row['image'] ; } if(isset($_POST['submit'])) { /* * Custom function to compress image size and function compressImage($source, $destination, $quality) { // Get image info $imgInfo = getimagesize($source); $mime = $imgInfo['mime']; // Create a new image from file switch($mime){ case 'image/jpeg': $image = imagecreatefromjpeg($source); break; case 'image/JPEG': $image = imagecreatefromjpeg($source); break; case 'image/jpg': $image = imagecreatefromjpeg($source); break; case 'image/png': $image = imagecreatefrompng($source); break; case 'image/PNG': $image = imagecreatefrompng($source); break; case 'image/gif': $image = imagecreatefromgif($source); break; default: $image = imagecreatefromjpeg($source); } // Save image imagejpeg($image, $destination, $quality); // Return compressed image return $destination; } // File upload path $uploadPath = "documents/"; // If file upload form is submitted //$status = $statusMsg = ''; // $status = 'error'; if(!empty($_FILES["image"]["name"])) { // File info $fileName = basename($_FILES["image"]["name"]); $imageUploadPath = $uploadPath . $fileName; $fileType = pathinfo($imageUploadPath, PATHINFO_EXTENSION); // Allow certain file formats $allowTypes = array('jpg','JPG','JPEG','PNG','png','jpeg','gif'); if(in_array($fileType, $allowTypes)){ // Image temp source $imageTemp = $_FILES["image"]["tmp_name"]; $imageSize = $_FILES["image"]["size"]; // Compress size and upload image $compressedImage = compressImage($imageTemp, $imageUploadPath, 75); if($compressedImage) { $compressedImageSize = filesize($compressedImage); //$upd = $DBcon->prepare("update events set flyer = :f where sn =:sno") ; //$upd->bindparam(":f", $fileName) ; //$upd->bindparam(":sno",$od) ; if($user->updatedocument($client_id,$doc,$fileName)) { ?> Admin