PhpMyAdmin数据库怎么查找某个数据并提取整行字段数据

Question

那获取指定数据呢？比如前端页面里的文章页面，每个文章都有一个唯一id，当我点击目标文章的时候获取到那个字段的内容，因为那个字段的内容不止id，可能还有图片链接啊，文章内容啊，昵称啊，发布时间啊等等这些，求指点。

mysqli_query($conn,"set names utf8");
$sql = "SELECT * FROM index_vido WHERE uid='$getUid'";
$res = mysqli_query($conn ,$sql);
$row = mysqli_fetch_assoc($res);

Answer 1

简单示例代码如下，有帮助麻烦点个采纳【本回答右上角】，谢谢~~有其他问题可以继续交流~

list.php，列表页

<meta charset="utf-8">
<table border='1'>
<?php
$conn=mysqli_connect("localhost","root","123456","test");
mysqli_query($conn,"set names utf8");
$sql = "SELECT uid,title,addtime FROM index_vido";
$res = mysqli_query($conn ,$sql);
if(mysqli_num_rows($res)>0){
  while($row = mysqli_fetch_assoc($res)){
     echo "<tr><td><a target='_blank' href=\"detail.php?id={$row['uid']}\">{$row['title']}</a></td><td>{$row['addtime']}</td></tr>";
  }
}
else echo "<tr><td>找不到uid为{$getUid}的记录</td></tr>";
?>
</table>
<div id="content"></div>
<script src="https://g.csdnimg.cn/??lib/jquery/1.12.4/jquery.min.js"></script>
<script>
$('a').click(function(){
$('#content').load(this.href)
return false;
});
</script>

detail.php，详细页面

 <?php
$getUid=$_GET["id"];///获取参数
$conn=mysqli_connect("localhost","root","123456","test");
mysqli_query($conn,"set names utf8");

$sql = "SELECT * FROM index_vido WHERE uid='$getUid'";
$res = mysqli_query($conn ,$sql);
if(mysqli_num_rows($res)>0){
  $row = mysqli_fetch_assoc($res);
  echo "标题：".$row["title"]."<br>";
  echo "添加时间：".$row["addtime"]."<br>";
  echo "内容：".$row["content"]."<br>";
}
else echo "找不到uid为{$getUid}的记录";
?>