Publicado em 22 de jun.

Upload de Arquivos no Banco de Dados

Olá prezados,
Estou com uma grande dúvida para fazer o upload de arquivos no banco de dados, eu consigo enviar os arquivos normalmente utilizando o move_uploaded_file, porém o meu problema é que no banco de dados aparece apenas um arquivo, vamos supor que o cliente envie 3 arquivos, os três arquivos aparecem na pasta ao efetuar o upload, porém no banco de dados aparece apenas um dos arquivos, segue abaixo o código da página:

<?php require_once('Connections/conteste.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

 if (PHP_VERSION < 6) {
 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 }

 $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 switch ($theType) {
 case "text":
 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
 break;
 case "long":
 case "int":
 $theValue = ($theValue != "") ? intval($theValue) : "NULL";
 break;
 case "double":
 $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
 break;
 case "date":
 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
 break;
 case "defined":
 $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
 break;
 }
 return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
 $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
	if(isset($_FILES['file'])) {
 $name = $_FILES['file']['name'];
 $type = $_FILES['file']['type'];
 $size = $_FILES['file']['size'];
}

$message = '';

if(is_array($_FILES['file']['error'])) {
 foreach ($_FILES['file']['error'] as $code) {
 switch ($code) {
 case UPLOAD_ERR_OK:
 $message .= "";
 break;
 case UPLOAD_ERR_INI_SIZE:
 $message .= "O upload do arquivo excedeu o tamanho máximo de upload (upload_max_filesize) do php.ini<br/>";
 break;
 case UPLOAD_ERR_FORM_SIZE:
 $message .= "O upload do arquivo excedeu o tamanho máximo de upload (MAX_FILE_SIZE) que foi especificado no formulário HTML<br/>";
 break;
 case UPLOAD_ERR_PARTIAL:
 $message .= "O upload do arquivo foi carregado parcialmente<br/>";
 break;
 case UPLOAD_ERR_NO_FILE:
 $message .= "Nenhum arquivo foi carregado<br/>";
 break;
 case UPLOAD_ERR_NO_TMP_DIR:
 $message .= "Missing a temporary folder<br/>";
 break;
 case UPLOAD_ERR_CANT_WRITE:
 $message .= "Falha ao escrever o arquivo no disco<br/>";
 break;
 case UPLOAD_ERR_EXTENSION:
 $message .= "File upload stopped by extension<br/>";
 break;
 default:
 $message .= "Erro de Upload Desconhecido<br/>";
 break;
 }
 }
} elseif(isset($_FILES['file']['error'])) {
 $code = $_FILES['file']['error'];
 switch ($code) {
 case UPLOAD_ERR_OK:
 $message .= "";
 break;
 case UPLOAD_ERR_INI_SIZE:
 $message .= "The uploaded file exceeds the upload_max_filesize directive in php.ini<br/>";
 break;
 case UPLOAD_ERR_FORM_SIZE:
 $message .= "The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form<br/>";
 break;
 case UPLOAD_ERR_PARTIAL:
 $message .= "The uploaded file was only partially uploaded<br/>";
 break;
 case UPLOAD_ERR_NO_FILE:
 $message .= "No file was uploaded<br/>";
 break;
 case UPLOAD_ERR_NO_TMP_DIR:
 $message .= "Missing a temporary folder<br/>";
 break;
 case UPLOAD_ERR_CANT_WRITE:
 $message .= "Failed to write file to disk<br/>";
 break;
 case UPLOAD_ERR_EXTENSION:
 $message .= "File upload stopped by extension<br/>";
 break;
 default:
 $message .= "Unknown upload error<br/>";
 break;
 }
} elseif(!isset($_FILES['file'])) {
 $message = "No files recieved<br/>";
}

$uploaddir = 'pedidos';

if(is_array($_FILES['file']['name'])) {
 foreach ($_FILES['file']['name'] as $k=>$filename) {

 for ($k = 0; $k < count($_FILES['file']['name']); $k++){

 $uploadfile = getcwd()."/".$uploaddir."/".$k.$filename;
 if(move_uploaded_file($_FILES['file']['tmp_name'][$k], $uploadfile)) {
 // ok
 } else {
 $message .= "Erro enquanto carregava o arquivo ".$filename."<br/>";
 }

 }//fecha

 }
} elseif(isset($_FILES['file']['name'])) {

	for ($k = 0; $k < count($_FILES['file']['name']); $k++){

 $uploadfile = getcwd()."/".$uploaddir."/".$_FILES['file']['name'][$k];
 if(move_uploaded_file($_FILES['file']['tmp_name'][$k], $uploadfile)) {
 // ok
 } else {
 $message = "Erro enquanto carregava o arquivo ".$_FILES['file']['name']."<br/>";
 }

	}//fecha

}
 $insertSQL = sprintf("INSERT INTO pedidos (id, nome, empresa, telefone, celular, email, observacoes, arquivos) VALUES (%s, %s, %s, %s, %s, %s, %s, '$uploadfile')",
 GetSQLValueString($_POST['id'], "int"),
 GetSQLValueString($_POST['nome'], "text"),
 GetSQLValueString($_POST['empresa'], "text"),
 GetSQLValueString($_POST['telefone'], "int"),
 GetSQLValueString($_POST['celular'], "int"),
 GetSQLValueString($_POST['email'], "text"),
 GetSQLValueString($_POST['observacoes'], "text"));

 mysql_select_db($database_conteste, $conteste);
 $Result1 = mysql_query($insertSQL, $conteste) or die(mysql_error());

 $insertGoTo = "envio-sucesso.php";
 if (isset($_SERVER['QUERY_STRING'])) {
 $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
 $insertGoTo .= $_SERVER['QUERY_STRING'];

 }
 header(sprintf("Location: %s", $insertGoTo));
 }

?>

<!DOCTYPE html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento sem título</title>

 <link rel="shortcut icon" href="../favicon.ico">
 <link rel="stylesheet" type="text/css" href="css/demo.css" />
 <link rel="stylesheet" type="text/css" href="css/style1.css" />
 <link rel="stylesheet" type="text/css" media="all" href="styles.css" />
 <link href="//fonts.googleapis.com/css?family=Raleway:400,300,600" rel="stylesheet" type="text/css">
 <link rel="stylesheet" href="pe-icon-7-stroke/css/pe-icon-7-stroke.css">
 <link rel="stylesheet" href="css/drop_uploader.css">

 <script type="text/javascript" src="js/modernizr.custom.86080.js"></script>
 <script src="js/jquery-2.2.4.min.js"></script>
 <script src="js/drop_uploader.js"></script>

 <script>
 $(document).ready(function(){
 $('input[type=file]').drop_uploader({
 uploader_text: 'Drop files to upload, or',
 browse_text: 'Browse',
 browse_css_class: 'button button-primary',
 browse_css_selector: 'file_browse',
 uploader_icon: '<i class="pe-7s-cloud-upload"></i>',
 file_icon: '<i class="pe-7s-file"></i>',
 time_show_errors: 5,
 });
 });
 </script>

 </head>
 <body id="page">
 <ul class="cb-slideshow">
 <li><span>Image 01</span><div><h3></h3></div></li>
 <li><span>Image 02</span><div><h3></h3></div></li>
 <li><span>Image 03</span><div><h3></h3></div></li>
 <li><span>Image 04</span><div><h3></h3></div></li>
 <li><span>Image 05</span><div><h3></h3></div></li>
 <li><span>Image 06</span><div><h3></h3></div></li>
 </ul>
 <div class="container">
 <div id="logo"><img src="images/logo.png"/></div>
 <form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1" id="form1">
 <h1 id="titulo-upload">Upload de Arquivos</h1>
 <div id="itens-form">
 <div class="twelve column"><input type="file" name="file[]" multiple></div>
 <p>

 <input type="hidden" name="id" id="id" />
 <input type="text" name="empresa" id="empresa" class="campos" placeholder="Empresa"/>
 </p>
 <p>
 <input type="text" name="nome" id="nome" class="campos" placeholder="Nome completo"/>
 </p>
 <p>
 <input type="text" name="telefone" id="telefone" class="campos" placeholder="Telefone"/>
 </p>
 <p>
 <input type="text" name="celular" id="celular" class="campos" placeholder="Celular"/>
 </p>
 <p>
 <input type="text" name="email" id="email" class="campos" placeholder="E-mail"/>
 </p>
 <p>
 <textarea name="observacoes" id="observacoes" cols="45" rows="5" placeholder="Observações"></textarea>
 </p>

 <p>
 <input type="submit" name="enviar" id="enviar" value="Enviar" />
 </p>
 <input type="hidden" name="MM_insert" value="form1" />
 </div>
 </form>

 <div class="clr"></div>
 </div><!--/ Codrops top bar -->

 </div>

</body>
</html>

Discussão (2)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

Carregando comentários...