PHP搜索中的超链接 - Hyperlink in PHP search

Hyperlink in PHP search

本文关键字：超链接搜索 PHP | 更新日期: 2023-09-27

下午好，我对编程很陌生，过去两天我一直在寻找问题的答案，但似乎什么都做不到。我有一个搜索框，查找名字和姓氏，然后显示基于该搜索的结果。它显示的项目之一是一个网站，但它仅以文本形式显示。如何将网站显示为超链接$行["网站"]感谢大家的帮助！！

<?php
// connect to the database
include("connect.php");
$tyt = $_POST['submit'];
$txt = $_POST['submit2'];

$sql = "SELECT * FROM burials WHERE Lname like '$txt%' AND Fname like'%$tyt%' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
         echo "<br> ". $row["Location"]. 
         "<br>" . $row["Fname"]. " " . $row["Lname"] .
         " <br> Date of Birth: " . $row["DateOfBirth"]. 
         " <br> Date of Death: ".$row["DateOfDeath"].
         " <br> ". $row["Website"]. 
         "<br>";
     }
 } else {
     echo "0 results";
 }
 ?>

<?php
$conn->close();
?>

使用此：

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

在您的代码中：

<?php
// connect to the database
include("connect.php");
$tyt = $_POST['submit'];
$txt = $_POST['submit2'];

$sql = "SELECT * FROM burials WHERE Lname like '$txt%' AND Fname like'%$tyt%' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
         echo "<br> ". $row["Location"]. 
         "<br>" . $row["Fname"]. " " . $row["Lname"] .
         " <br> Date of Birth: " . $row["DateOfBirth"]. 
         " <br> Date of Death: ".$row["DateOfDeath"].
         " <br> <a href='"". $row["Website"].."'">". $row["Website"]. 
         "</a><br>";
     }
 } else {
     echo "0 results";
 }
$conn->close();
?>

这应该可以工作。您需要在回声中添加一个锚标记。

  <?php
        // connect to the database
        include("connect.php");
        $tyt = $_POST['submit'];
        $txt = $_POST['submit2'];

        $sql = "SELECT * FROM burials WHERE Lname like '$txt%' AND Fname like'%$tyt%' ";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            // output data of each row
            while($row = $result->fetch_assoc()) {
                echo "<br> ". $row["Location"].
                "<br>" . $row["Fname"]. " " . $row["Lname"] .
                " <br> Date of Birth: " . $row["DateOfBirth"].
                " <br> Date of Death: ".$row["DateOfDeath"].
                // add anchor tag around result from DB
                " <br> <a href=". $row["Website"].">".$row["Website"]."</a>"
                "<br>";
            }
        } else {
        echo "0 results";
        }
    ?>

    <?php
    $conn->close();
    ?>