Tengo un script en donde se suben imagenes a una base de datos y despues me la muestra en una tabla, estas imagenes se guardan en una carpeta del servisor, pero al momento de mostrarlas no me aparecen, pues la base de datos me guarda la ruta.
Como debo correguir este error.
Script de Subida de las Imagenes.
Código PHP:
<?php
include("conexion.php");
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die('Cannot select database');
if (isset($_POST['titulo'])){$titulo = $_POST['titulo'];}
if (isset($_POST['autor'])){$autor = $_POST['autor'];}
$unique = time();
$uploaddir = $_SERVER['DOCUMENT_ROOT'].'/upload/vehiculos/'.$unique;
$uploadfile1 = $uploaddir.$_FILES['im']['name'];
$uploadcheck1 = $uploadfile1;
$unique = time();
$uploaddir = $_SERVER['DOCUMENT_ROOT'].'/upload/vehiculos/'.$unique;
$uploadfile2 = $uploaddir.$_FILES['ima']['name'];
$uploadcheck2 = $uploadfile2;
$unique = time();
$uploaddir = $_SERVER['DOCUMENT_ROOT'].'/upload/vehiculos/'.$unique;
$uploadfile3 = $uploaddir.$_FILES['imagen']['name'];
$uploadcheck3 = $uploadfile3;
if(empty($_FILES['im']['name'])){
$uploadfile1 = "";}
if(empty($_FILES['ima']['name'])){
$uploadfile2 = "";}
if(empty($_FILES['imagen']['name'])){
$uploadfile3 = "";}
mysql_select_db($dbname) or die('Cannot select database');
$update = mysql_db_query("$dbname","INSERT INTO imagenes VALUES ('$id', '$titulo', '$autor', '$uploadfile1', '$uploadfile2', '$uploadfile3')") or die(mysql_error());
if (move_uploaded_file($_FILES['im']['tmp_name'], $uploadfile1))
if (move_uploaded_file($_FILES['ima']['tmp_name'], $uploadfile2))
if (move_uploaded_file($_FILES['imagen']['tmp_name'], $uploadfile3))
header("location:tabladatos1.php");
?>
Scrip de Respuesta
Código PHP:
<?php
include("conexion.php");
$connection = mysql_connect ($dbhost, $dbusername, $dbuserpass);
$db = mysql_select_db($dbname) or die('Cannot select database');
$query = "SELECT * FROM imagenes";
$result = mysql_query($query) or die("La consulta fallo: " .mysql_error());
while ($row = mysql_fetch_assoc($result))
{
?>
<tr>
<td><?php echo $row['titulo']; ?></td>
<td><?php echo $row['autor']; ?></td>
<td>
<a href="<?php echo $row['foto1'] ; ?> " " rel="lightbox[roadtrip]"><img src="<?php echo $row['foto1'] ; ?>" width="35" height="35" alt="" />
<a href="<?php echo $row['foto2'] ; ?> " " rel="lightbox[roadtrip]"><img src="<?php echo $row['foto2'] ; ?>" width="35" height="35" alt="" />
<a href="<?php echo $row['foto3'] ; ?> " " rel="lightbox[roadtrip]"><img src="<?php echo $row['foto3'] ; ?>" width="35" height="35" alt="" /></a>
</td>
</tr>
<?php
}
mysql_close($connection);
?>