如何使用 ？在网址中？

Question

我正在尝试找出一种方法，让一个 PHP 页面显示我的所有博客文章，但让 URL 决定从该数据库请求什么文章。有点像这样：localhost/bolg/posts.php?pid=1在我的数据库中，我将其设置为每个帖子都有一个与之关联的 ID。所以我想要的是将 pid=1 并将其放入 MySQL 代码中。这是 post.php 的 PHP 代码<?php$servername = "localhost";$username = "root";$password = "";$dbname = "test";// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error);}$sql = "SELECT id, title, content, date FROM posts where id =3";$result = $conn->query($sql);if ($result->num_rows > 0) {    // output data of each row    while($row = $result->fetch_assoc()) {        echo "<h1> ". $row["title"]. "</h1>". $row["content"]. "" . $row["date"] . "<br>";    }} else {    echo "0 results";}$conn->close();?>

Answer 1

example.com?pid=10假设您在浏览器地址栏中输入，您可以pid使用$_GET数组捕获该变量，当使用查询字符串调用页面时，PHP 会自动为您填充该变量。

使用现有代码作为起点，您可以

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "test";

if (isset($_GET['pid'])) {

    // Create connection

    $conn = new mysqli($servername, $username, $password, $dbname);

    

    $sql = "SELECT id, title, content, date FROM posts where id = ?";

    $stmt = $conn->prepare($sql);

    $stmt->bind_param('i', $_GET['pid']);

    $stmt->execute();

    $result = $stmt->get_result();

    if ($result->num_rows > 0) {

        // output data of each row

        // while looop is not necessary, you are only returning one row

        $row = $result->fetch_assoc();

        echo "<h1> ". $row["title"]. "</h1>". $row["content"]. "" . $row["date"] . "<br>";

    }

    $conn->close();

} else {

    echo "0 results";

}