I am encountering some difficulties with retrieving the output from an array. Despite my efforts, I have not been able to determine why each portion of the array is not being assigned a proper index. I even attempted to introduce a counter variable in hopes of resolving this issue but unfortunately to no avail. As a newcomer to PHP, any guidance or assistance provided would be greatly valued.
foreach($dbh->query('SELECT n_productID, t_productName, t_categoryName FROM v_prodcatintersect') as $row) {
$prodID=$row["n_productID"];
$prodName=$row["t_productName"];
$prodCategor=$row["t_categoryName"];
$products=array(
array(
"prodID" => $prodID,
"prodName" => $prodName,
"prodCategor" => $prodCategor
),
print_r($products);
}
for($i = 0, $size = sizeof($products); $i < $size; ++$i){
echo "The product ID is ".$products[$i]["prodID"];
echo " The product name is ".$products[$i]["prodName"];
echo " Product Category ".$products[$i]["prodCategor"];
}
At present, the output from the array (as displayed by the print_r function) shows "Array ( [0] => Array ( [prodID] => 1 [prodName] => iPhone 4 [prodCategor] => Smartphones ) ) Array ( [0] => Array ( [prodID] => 2 [prodName] => Droid 3 [prodCategor] => Smartphones ) )". Consequently, the echoes produced only capture the second item out of two due to both having identical indices. Any advice on rectifying this indexing predicament would be warmly welcomed. Thank you for your assistance.