从数据库中获取信息 [英] Get information from database

问题描述

当我点击 artikle 时，它​​需要将我定向到 page.php，在那里我可以显示整篇文章.问题是我不确定如何使用 $_GET 超全局变量正确获取信息.我必须使用 $_GET 获取 ID.

When I click on artikle It needs to diretct me to page.php where I display whole article. Problem is im not sure how to with $_GET superglobal var properly take information. I have to get ID with $_GET.

我已经在 index.php 中包含了数据库，我在其中显示了几篇文章.

I already have included database in my index.php where I displayed several articles.

我像这样发送id:

 echo '<a href="clanak.php?  class="form-field-textual"  id='.$row['id'].'">';

//article.php

//article.php

    <?php
 $servername = "localhost:3306";
 $user = "root";
 $pass = "";
 $dbo = "projekt";

// Create connection
$conn = new mysqli($servername, $user, $pass, $dbo);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM projekt";


if ($conn->query($sql)===TRUE) {
  $specID=$conn->insert_id;

        echo "id: " . $row["id"]. " - Name: " .
 $row["kategorija"]. " " . $row["naslov"]. "<br>";

    } else {
  echo "0 results";
}
$conn->close();
?> 

推荐答案

$row_id = $row['id'];
echo '<a href="clanak.php?id='.$row_id.'" class="form-field-textual">some text</a>';

        <?php
     $servername = "localhost:3306";
     $user = "root";
     $pass = "";
     $dbo = "projekt";

    // Create connection
    $conn = new mysqli($servername, $user, $pass, $dbo);
    // Check connection
    if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
    }

      $id = isset($_GET['id']) ? (int)$_GET['id'] : '';

    $sql = "SELECT * FROM projekt WHERE id = $id";

    if ($conn->query($sql)===TRUE) {
      $specID=$conn->insert_id;

            echo "id: " . $row["id"]. " - Name: " .
     $row["kategorija"]. " " . $row["naslov"]. "<br>";

        } else {
      echo "0 results";
    }
    $conn->close();

这篇关于从数据库中获取信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！