I have a database table in Microsoft Access with three fields: partno, description, and quantity. However, when I try to retrieve the data and display it in an HTML table, I encounter an error message.
An issue occurred while trying to access the 'partno' field.
The PHP code I am currently using is:
<?php
foreach($items as $row){
$partno=$row['partno'];
$desc=$row['description'];
$qty=$row['quantity'];
?>
<tr>
<td><?=$partno?></td>
<td><?=$desc?></td>
<td><?=$qty?></td>
</tr>
<?php
}
}
if(!($items)){
?>
<h3 style="color: red;">Item not found!</h3>
<?php
}
?>
In my attempt to troubleshoot the issue, I used the following command:
print_r($items);
Upon executing this command, I received the following output for the array $items:
Array (
[partno] => BRZU
[0] => BRZU
[description] => CONTROL UNIT
[1] => CONTROL UNIT
[quantity] => 3
[2] => 3
)