将第一行数据返回到页面标题中

Question

我有一个联系人表和一个搜索表单，返回所搜索的联系人。所有的工作都很好。但是，是否有可能仅在页面顶部的单独div或span中显示第一行的实例?我在MS Access中看到过这一点，在php中是可能的吗?这是我的搜索查询，但我不知道如何回显或显示第一行仅为标题或标题div。

$sql = "SELECT * FROM people";
if( isset($_GET['search']) ){
$name = mysqli_real_escape_string($con, htmlspecialchars($_GET['search']));
$name2 = mysqli_real_escape_string($con, htmlspecialchars($_GET['search2']));
$sql = "SELECT * FROM people WHERE first_name ='$name' AND last_name= '$name2'";
}
$result = $con->query($sql);
?>
<?php
while($row = $result->fetch_assoc()){
?>
<tr>
<td><?php echo $row['people_id']; ?></td>
<td><?php echo $row['first_name']; ?></td>
<td><?php echo $row['last_name']; ?></td>
<td><?php echo $row['address']; ?></td>
<td><?php echo $row['contact']; ?></td>
</tr>
}

Answer 1

我只是想这样做(更新的答案):

$tableData = [];
$divData = "";
while ($row = $result->fetch_assoc()) {
// empty tableData --> first row
if (empty($tableData)) {
// do your special for the first row here (div)
$divData = "hello world! ".$row['first_name']." ".$row['last_name'];
}
$tableData[] ="<tr>
<td>".$row['people_id']."</td>
<td>".$row['first_name']."</td>
<td>".$row['last_name']."</td>
<td>".$row['address']."</td>
<td>".$row['contact']."</td>
</tr>";    
}
echo "<div>".$divData."</div>";
echo "<table>";
echo implode("n", $tableData);
echo "</table>";