Search code examples
phphref

Adding php variable into a href link into a table

I am working on uploading a file along with a description and table and then displaying it in a table format. My problem is that I'm not sure how to link my the path for the uploaded file into the table so the user can click on the link in the table and it will download.

Code: This is what I'm attempting to use>

<?php
include 'connect.php';


$result = mysqli_query($con,"SELECT DocDate, Description, DocFile FROM Documents");
echo "<table border='0' width='100%'>
<col width='50'>
<col width='100'>
<tr>
<th>Date</th>
<th>Description</th>
<th>File</th>
</tr>";

while($row = mysqli_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['DocDate'] . "</td>";
  echo "<td>" . $row['Description'] . "</td>";
  echo "<td>" <a href="uploads/$row['DocFile']">$row['DocFile']</a> "</td>";
  echo "</tr>";
  }
echo "</table>";

mysqli_close($con);
?>

If you feel it to be usefull I'm happy to add the code where I upload the file to my server.

EdiT Sorry I put in the wrong variable thing into my table, I don't think it changes it too much

Solution

  • Is this what you're looking for?

    while($row = mysqli_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['DocDate'] . "</td>";
  echo "<td>" . $row['Description'] . "</td>";
  echo "<td> <a href=\"uploads/" . $row['DocFile'] . "\"> " . $row['DocFile'] . " </a> </td>";
  echo "</tr>";
  }