Jquery File Upload

comicsans · Novembro 29, 2011

Galera eu não estou conseguindo grava os nomes das imagens no banco, utilizando o blueimp (upload de imagens), eu ate consegui , mas soh gravava quando tu atualizada a pagina, o Delete eu consegui fazer funcionar perfeitamente.Já tentei de inumeras formas, sem exito. Vou postar os codigos aqui pra vocês darem uma olhada:

Index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/themes/base/jquery-ui.css" id="theme">
<link rel="stylesheet" href="css/jquery.fileupload-ui.css">
<link rel="stylesheet" href="css/style.css">
</head>

<body>
<div id="fileupload">
   <form action="upload.php" method="POST" enctype="multipart/form-data">
       <div class="fileupload-buttonbar">
           <label class="fileinput-button">
               <span>Add files...</span>
               <input type="file" name="files[]" multiple>
           </label>
           <button type="submit" class="start">Start upload</button>
           <button type="reset" class="cancel">Cancel upload</button>
           <button type="button" class="delete">Delete files</button>
       </div>
   </form>
   <div class="fileupload-content">
       <table class="files"></table>
       <div class="fileupload-progressbar"></div>
   </div>
</div>
<script id="template-upload" type="text/x-jquery-tmpl">
   <tr class="template-upload{{if error}} ui-state-error{{/if}}">
       <td class="preview"></td>
       <td class="name">${name}</td>
       <td class="size">${sizef}</td>
       {{if error}}
           <td class="error" colspan="2">Error:
               {{if error === 'maxFileSize'}}File is too big
               {{else error === 'minFileSize'}}File is too small
               {{else error === 'acceptFileTypes'}}Filetype not allowed
               {{else error === 'maxNumberOfFiles'}}Max number of files exceeded
               {{else}}${error}
               {{/if}}
           </td>
       {{else}}
           <td class="progress"><div></div></td>
           <td class="start"><button>Start</button></td>
       {{/if}}
       <td class="cancel"><button>Cancel</button></td>
   </tr>
</script>
<script id="template-download" type="text/x-jquery-tmpl">
   <tr class="template-download{{if error}} ui-state-error{{/if}}">
       {{if error}}
           <td></td>
           <td class="name">${name}</td>
           <td class="size">${sizef}</td>
           <td class="error" colspan="2">Error:
               {{if error === 1}}File exceeds upload_max_filesize (php.ini directive)
               {{else error === 2}}File exceeds MAX_FILE_SIZE (HTML form directive)
               {{else error === 3}}File was only partially uploaded
               {{else error === 4}}No File was uploaded
               {{else error === 5}}Missing a temporary folder
               {{else error === 6}}Failed to write file to disk
               {{else error === 7}}File upload stopped by extension
               {{else error === 'maxFileSize'}}File is too big
               {{else error === 'minFileSize'}}File is too small
               {{else error === 'acceptFileTypes'}}Filetype not allowed
               {{else error === 'maxNumberOfFiles'}}Max number of files exceeded
               {{else error === 'uploadedBytes'}}Uploaded bytes exceed file size
               {{else error === 'emptyResult'}}Empty file upload result
               {{else}}${error}
               {{/if}}
           </td>
       {{else}}
           <td class="preview">
               {{if thumbnail_url}}
                   <a href="${url}" target="_blank"><img src="${thumbnail_url}"></a>
               {{/if}}
           </td>
           <td class="name">
               <a href="${url}"{{if thumbnail_url}} target="_blank"{{/if}}>${name}</a>
           </td>
           <td class="size">${sizef}</td>
           <td colspan="2"></td>
       {{/if}}
       <td class="delete">
           <button data-type="${delete_type}" data-url="${delete_url}">Delete</button>
       </td>
   </tr>
</script>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js"></script>
<script src="//ajax.aspnetcdn.com/ajax/jquery.templates/beta1/jquery.tmpl.min.js"></script>
<script src="js/jquery.iframe-transport.js"></script>
<script src="js/jquery.fileupload.js"></script>
<script src="js/jquery.fileupload-ui.js"></script>
<script src="js/application.js"></script>
</body>
</html>

Upload.php

<?php
/*
* jQuery File Upload Plugin PHP Example 5.2.7
* https://github.com/blueimp/jQuery-File-Upload
*
* Copyright 2010, Sebastian Tschan
* https://blueimp.net
*
* Licensed under the MIT license:
* http://creativecommons.org/licenses/MIT/
*/

error_reporting(E_ALL | E_STRICT);

class UploadHandler
{
   private $options;

   function __construct($options=null) {
       $this->options = array(
           'script_url' => $_SERVER['PHP_SELF'],
           'upload_dir' => dirname(__FILE__).'/files/',
           'upload_url' => dirname($_SERVER['PHP_SELF']).'/files/',
           'param_name' => 'files',
           // The php.ini settings upload_max_filesize and post_max_size
           // take precedence over the following max_file_size setting:
           'max_file_size' => null,
           'min_file_size' => 1,
           'accept_file_types' => '/.+$/i',
           'max_number_of_files' => null,
           'discard_aborted_uploads' => true,
           'image_versions' => array(
               // Uncomment the following version to restrict the size of
               // uploaded images. You can also add additional versions with
               // their own upload directories:
               /*
               'large' => array(
                   'upload_dir' => dirname(__FILE__).'/files/',
                   'upload_url' => dirname($_SERVER['PHP_SELF']).'/files/',
                   'max_width' => 1920,
                   'max_height' => 1200
               ),
               */
               'thumbnail' => array(
                   'upload_dir' => dirname(__FILE__).'/thumbnails/',
                   'upload_url' => dirname($_SERVER['PHP_SELF']).'/thumbnails/',
                   'max_width' => 80,
                   'max_height' => 80
               )
           )
       );

require('conecta_mysql.php');
       if ($options) {
           $this->options = array_replace_recursive($this->options, $options);
       }
   }

   private function get_file_object($file_name) {

       $file_path = $this->options['upload_dir'].$file_name;
       if (is_file($file_path) && $file_name[0] !== '.') {
           $file = new stdClass();
           $file->name = $file_name;

           $file->size = filesize($file_path);
           $file->url = $this->options['upload_url'].rawurlencode($file->name);
           foreach($this->options['image_versions'] as $version => $options) {

               if (is_file($options['upload_dir'].$file_name)) {

                   $file->{$version.'_url'} = $options['upload_url']
                       .rawurlencode($file->name);

               }
           }
           $file->delete_url = $this->options['script_url']
               .'?file='.rawurlencode($file->name);
           $file->delete_type = 'DELETE';

           return $file;
       }
       return null;
   }

   private function get_file_objects() {
       return array_values(array_filter(array_map(
           array($this, 'get_file_object'),
           scandir($this->options['upload_dir'])
       )));

   }

   private function create_scaled_image($file_name, $options) {
       $file_path = $this->options['upload_dir'].$file_name;
       $new_file_path = $options['upload_dir'].$file_name;
       list($img_width, $img_height) = @getimagesize($file_path);
       if (!$img_width || !$img_height) {
           return false;
       }
       $scale = min(
           $options['max_width'] / $img_width,
           $options['max_height'] / $img_height
       );
       if ($scale > 1) {
           $scale = 1;
       }
       $new_width = $img_width * $scale;
       $new_height = $img_height * $scale;
       $new_img = @imagecreatetruecolor($new_width, $new_height);
       switch (strtolower(substr(strrchr($file_name, '.'), 1))) {
           case 'jpg':
           case 'jpeg':
               $src_img = @imagecreatefromjpeg($file_path);
               $write_image = 'imagejpeg';
               break;
           case 'gif':
               @imagecolortransparent($new_img, @imagecolorallocate($new_img, 0, 0, 0));
               $src_img = @imagecreatefromgif($file_path);
               $write_image = 'imagegif';
               break;
           case 'png':
               @imagecolortransparent($new_img, @imagecolorallocate($new_img, 0, 0, 0));
               @imagealphablending($new_img, false);
               @imagesavealpha($new_img, true);
               $src_img = @imagecreatefrompng($file_path);
               $write_image = 'imagepng';
               break;
           default:
               $src_img = $image_method = null;
       }
       $success = $src_img && @imagecopyresampled(
           $new_img,
           $src_img,
           0, 0, 0, 0,
           $new_width,
           $new_height,
           $img_width,
           $img_height
       ) && $write_image($new_img, $new_file_path);
       // Free up memory (imagedestroy does not delete files):
       @imagedestroy($src_img);
       @imagedestroy($new_img);
       return $success;
   }

   private function has_error($uploaded_file, $file, $error) {
       if ($error) {
           return $error;
       }
       if (!preg_match($this->options['accept_file_types'], $file->name)) {
           return 'acceptFileTypes';
       }
       if ($uploaded_file && is_uploaded_file($uploaded_file)) {
           $file_size = filesize($uploaded_file);
       } else {
           $file_size = $_SERVER['CONTENT_LENGTH'];
       }
       if ($this->options['max_file_size'] && (
               $file_size > $this->options['max_file_size'] ||
               $file->size > $this->options['max_file_size'])
           ) {
           return 'maxFileSize';
       }
       if ($this->options['min_file_size'] &&
           $file_size < $this->options['min_file_size']) {
           return 'minFileSize';
       }
       if (is_int($this->options['max_number_of_files']) && (
               count($this->get_file_objects()) >= $this->options['max_number_of_files'])
           ) {
           return 'maxNumberOfFiles';
       }
       return $error;
   }

   private function handle_file_upload($uploaded_file, $name, $size, $type, $error) {
       $file = new stdClass();

       // Remove path information and dots around the filename, to prevent uploading
       // into different directories or replacing hidden system files.
       // Also remove control characters and spaces (\x00..\x20) around the filename:
       $file->name = trim(basename(stripslashes($name)), ".\x00..\x20");
       $file->size = intval($size);
       $file->type = $type;
       $error = $this->has_error($uploaded_file, $file, $error);
       if (!$error && $file->name) {
           $file_path = $this->options['upload_dir'].$file->name;
           $append_file = !$this->options['discard_aborted_uploads'] &&
               is_file($file_path) && $file->size > filesize($file_path);
           clearstatcache();
           if ($uploaded_file && is_uploaded_file($uploaded_file)) {
               // multipart/formdata uploads (POST method uploads)

               if ($append_file) {
                   file_put_contents(
                       $file_path,
                       fopen($uploaded_file, 'r'),
                       FILE_APPEND
                   );
               } else {
                   move_uploaded_file($uploaded_file, $file_path);
               }
           } else {
               // Non-multipart uploads (PUT method support)
               file_put_contents(
                   $file_path,
                   fopen('php://input', 'r'),
                   $append_file ? FILE_APPEND : 0
               );
           }
           $file_size = filesize($file_path);
           if ($file_size === $file->size) {
               $file->url = $this->options['upload_url'].rawurlencode($file->name);
               foreach($this->options['image_versions'] as $version => $options) {
                   if ($this->create_scaled_image($file->name, $options)) {
                       $file->{$version.'_url'} = $options['upload_url']
                           .rawurlencode($file->name);
                   }
               }
           } else if ($this->options['discard_aborted_uploads']) {
               unlink($file_path);
               $file->error = 'abort';
           }
           $file->size = $file_size;
           $file->delete_url = $this->options['script_url']
               .'?file='.rawurlencode($file->name);
           $file->delete_type = 'DELETE';
       } else {
           $file->error = $error;
       }
       return $file;
   }

   public function get() {
       $file_name = isset($_REQUEST['file']) ?
           basename(stripslashes($_REQUEST['file'])) : null; 	

       if ($file_name) {
           $info = $this->get_file_object($file_name);

       } else {
           $info = $this->get_file_objects();
       }
       header('Content-type: application/json');
       echo json_encode($info);

   }

   public function post() {

       $upload = isset($_FILES[$this->options['param_name']]) ?
           $_FILES[$this->options['param_name']] : array(
               'tmp_name' => null,
               'name' => null,
               'size' => null,
               'type' => null,
               'error' => null
           );

       $info = array();
       if (is_array($upload['tmp_name'])) {
           foreach ($upload['tmp_name'] as $index => $value) {
               $info[] = $this->handle_file_upload(
                   $upload['tmp_name'][$index],
                   isset($_SERVER['HTTP_X_FILE_NAME']) ?
                       $_SERVER['HTTP_X_FILE_NAME'] : $upload['name'][$index],
                   isset($_SERVER['HTTP_X_FILE_SIZE']) ?
                       $_SERVER['HTTP_X_FILE_SIZE'] : $upload['size'][$index],
                   isset($_SERVER['HTTP_X_FILE_TYPE']) ?
                       $_SERVER['HTTP_X_FILE_TYPE'] : $upload['type'][$index],
                   $upload['error'][$index]
               );
		/*$grava = "INSERT INTO fotos (imagemP, imagemG) VALUES ('$file_name', '$file_name')";
			$executa = mysql_query($grava) or die(mysql_error());
			*/
           }

       } else {
           $info[] = $this->handle_file_upload(
               $upload['tmp_name'],
               isset($_SERVER['HTTP_X_FILE_NAME']) ?
                   $_SERVER['HTTP_X_FILE_NAME'] : $upload['name'],
               isset($_SERVER['HTTP_X_FILE_SIZE']) ?
                   $_SERVER['HTTP_X_FILE_SIZE'] : $upload['size'],
               isset($_SERVER['HTTP_X_FILE_TYPE']) ?
                   $_SERVER['HTTP_X_FILE_TYPE'] : $upload['type'],
               $upload['error']
           );
       }
       header('Vary: Accept');
       if (isset($_SERVER['HTTP_ACCEPT']) &&
           (strpos($_SERVER['HTTP_ACCEPT'], 'application/json') !== false)) {
           header('Content-type: application/json');
       } else {
           header('Content-type: text/plain');
       }
       echo json_encode($info);
   }

   public function delete() {

       $file_name = isset($_REQUEST['file']) ?
           basename(stripslashes($_REQUEST['file'])) : null;

       $file_path = $this->options['upload_dir'].$file_name;
       $success = is_file($file_path) && $file_name[0] !== '.' && unlink($file_path);
	$deleta = "DELETE FROM fotos WHERE imagemP = '$file_name'";
$executa = mysql_query($deleta) or die(mysql_error());
       if ($success) {
           foreach($this->options['image_versions'] as $version => $options) {
               $file = $options['upload_dir'].$file_name;
               if (is_file($file)) {
                   unlink($file);

               }
           }

       }
       header('Content-type: application/json');
       echo json_encode($success);

   }

}

$upload_handler = new UploadHandler();

header('Pragma: no-cache');
header('Cache-Control: private, no-cache');
header('Content-Disposition: inline; filename="files.json"');
header('X-Content-Type-Options: nosniff');

switch ($_SERVER['REQUEST_METHOD']) {
   case 'HEAD':
   case 'GET':
       $upload_handler->get();
       break;
   case 'POST':
       $upload_handler->post();
       break;
   case 'DELETE':
       $upload_handler->delete();
       break;
   case 'OPTIONS':
       break;
   default:
       header('HTTP/1.0 405 Method Not Allowed');
}
?>

Desde já agradeço a atenção de vocês

Aguardo a resposta ou questionamentos :)

Obrigado

*BoyDeBone · Dezembro 5, 2011

Como você resolveu a questão do DELETE? Nao consegui fazer deletar as imagens no meu servidor.

Matheus Tavares · Dezembro 5, 2011

Como você resolveu a questão do DELETE? Nao consegui fazer deletar as imagens no meu servidor.

Crie um tópico novo, com o código problemático, para que possamos ajudar.

binzinho · Maio 27, 2014

amigo vc pode me manda seu sistema para eu adaptar e usar eu um projeto para a sala de aula obrigado

a£e× · Outubro 28, 2015

Amigo, já deve ter resolvido, mas vou deixar aqui a solução para futuras pesquisas de outros com o mesmo problema.

O único erro no seu código são os parâmetros usados no INSERT

Tente fazer assim:

$grava = "INSERT INTO fotos (imagemP, imagemG) VALUES ('".$upload['tmp_name'][$index]."', '".$upload['tmp_name'][$index]."');

Entrar

Arquivado

Jquery File Upload

Recommended Posts

comicsans 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

*BoyDeBone 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Matheus Tavares 167

Compartilhar este post

Link para o post

Compartilhar em outros sites

binzinho 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

a£e× 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

PHP+Codeigniter - Dúvida em Relação a Teclas

Conexão mysql com outro domínio

[Resolvido] JavaScript - Exibir logo dentro da Tabela html

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante