Need to convert MySQL data block for a hyperlink using PHP

Question

I have a table being displayed that converts a file uploaded location (DocLoc) into a hyperlink. However, because the filename has spaces in it, the hyperlink drops them off. If I display the column docloc it shows:

uploading/minegem/GUI-MGEM-001 Bullet Programming.pdf

However, when I click the hyperlink I get

uploading/minegem/GUI-MGEM-001

How can I have the hyperlink add the rest of the filename so I can open the file from the link?

// Printing table rows
while($row = mysql_fetch_array($result))
{
    $docname=$row['DocName'];
    $docver=$row['DocVer'];
    $doctype=$row['DocType'];
    $docloc=$row['DocLoc'];

    echo "<tr>";
    echo "<td><a href=/uploading/$docloc>$docname</a></td>";
    echo "<td>$docver</td>";
    echo
    echo "</tr>";
}
echo "</table>";

Sorry if this is stupid, I have done a bit of googling and reading around here and I'm struggling. I only started learning PHP, MySQL, and HTML about three days ago.

Its a good trick to learn early on to look carefully at the source code of your HTML output, if you are attuned to what is/not valid HTML then you would have perhaps spotted the reason for the error, just sayin'. — Cups
– Cups, Commented Jul 7, 2012 at 8:57

Yan Berk · Accepted Answer · 2012-07-07 08:48:29Z

2

Encode the URL using urlencode:

echo '<td><a href="/uploading/'.urlencode($docloc).'">'.$docname.'</a></td>';

answered Jul 7, 2012 at 8:48

Yan Berk

14.5k9 gold badges58 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Brad Over a year ago

Don't forget the quotes around the URL value for the HREF attribute. <a href="" />

Collectives™ on Stack Overflow

Need to convert MySQL data block for a hyperlink using PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related