1. <!DOCTYPE html>
    2. <html>
    3. <head>
    4. <meta charset="utf-8" />
    5. <title></title>
    6. </head>
    7. <body>
    8. <table style="text-align: left;" border="1">
    9. <tr>
    10. <th>id</th>
    11. <th>名字</th>
    12. <th>年龄</th>
    13. <th>性别</th>
    14. <th>分类</th>
    15. </tr>
    16. <?php
    17. $get = $_GET['id'];
    18. echo $get;
    19. var_dump($get);
    20. //引用 admin1.php 文件,无需再次编写打开数据库的代码段
    21. require 'mysql.php';
    22. //sql语句
    23. $sql = "select * from article where id=$get";
    24. $retval = mysqli_query($conn, $sql); //执行
    25. //不加判断会报错
    26. if (!$retval) {
    27. printf("Error: %s\n", mysqli_error($conn));
    28. exit();
    29. }
    30. $row=mysqli_fetch_array($retval);
    31. echo '<tr><td>'.$row['id'].'</td><td>'.$row['title'].'</td><td>'.$row['content'].'</td><td>'.$row['date'].'</td><td>'.$row['class'].'</td></tr>';
    32. mysqli_close($conn);
    33. ?>
    34. </table>
    35. </body>
    36. </html>