php - 我的 php 购物车更新按钮无法正常工作？

Question

这个问题在这里已经有了答案:





mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc... expects parameter 1 to be resource

(31 个回答)



Reference - What does this error mean in PHP?

(37 个回答)


8年前关闭。




我的产品被添加到购物篮中，但是当我更新数量时它重复并出现以下错误:

Notice: Query failed: Unknown column '_2' in 'where clause' SQL: SELECT * FROM Workshop3_products WHERE prodid=_2 in /home/ihamza/ihamza.bimserver2.com/RadioDawg/imp/mysql.data.php on line 100

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/ihamza/ihamza.bimserver2.com/RadioDawg/imp/mysql.data.php on line 119

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/ihamza/ihamza.bimserver2.com/RadioDawg/imp/mysql.data.php on line 131

Warning: extract() expects parameter 1 to be array, boolean given in /home/ihamza/ihamza.bimserver2.com/RadioDawg/imp/functions.inc.php on line 30

它在我的产品 ID 中添加和 _ 已经检查了我的代码并且不知道这是从哪里来的？

<table border="0" cellpadding="2px" width="600px">
  <?php
  $sql = 'SELECT * FROM Workshop3_products ORDER BY Prodid';
  $result = $db->query($sql);
  while ($row = $result->fetch()) {
  ?>
   <tr> 
     <td><img src=images/<?=$row['prodid'] ?>.jpg width="244" height="260" /></td>
     <td>       <b><?=$row['Name']?></b><br />
                <b><?=$row['ModelNo']?></b><br />
                <?=$row['Description']?><br />
                Price:<big style="color:Pink">
                    $<?=$row['Price']?></big><br /><br />
       <br /> <a href="cart.php?action=add&prodid= <?=$row['prodid']?>">Add to Basket</a>
     </td>
   </tr>
   <tr><td colspan="2"><hr size="1" /></td>
  <? } ?>
</table>

Answer 1

需要在数据库中查看您的表 表中的数据

但我的意见

这是您的查询错误

如果在您的表格中 prodid 的数据类型是整数 (int)，您应该
像下面这样写

SELECT * FROM Workshop3_products WHERE prodid=2
// no need to use _

//for integer you also can using quote
SELECT * FROM Workshop3_products WHERE prodid='2'

但如果 proid 是 varchar 你应该写你的查询如下

SELECT * FROM Workshop3_products WHERE prodid='_2'
//whether using "_" or not is depend of your data inside table

对于“_”添加您的 prodid 需要查看您的 php 代码，...