个人中心
gpt4 book ai didi

php - 使用 php 和 sql 为每个项目 id 创建一个操作 url

转载 作者：行者123 更新时间：2023-11-30 01:18:42 25 4
gpt4 key购买 nike

我正在尝试在 php/html 中制作将显示“产品详细信息”的页面。我让它显示图标和“详细信息页面”的链接，但它不会在“详细信息页面”上只显示一项。目前，产品页面(图标和链接所在的位置)将很好地链接到“详细信息页面”。但是，当页面加载时，它会加载 sql 数据库中具有“ID”的每个项目。我希望它只获取该项目的 id 并显示与该项目相关的页面，但是我收到了所有这些内容的集群...我的代码如下。我目前正在尝试学习 PHP，所以如果我犯了一个错误，一个非常糟糕的错误，比如效率低下的错误，请指出。请发布更有效的方法。我正在按照学校教授的方式学习它。

        <?php
//This page display a topic
include('admin/variable.php');
if(isset($_GET['id']))
{
    $id = intval($_GET['id']);
    $dn1 = mysql_fetch_array(mysql_query('select c.id, c.name, c.description, c.price, c.quantity, c.itemID, c.imgName, c.position, (select count(t.id) from topics as t where t.parent=c.id and t.id2=1) as topics, (select count(t2.id) from topics as t2 where t2.parent=c.id and t2.id2!=1) as replies from categories as c group by c.id order by c.position asc'));
if($dn1['id']>0)
{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" />
        <title><?php echo htmlentities($dn1['name'], ENT_QUOTES, 'UTF-8'); ?> - <?php echo htmlentities($dn1['itemID'], ENT_QUOTES, 'UTF-8'); ?> - KB Computers</title>
    </head>
    <body>
        <div class="header">
            <a href="<?php echo $url_home; ?>"><img src="<?php echo $design; ?>/images/logo.png" alt="Forum" /></a>
        </div>
        <div class="Content">
<?php

?>
<h1><?php echo $dn1['name']; ?></h1>
<?php

$dn2 = mysql_query('select c.id, c.name, c.description, c.price, c.quantity, c.itemID, c.imgName, c.position, c.position, (select count(t.id) from topics as t where c.parent=c.id and t.id2=1) as topics, (select count(t2.id) from topics as t2 where t2.parent=c.id and t2.id2!=1) as replies from categories as c group by c.id WHERE c.id = ' . $id .' order by c.position asc');

 //////////////////////////////////////////////////////////
 while($dnn2 = mysql_fetch_array($dn2))  //This is line 30!
 //////////////////////////////////////////////////////////

{
    $parent = $dnn2['parent'];
if(isset($_GET['id']))
{
    if($_GET['id'] == $parent){ 

?>
<div id="thing">
    <table>
        <tr>
            <th><?php echo $dnn2['imgName']; ?></th>
        </tr>
        <br />
        <tr>
            <th><?php echo $dnn2['price']; ?></th>
        </tr>
        <br />
        <tr>
            <th> <?php echo $dnn2['description']; ?></th>
        </tr>
        <br />
        <tr>
            <th><?php echo $dnn2['itemID']; ?></th>
        </tr>
        <?php
            if(isset($_SEESION['username']) and $_SESSION['username'] == $admin){?><div class="edit"><a href="edit_product.php?id=<?php echo $id; ?>&id2=<?php echo $dnn2['itemID']; ?>"><img src="<?php echo $design; ?>/images/edic.png" alt="Edit" /></a></div>

        <?php } ?>

    </table></div>
<?php
}else{echo 'The parent and id values are not the same.';}
}}
?>
        </div>  
    </body>
</html>
<?php
}
else
{
    echo '<h2>This topic doesn\'t exisc.</h2>';
}
}
else
{
    echo '<h2>The ID of this topic is not defined.</h2>';
}
?>

最佳答案 

<?php
//This page display a topic
include('admin/variable.php');
include('home.php');

if(isset($_GET['id']))
{
$dn1 = mysql_query('select 
     c.id, 
     c.name, 
     c.description, 
     c.price, 
     c.quantity, 
     c.itemID, 
     c.imgName, 
     c.parent, 
     c.position, 
(select count(c.id) from categories as c where c.parent=c.id) as categories, (select count(c.id) from categories as c where c.parent=c.id and c.id!=0) as replies from categories as c group by c.id order by c.position asc');
if($dn1 === false){
        die(mysql_error());
    }
while($dnn1 = mysql_fetch_array($dn1))
{
$parent = $dnn1['parent'];
  if($_GET['id'] == $parent){ 

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="require/style.css" rel="stylesheet" title="Style" />
    <title><?php echo htmlentities($dnn1['name'], ENT_QUOTES, 'UTF-8'); ?> - <?php echo htmlentities($dnn1['itemID'], ENT_QUOTES, 'UTF-8'); ?> - KB Computers</title>
 </head>
 <body>

  <div class="Content">
<div style="background:white; height:800px;">

<div id="shopNav">
<ul>
    <li class="end"><a href="">Shop</a></li>
            <li><a href="">Catagories</a></li>
            <li><a href="">New Products</a></li>
            <li><a href="">My Account</a></li>
            <li class="end2"><a href="">Checkout</a></li>
        </ul>

    </div>

<div id="thing">
<table><h1><?php echo $dnn1['name']; ?></h1>
<tr>
 <th><?php echo '<img src="image/' . $dnn1['imgName'].'" alt="' . $dnn1['imgName']. '" width="128" height="128"'; ?></th>
</tr>
<tr>
<th><?php echo $dnn1['price']; ?></th>
</tr>
<tr>
<th class="tableDesc"> <?php echo $dnn1['description']; ?></th>
</tr>
    <tr>
        <th><?php echo $dnn1['itemID']; ?></th>
    </tr>
    <?php 
        if(isset($_SEESION['username']) and $_SESSION['username'] == $admin){?>
        <tr>
        <a href="edit_product.php?id=<?php echo $id; ?>&id2=<?php echo $dnn1['itemID']; ?>"><img src="<?php echo $design; ?>/images/edic.png" alt="Edit" /></a>>
        </tr>
    <?php } ?>
    <tr>
        <th> </th>
    </tr>
</table>
</div>
<?php include("require/rightBar.html"); ?></div><?php include("require/footer.html"); 
}
}
}else{echo 'That product doesnt exist!';}
?>

    </div>  
</body>

关于php - 使用 php 和 sql 为每个项目 id 创建一个操作 url，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/18796150/

25 4 0
文章推荐： mysql - 选择“计数”，然后选择“排序依据”
文章推荐： mysql - Cron Bash - 从两个 MySQL 表中选择数据并导出到 CSV
文章推荐： php - 数据库自动完成功能不起作用
文章推荐： Mysql每行选择表5
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com