subir archivos con base de datos
Código:
creo que no me toma la variable para igualar al string<?php
//$upload_dir ="data/img_proyectos/";
$upload_dir = "images_dir/";
//number of files to upload.
$num_files = 4;
//nombres de archivo
$nombre_archivo=0;
//the file size in bytes.
$size_bytes =5120000; //512000 bytes = 500KB.
//Extensions you want files uploaded limited to.
$limitedext = array(".gif",".jpg",".jpeg",".png",".txt",".doc"," .html",".htm",".zip",".rar",".gz");
//nombres de archivos
$nombres=date(dmyhms);
//check if the directory exists or not.
if (!is_dir("$upload_dir")) {
die ("Error: The directory <b>($upload_dir)</b> doesn't exist");
}
//check if the directory is writable.
if (!is_writeable("$upload_dir")){
die ("Error: The directory <b>($upload_dir)</b> is NOT writable, Please CHMOD (777)");
}
//if the form has been submitted, then do the upload process
//infact, if you clicked on (Upload Now!) button.
if (isset($_POST['upload_form'])){
echo "<h3>Resultados:</h3>";
//do a loop for uploading files based on ($num_files) number of files.
for ($i = 1; $i <= $num_files; $i++)
{
$nombre_archivo=$nombre_archivo + 1;
//define variables to hold the values.
$new_file = $_FILES['file'.$i];
$file_name= $nombres.$nombre_archivo.".jpg";
//}
//$file_name = $new_file['name'];
//to remove spaces from file name we have to replace it with "_".
$file_name = str_replace('', '_', $file_name);
$file_tmp = $new_file['tmp_name'];
$file_size = $new_file['size'];
$file_type = $new_file['type'];
#-----------------------------------------------------------#
# this code will check if the files was selected or not. #
#-----------------------------------------------------------#
if (!is_uploaded_file($file_tmp)) {
//print error message and file number.
echo "File $i: Not selected.<br>";
}else{
#-----------------------------------------------------------#
# this code will check file extension #
#-----------------------------------------------------------#
$ext = strrchr($file_name,'.');
if (!in_array(strtolower($ext),$limitedext)) {
echo "File $i: ($file_name) Wrong file extension. <br>";
}else{
#-----------------------------------------------------------#
# this code will check file size is correct #
#-----------------------------------------------------------#
if ($file_size > $size_bytes){
echo "File $i: ($file_name) Faild to upload. File must be <b>". $size_bytes / 1024 ."</b> KB. <br>";
}else{
#-----------------------------------------------------------#
# this code check if file is Already EXISTS. #
#-----------------------------------------------------------#
if(file_exists($upload_dir.$file_name)){
echo "File $i: ($file_name) already exists.<br>";
}else{
#-----------------------------------------------------------#
# this function will upload the files. :) ;) cool #
#-----------------------------------------------------------#
if (move_uploaded_file($file_tmp,$upload_dir.$file_name))
{
echo "File $i: ($file_name) Uploaded.<br>";
}else{
echo "File $i: Faild to upload.<br>";
}#end of (move_uploaded_file).
}#end of (file_exists).
}#end of (file_size).
}#end of (limitedext).
}#end of (!is_uploaded_file).
/**************************************INGRESOS DE REGISTROS******************************************************************/
//}#end of archivo
}#end of (for loop).
if ($i=1)
{
$file_name1=$file_name;
}
if($i=2)
{
$file_name2=$file_name;
}
if($i=3)
{
$file_name3=$file_name;
}
if($i=4)
{
$file_name4=$file_name;
}
/******************************************************************/
# print back button.
//echo "»<a href=\"$_SERVER[PHP_SELF]\">back</a>";
////////////////////////////////////////////////////////////////////////////////
//else if the form didn't submitted then show it.
}
else
{
echo " <h3>Seleccion los Archivos a subir!.</h3>
Maximo tamaño a subir = ". $size_bytes / 1024 ." KB";
echo "<form method=\"post\" action=\"$_SERVER[PHP_SELF]\" enctype=\"multipart/form-data\">";
// show the file input field based on($num_files).
for ($i = 1; $i <= $num_files; $i++)
{
echo "File $i: <input type=\"file\" name=\"file". $i ."\"><br>";
}
echo " <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"$size_bytes\">
<input type=\"submit\" name=\"upload_form\" value=\"Subir Archivos!\">
</form>";
}
include("data/dbapertura.php");
//seleccionamos el orden
$sql1=mysql_query("select max(pro_orden) + 5 as resultado from asinpro.proyectos");
$pro_orden=mysql_fetch_array($sql1);
//seleccionamos el codigo
$sql2=mysql_query("select cli_codigo from clientes where cli_nombre='$_POST[cli_nombre]'" );
$cli_codigo=mysql_fetch_array($sql2);
$pro_codigo=$_POST[codigo_pro];
$pro_codigo_act=$pro_codigo;
//ingresamos los datos a la tabla proyecto
if (isset($_POST['btnguardar']))
{
//date_default_timezone_set('America/Santiago');
$fecha_ing=date("Y-m-d H:m:s");
mysql_query("insert into proyectos(pro_codigo, cli_codigo, pro_nombre, pro_lugar,pro_ano, pro_detalle, pro_fec_ing, pro_fec_mod, pro_publicar, pro_orden)"
." values('$_POST[codigo_pro]','$cli_codigo[cli_codigo]','$_POST[nombre_pro]','$_POST[lugar_pro]',' $_POST[ano_pro]','$_POST[pro_detalle]','$fecha_ing', 'null', '$_POST[publicar_pro]','$pro_orden[resultado]')") OR die("Error". mysql_error());
echo"<font size=\"10\">Seguimos con el ingreso de fotos</font>";
}
else
{
echo"registro no ingresado";
mysql_query("update asinpro.proyectos set pro_imagen_1='file_name1', pro_imagen_2='$file_name2', pro_imagen_3='$file_name3', pro_imagen_4='$file_name4' where pro_codigo='$pro_codigo_act'");
}
?>
