Question

PHP5 点击新闻列表显示新闻内容页面怎么做

product.php页面
<?php
$conn = mysql_connect("localhost","root","qwepoi") or die ("链接失败");
mysql_select_db("web3");
mysql_query("SET NAMES 'utf8'");
$sql1 = "SELECT * FROM `product` WHERE type = 'reactor'";
$RS1 = mysql_query($sql1);
?>

<?php while ($row_RS1 = mysql_fetch_array($RS1)){
echo "<li><a href='product_detail.php?id=".$_GET['id']."'>".$row_RS1["name"]."</a></li>"; } ?>

product_detail.php页面
<?php
$conn = mysql_connect("localhost","root","qwepoi") or die ("链接失败");
mysql_select_db("web3");
mysql_query("SET NAMES 'utf8'");
$id = $_GET['id'];
$sql = "SELECT * FROM `product` WHERE id=".$id;
$RS = mysql_query($sql);?>

<?php echo $RS['content'];?>
请问问题出在哪里

Answer 1

product.php页面

<?php
$conn = mysql_connect("localhost","root","qwepoi") or die ("链接失败");
mysql_select_db("web3");
mysql_query("SET NAMES 'utf8'");
$sql1 = "SELECT * FROM `product` WHERE type = 'reactor'";
$RS1 = mysql_query($sql1);
while ($row_RS1 = mysql_fetch_array($RS1)) {
echo "<li><a href='product_detail.php?id=".$row_RS1['id']."'>".$row_RS1["name"]."</a></li>";
}
?>

product_detail.php页面
<?php
$conn = mysql_connect("localhost","root","qwepoi") or die ("链接失败");
mysql_select_db("web3");
mysql_query("SET NAMES 'utf8'");
$id = $_GET['id'];
$sql = "SELECT * FROM `product` WHERE `id`=$id";
$RS = mysql_query($sql);
echo $RS['content'];
?>

Answer 2

<?php while ($row_RS1 = mysql_fetch_array($RS1)){
echo "<li><a href='product_detail.php?id=".$row_RS1['id']."'>".$row_RS1["name"]."</a></li>"; } ?>

你那个$_GET['id']怎么来的？应该是你取出数据库的ID才可以传到product_detail.php页面。

Answer 3

$sql = "SELECT * FROM `product` WHERE id=".$id;
这个真的对么？
$sql="select * from `product` where id='".$id."'";

Answer 4

-_- 你这问题问得真是...

不可能有答案吧~