我有一个名为$_SESSION[BASE_SESSION_NAME]['my_cart']
的关联数组。为了供您参考,我将阵列打印如下:
Array
(
[6f993b72511c37f4ab4d7273066b8160] => Array
(
[pack_id] => 6f993b72511c37f4ab4d7273066b8160
[pack_type] => test
[pack_type_id] => 4
[pack_name] => NEET XII Biology
[pack_price] => 459.00
[pack_validity] => Array
(
[years] => 1
[months] => 0
[days] => 0
)
)
[cart_summary] => Array
(
[total_no_packages] => 3
[total_pack_price] => 1557
[final_total_pack_price] => 1557
[total_pack_discount] => 0
[apply_deal_code] => 0
[no_of_discounted_packages] => 0
)
[67f76ffae26ffdcde7a392c5534c972a] => Array
(
[pack_id] => 67f76ffae26ffdcde7a392c5534c972a
[pack_type] => test
[pack_type_id] => 4
[pack_name] => NEET XII Chemistry
[pack_price] => 599.00
[pack_validity] => Array
(
[years] => 1
[months] => 0
[days] => 0
)
)
[31dc7c5d9b9cb5a2ba968e74efd4a475] => Array
(
[pack_id] => 31dc7c5d9b9cb5a2ba968e74efd4a475
[pack_type] => test
[pack_type_id] => 4
[pack_name] => NEET XII Physics
[pack_price] => 499.00
[pack_validity] => Array
(
[years] => 1
[months] => 0
[days] => 0
)
)
)
现在我只想访问具有pack_id值的密钥或值ok密钥pack_id
。例如值[31dc7c5d9b9cb5a2ba968e74efd4a475]或键pack_id
的值作为CCD_ 4。但问题是,还有一个数组具有密钥[cart_summary]
,我不想使用该数组中的任何东西。我必须对每个这样的pack_id启动一个查询。所以我想在循环的帮助下激发一个查询。有人能帮我解决这个问题吗?提前谢谢。我想使用的查询如下:
SELECT package_type.package_type_name
FROM package_type
JOIN test_packages ON package_type.package_type_id = test_packages.test_pack_type_id
WHERE test_packages.test_pack_id = '$propsed_pack_id'
这是您在注释中要求的关联数组的foreach
$mycart = $_SESSION[BASE_SESSION_NAME]['my_cart'];// where $mycart is the array structure
//as shown above in the question
foreach($mycart as $key=>$value)
{
//where $key holds the pack_id i.e. the array key value
$propsed_pack_id = $value['pack_id'];
if($key != "cart_summary")
{
//execute you sql query
$query = "SELECT package_type.package_type_name
FROM package_type
JOIN test_packages ON package_type.package_type_id =
test_packages.test_pack_type_id
WHERE test_packages.test_pack_id = '$propsed_pack_id'";
......
}
}
我希望这能有所帮助。
unset($arr["item"])
从名为$arr的数组中删除键为"item"的项。
一种方法是,您可以直接检查saran banerjee所说的"购物车摘要"。
但我建议,您可以在数组中检查"pack_id"键,而不是对"cart summary"进行硬编码检查。若它在那个里,就执行那个pack_id的查询,否则就不执行。
$mycart = $_SESSION[BASE_SESSION_NAME]['my_cart'];
foreach($mycart as $key=>$value)
{
//where $key holds the pack_id
$propsed_pack_id = isset($value['pack_id']) ? $value['pack_id'] : '';
if($propsed_pack_id != "")
{
//execute you sql query
$query = "SELECT package_type.package_type_name
FROM package_type
JOIN test_packages ON package_type.package_type_id =
test_packages.test_pack_type_id
WHERE test_packages.test_pack_id = '$propsed_pack_id'";
}
}
如果我很清楚你想要什么,你应该使用循环并寻找正确的键。
如果您的后端语言是PHP。
foreach($_SESSION[BASE_SESSION_NAME]['my_cart'] as $cart) {
if (isset($cart['pack_id'])) {
// Here you get the pack id, only if exist as a key inside the array
}
}
希望这个帮助。。。