PHP获取选中分类ID传参报错undefined index及关联商品展示问题
问题解决方案
核心错误说明
- 当前查询语句未返回分类ID字段,无法从
$data中获取ID值 <a>标签跳转属于GET请求,目标页用$_POST接收参数必然会报undefined index错误
修改步骤
步骤1:修改当前页的SQL查询,追加分类ID字段
在SELECT语句开头加入分类ID的查询,代码示例:
$records = mysqli_query($db,"SELECT DISTINCT categories.id AS category_id, category , (SELECT COUNT(products.name) FROM products where category_id=categories.id) AS total_products, ( SELECT SUM(quantity) FROM productstock a LEFT JOIN products b ON a.product_id=b.id LEFT JOIN categories c ON b.category_id=c.id where c.deleted=0 AND b.category_id = categories.id GROUP BY category_id ) AS available_stock, SUM(product_qty*orignalCost) AS SaleWise_cost, SUM(product_qty*saleprice) AS SaleWise_price, SUM(product_qty*saleprice) AS total_sale , SUM((product_qty*saleprice)-(product_qty*orignalCost)) AS profit FROM categories INNER JOIN products ON categories.id = products.category_id INNER JOIN sales ON sales.product_id = products.id INNER JOIN productstock ON productstock.product_id = products.id WHERE categories.deleted=0 GROUP BY category_id;");
步骤2:修改a标签传值逻辑
把链接中传递的分类名称替换为分类ID,代码示例:
<td><a href="report_product.php?id=<?php echo $data['category_id']; ?>"><?php echo $data['category']; ?></a></td>
步骤3:修改report_product.php的参数接收逻辑
用$_GET接收参数,同时加存在性判断避免报错,代码示例:
// 先判断参数是否存在,不存在走异常逻辑 if (!isset($_GET['id'])) { // 自定义异常逻辑,比如跳回分类列表页 header('Location: 你的分类列表页地址'); exit; } $category_id = intval($_GET['id']); // 转整数避免SQL注入风险 // 后续就可以用$category_id查询对应分类下的商品列表
注意事项
- 涉及数据库查询的参数建议全部使用预处理语句,进一步规避SQL注入风险
- 如果必须用POST方式传参,只能通过表单提交的方式跳转,不能使用a标签直接跳转
内容的提问来源于stack exchange,提问作者Rana
相关产品推荐
相关产品推荐

