从HTML表单到PHP页面的URL链接

I have read a lot of submissions, I haven't been able to find an answer to my exact question.

I am filling out an HTML form that is sent into mysql database - I am good there.

The results are displayed using php in a html table. I would like the website URL to show as a hyperlink. Everything I do results in an error.

Does anyone know how I can update my code to allow for the website url to show as a hyperlink?

[$dbname = "seller";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT website, url, price, name, email FROM listing";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
     echo "<table><tr><th>Website</th><th>URL</th><th>Price</th><th>Contact      Name</th><th>Email</th></tr>";
     // output data of each row
     while($row = $result->fetch_assoc()) {
         echo "<tr><td>" . $row["website"]. "</td><td>" . $row["url"]. "  </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";
     }
     echo "</table>";
} else {
     echo "0 results";
}

$conn->close();
?>]

Thanks

Have you tried this...

echo "<tr><td></td><td><a href='" . $row['url']. "'>" . $row['website']. "</a>  </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";

You could also just change 'Link to website' to " . $row["website"]. " for it to display the link

use <a> tag, please see this link.

'<a href="' . $row['url'] . '">' . $row['url'] . '</a>'

If you use an a tag it should work.

<a href="' . $row['url'] . '">URL</a>

echo "<tr><td><a href=\"{$row['url']}>{$row['website']}</a></td>...etc

You should also consider closing the tags to get a cleaner code:

<?php if ($condition) { ?>
    <div>HTML code!</a>
<?php } ?>

That will be great if you can show me the error otherwise Try this:

while($row = $result->fetch_assoc()) {
     echo "<tr><td>" . $row["website"]. "</td><td><a href='".$row["url"]."'>Link</a> </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";
 }

Add an anchor tag <a href=""> inside the table data tag <td> inside your while loop.

Change this line:

echo "<tr><td>".$row["website"]."</td><td>".$row["url"]."  </td><td>".$row["price"]."</td><td>".$row["name"]."</td><td> ".$row["email"]."</td></tr>";

Into this:

echo "<tr><td><a href='".$row["website"]."'>".$row["website"]."</a></td><td>".$row["url"]."  </td><td>".$row["price"]."</td><td>".$row["name"]."</td><td> ".$row["email"]."</td></tr>";

use this

echo '<tr><td>' . $row["website"]. '</td><td><a href=" ' . $row["url"]. ' ">'; echo $row["name"];    echo'  </a> </td><td>' . $row["price"]. '</td><td>' . '</td><td> ' .    $row["email"]. '</td></tr>';

instead of

echo "<tr><td>" . $row["website"]. "</td><td>" . $row["url"]. "  </td><td>" . $row["price"]. "</td><td>" . $row["name"]. "</td><td> " .    $row["email"]. "</td></tr>";