php assosiate array through foreach

Question

i am having database table in Microsoft access which has field as follows: partno,description,quantity

when i am retriving data and trying to show it in html table it shows error

Illegal string offset 'partno'

my php code is as follows:

<?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
    }
  ?>

i tried see data through

print_r($items);

data of array $items is :

Array ( 
    [partno] => BRZU 
    [0] => BRZU 
    [description] => CONTROL UNIT 
    [1] => CONTROL UNIT 
    [quantity] => 3 
    [2] => 3 
)

Add the code with which you retrive data to get more help

Ilario Pierbattista
– Ilario Pierbattista

2017-06-02 18:10:11 +00:00
Commented Jun 2, 2017 at 18:10 — Ilario Pierbattista
– Ilario Pierbattista, Commented Jun 2, 2017 at 18:10

Ilario Pierbattista · Accepted Answer · 2017-06-02 13:50:16Z

3

It seems that $items actually contains just a single row. Using a foreach loop over it will cause $row to assume values BZRU, BZRU, CONTROL UNIT, 2, 3.

I think that you were expecting an array of arrays like this, over which you can iterate with your foreach loop.

edited Jun 2, 2017 at 13:50

answered Jun 2, 2017 at 13:47

Ilario Pierbattista

3,2752 gold badges36 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rotimi · Accepted Answer · 2017-06-02 14:10:09Z

1

Verify first that the array items is not empty before proceeding with the loop.

<?php
     if(is_array($items) && count($items) > 0){//check that we have something before proceeding with the loop
       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  
        }
      } else {
          ?>
      <h3 style="color: red;">Item not found!</h3>
      <?php
        }
      ?>

edited Jun 2, 2017 at 14:10

answered Jun 2, 2017 at 13:56

Rotimi

4,7804 gold badges21 silver badges28 bronze badges

Comments

Brett Santore · Accepted Answer · 2017-06-02 13:51:11Z

0

Your logic is incorrect. You need to check if $items is empty before attempting to iterating through it.

answered Jun 2, 2017 at 13:51

Brett Santore

7976 silver badges14 bronze badges

Collectives™ on Stack Overflow

php assosiate array through foreach

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related