php - 在 PHP 中链接 SQL 查询结果

Question

我有一个 sql 查询，从 sql 数据库中搜索学生姓名，它显示结果，现在我想链接每个结果 http url www.tlss.edu.pk/result.php?r=1如果 Sr_=1我的 SQL 查询是

<?php
include 'form.html';
$r1=$_GET["r"];
$n1=$_GET["n"];
// Create connection
$con=mysqli_connect("localhost","chumspai_tlss","Tls121","chumspai_tlsResult");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  echo $n1;
$result = mysqli_query($con,"SELECT * FROM nursery_blue_ WHERE students_names like '%$n1%'");

while($row = mysqli_fetch_array($result))
{

echo '<pre>';
    print_r ($row['sr_']. '.'. $row['students_names']);
    echo '</pre>';
  }
    ?>

Answer 1

在循环中添加一个链接，如果有任何条件，请添加显示链接的条件

while($row = mysqli_fetch_array($result)) {
   echo "<a href='http://www.tlss.edu.pk/result.php?r=".$row['sr_']."'>".$row['students_names']."</a>";
 }