
31/03/2004, 11:33
|
| | Fecha de Ingreso: febrero-2004 Ubicación: La Plata
Mensajes: 6
Antigüedad: 21 años Puntos: 0 | |
ok entonces aca va el codigo:
main1.php4
<?php
include "open_db.inc";
$sql = "SELECT * FROM tbl_Files ";
$sql .= "ORDER BY filename ASC";
$result = mysql_query($sql, $db);
$rows = mysql_num_rows($result);
echo "<table>\n";
echo " <tr>\n";
echo " <td>Filename</td>\n";
echo " <td>Type</td>\n";
echo " <td>Size</td>\n";
echo " <td>Description</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
for ($i = 0; $i < $rows; $i++) {
$data = mysql_fetch_object($result);
echo " <tr>\n";
echo " <td>$data->filename</td>\n";
echo " <td>$data->filetype</td>\n";
echo " <td>$data->filesize</td>\n";
echo " <td>( <a href='download1.php4?id=$data->filename'>Download</a> )</td>\n";
echo " <td>" . stripslashes($data->description) . "</td>\n";
echo " </tr>\n";
}
mysql_free_result($result);
mysql_close($db);
?>
download1.php
<?php
if ($id_files) {
include "conexion.php4";
$sql = "SELECT bin_data, filetype, filename, filesize FROM tbl_Files WHERE id_files='$id_files'";
$result = @mysql_query($sql, $db);
$data = @mysql_result($result, 0, "bin_data");
$name = @mysql_result($result, 0, "filename");
$size = @mysql_result($result, 0, "filesize");
$type = @mysql_result($result, 0, "filetype");
header("Content-Type: $type");
header("Content-Length: $size");
header("Content-Disposition: attachment; filename=".$name."");
header("Content-Description: PHP Generated Data");
echo $data;
echo $size;
}
?>
el resto de codigo que falta es del formulario y la pagina que hace el insert en la base pero es igual al que pubicaste en este foro
gracias
saludos
analau |