php - 如何将在 php 中选择的 id 转移到数据库的另一个页面？

Question

我是 PHP 的新手，我现在被困在将选择的 id 转移到另一个页面。

这是我的第一个页面，home.php

 <?php
   require 'dbfunction.php';

   $con = getDbConnect();

   if (mysqli_connect_errno($con)) {
       "Failed to connect to MySQL: " . mysqli_connect_error();
   } else {
       $result = mysqli_query($con, "SELECT * FROM category");

       while ($category = mysqli_fetch_array($result)) {
 ?>

      <div class="col-md-4">
          <a class="thumbnail" href="product.php?cat=<?php echo $category['categoryid']; ?>">
          <img src="<?php echo "img/" . $category['image'] ?>" width="200" height="200">
           <div class="title"><h3><?php echo $category['title']; ?></h3></div>
          </a>
      </div>               

<?php
       }
   mysqli_close($con);
    }
 ?> 

我的第二个页面，product.php

<?php
  require 'dbfunction.php';

    $con = getDbConnect();

     if (mysqli_connect_errno($con)) {
        "Failed to connect to MySQL: " . mysqli_connect_error();
     } else {
         $result = mysqli_query($con, "SELECT * FROM product");

            while ($product = mysqli_fetch_array($result)) {
?>

    <div class="col-md-4">       
       <a class="thumbnail" href="productInfo.php?cat=<?php echo $product['categoryid']; ?>&code=<?php echo $product['productname']; ?>">
       <img src="<?php echo "img/" . $product['productimage']; ?>"  width="250" height="220">
       <div class="title"><h3><?php echo $product['productname']; ?></h3></div>
       </a>

    </div>

<?php
      }

    }
?>

我的数据库中的数据，

category

categoryid   PM2103
name         PaperModel
image        papermodel.jpg

categoryid   GP4567
name         GlossyPaper
image        GlossyPaper.jpg



product

categoryid   PM2103
productname  PaperModel
Productimage papermodel.jpg

categoryid   PM2103
productname  PaperModel222
Productimage papermodel222.jpg

categoryid   PM2103
productname  PaperModel333
Productimage papermodel333.jpg

categoryid   GP4567
productname  GlossyPaper
Productimage GlossyPaper.jpg

categoryid   GP4567
productname  GlossyPaper222
Productimage GlossyPaper222.jpg

当一个人在 home.php 中选择一个类别时，它会将该人带到另一个页面 product.php，所有产品都在类别列表中。我不确定应该使用什么代码将它们链接在一起。

Answer 1

你的home.php页面没问题...修改product.php

<?php
require 'dbfunction.php';

$con = getDbConnect();
$cat=$_GET['cat'];


 if (mysqli_connect_errno($con)) {
    "Failed to connect to MySQL: " . mysqli_connect_error();
 } else {
     $result = mysqli_query($con, "SELECT * FROM product where categoryid='".$cat."'");

        while ($product = mysqli_fetch_array($result)) {
?>

<div class="col-md-4">       
   <a class="thumbnail" href="productInfo.php?cat=<?php echo $product['categoryid']; ?>&code=<?php echo $product['productname']; ?>">
   <img src="<?php echo "img/" . $product['productimage']; ?>"  width="250" height="220">
   <div class="title"><h3><?php echo $product['productname']; ?></h3></div>
   </a>

</div>

<?php
  }

}
?>