Het is me gelukt om een bestand te uploaden, waarvan een download link terug komt op een andere pagina.
Nu is het alleen niet gelukt om de downloadlinks te koppelen aan het juiste veld, dus nu komen alle downloadlinks in elk veld terug.
Het is de bedoeling dat elke download link gekoppeld is aan zijn eigen regel.
zie onderstaande afbeeldingen:
hieronder de code:
<?php require_once('Connections/wfc.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;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_rsUploadDownload = 5;
$pageNum_rsUploadDownload = 0;
if (isset($_GET['pageNum_rsUploadDownload'])) {
$pageNum_rsUploadDownload = $_GET['pageNum_rsUploadDownload'];
}
$startRow_rsUploadDownload = $pageNum_rsUploadDownload * $maxRows_rsUploadDownload;
mysql_select_db($database_wfc, $wfc);
$query_rsUploadDownload = "SELECT * FROM upload";
$query_limit_rsUploadDownload = sprintf("%s LIMIT %d, %d", $query_rsUploadDownload, $startRow_rsUploadDownload, $maxRows_rsUploadDownload);
$rsUploadDownload = mysql_query($query_limit_rsUploadDownload, $wfc) or die(mysql_error());
$row_rsUploadDownload = mysql_fetch_assoc($rsUploadDownload);
if (isset($_GET['totalRows_rsUploadDownload'])) {
$totalRows_rsUploadDownload = $_GET['totalRows_rsUploadDownload'];
} else {
$all_rsUploadDownload = mysql_query($query_rsUploadDownload);
$totalRows_rsUploadDownload = mysql_num_rows($all_rsUploadDownload);
}
$totalPages_rsUploadDownload = ceil($totalRows_rsUploadDownload/$maxRows_rsUploadDownload)-1;
$queryString_rsUploadDownload = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsUploadDownload") == false &&
stristr($param, "totalRows_rsUploadDownload") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsUploadDownload = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsUploadDownload = sprintf("&totalRows_rsUploadDownload=%d%s", $totalRows_rsUploadDownload, $queryString_rsUploadDownload);
?>
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p> </p>
<p>
<table border="1" align="center">
<tr>
<td>id</td>
<td>name</td>
<td>type</td>
<td>size</td>
<td>content</td>
</tr>
<?php do { ?>
<tr>
<td><a href="testdetail.php?id=<?php echo $row_rsUploadDownload['id']; ?>"> <?php echo $row_rsUploadDownload['id']; ?> </a></td>
<td><?php echo $row_rsUploadDownload['name']; ?> </td>
<td><?php echo $row_rsUploadDownload['type']; ?> </td>
<td><?php echo $row_rsUploadDownload['size']; ?> </td>
<td><?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=<?php echo urlencode($id);?>"><?php echo urlencode($name);?></a> <br>
<?php
}
}
?></td>
</tr>
<?php } while ($row_rsUploadDownload = mysql_fetch_assoc($rsUploadDownload)); ?>
</table>
<br>
<table border="0">
<tr>
<td><?php if ($pageNum_rsUploadDownload > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsUploadDownload=%d%s", $currentPage, 0, $queryString_rsUploadDownload); ?>">First</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_rsUploadDownload > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsUploadDownload=%d%s", $currentPage, max(0, $pageNum_rsUploadDownload - 1), $queryString_rsUploadDownload); ?>">Previous</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_rsUploadDownload < $totalPages_rsUploadDownload) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsUploadDownload=%d%s", $currentPage, min($totalPages_rsUploadDownload, $pageNum_rsUploadDownload + 1), $queryString_rsUploadDownload); ?>">Next</a>
<?php } // Show if not last page ?></td>
<td><?php if ($pageNum_rsUploadDownload < $totalPages_rsUploadDownload) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsUploadDownload=%d%s", $currentPage, $totalPages_rsUploadDownload, $queryString_rsUploadDownload); ?>">Last</a>
<?php } // Show if not last page ?></td>
</tr>
</table>
Records <?php echo ($startRow_rsUploadDownload + 1) ?> to <?php echo min($startRow_rsUploadDownload + $maxRows_rsUploadDownload, $totalRows_rsUploadDownload) ?> of <?php echo $totalRows_rsUploadDownload ?>
</p>
</body>
</html>
<?php
mysql_free_result($rsUploadDownload);
?>
