How introduce anchor links when fetching a url from SQL database using PHP?

Question

This is the PHP script and I can load my data in database but elements in the Link row seems not clickable .so that I redirect the user. My attempt was to add anchor() tags similar to table definition but its still inactive.

<?php
$con=mysqli_connect($server,$user,$password,$dbname);
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM accident_log");

echo "<table border='1'>
<tr>
<th>ID</th>
<th>Link</th>
</tr>";

while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td>" . $row['ID'] . "</td>";
echo "<a><td>" . $row['Link'] . "</td></a>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

@RamondeVries You should also provide the text for the link otherwise it will show as blank. — Dharman, Oct 13 '19 at 16:07
@Dharman that's right, UPDATE: `echo "" . $row['Link'] . "";` — Ramon de Vries, Oct 13 '19 at 16:09
As a side note, you are not checking for mysqli errors properly. You need to enable exceptions. [How to get the error message in MySQLi?](https://stackoverflow.com/a/22662582/1839439) — Dharman, Oct 13 '19 at 16:11
@RamondeVries Rather than posting possible answers in comments, an answer would be more fitting, IMHO. — Funk Forty Niner, Oct 13 '19 at 16:11
@FunkFortyNiner i understand, but i cannot run his code myself, therefor i'm not 100% sure my solution works, in that case. I'd rather not post it as an anwser — Ramon de Vries, Oct 13 '19 at 16:19
@RamondeVries Post is as a community wiki and then everyone can chip in and edit to make it better. Comments are only for asking for clarifications. — Dharman, Oct 13 '19 at 16:48

SimpleMix · Accepted Answer · 2019-10-13T15:43:59.260

-4

Learn here if you do not know https://www.w3schools.com

echo '<td><a href="' . $row['link'] . '">' . $row['link'] . '</a></td>';
echo '<td><a href="' . $row['link'] . '" style="background: #09f; color: #fff; padding: 10px 20px;">' . $row['link'] . '</a></td>';

edited Oct 13 '19 at 15:43

answered Oct 13 '19 at 15:42

SimpleMix

16
1

3

Do not suggest w3schools.com for learning PHP. They are know to provide really bad examples. If you want to teach something be kind and explain your answer to the OP. An answer which just tells them to learn something from some website is low quality and might get downvoted. – Dharman Oct 13 '19 at 16:06
Examples are excellent, especially for beginners. I don't collect your points. I always answer the question from the new user. – SimpleMix Oct 13 '19 at 16:24

How introduce anchor links when fetching a url from SQL database using PHP?

1 Answers1