adding table

**davidjmorin** · 11-24-2007, 05:27 PM

how do i add a table to the following script? so that each link is in a row.

PHP Code:


<?

if(isset($_GET['id']))

{

include 'config.php';

include 'opendb.php';



$id = $_GET['id'];

$query = "SELECT name, type, size, content FROM upload WHERE id = '$id'";

$result = mysql_query($query) or die('Error, query failed');

list($name, $type, $size, $content) = mysql_fetch_array($result);



header("Content-Disposition: attachment; filename=$name");

header("Content-length: $size");

header("Content-type: $type");

echo $content;



include 'closedb.php';

exit;

}



?>

<html>

<head>

<title>Download File From MySQL</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>



<body>

<?

include 'config.php';

include 'opendb.php';



$query = "SELECT id, name FROM upload";

$result = mysql_query($query) or die('Error, query failed');

if(mysql_num_rows($result) == 0)

{

echo "Database is empty <br>";

}

else

{

while(list($id, $name) = mysql_fetch_array($result))

{

?>

<a href="download.php?id=<?=$id;?>"><?=$name;?></a> <br>



<?

}

}

include 'closedb.php';

?>

</body>

</html>

**thetestingsite** · 11-24-2007, 05:29 PM

Code:

<?
if(isset($_GET['id']))
{
include 'config.php';
include 'opendb.php';

$id = $_GET['id'];
$query = "SELECT name, type, size, content FROM upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);

header("Content-Disposition: attachment; filename=$name");
header("Content-length: $size");
header("Content-type: $type");
echo $content;

include 'closedb.php';
exit;
}

?>
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?
include 'config.php';
include 'opendb.php';

$query = "SELECT id, name FROM upload";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
?>
 <!--Table Goes Here-->
<table>

<?php
while(list($id, $name) = mysql_fetch_array($result))
{
?>
 <tr>
  <td><a href="download.php?id=<?=$id;?>"><?=$name;?></a></td>
 </tr>

<?php
}
?>

<!--End Table-->
</table>

<?php
}
include 'closedb.php';
?>
</body>
</html>

Hope this helps.

Thread: adding table

Thread Tools

Search Thread

adding table

Bookmarks

Bookmarks

Posting Permissions