Topic: Undefined index error

[gwh]

Hi everyone,

The following code in a controller file shows that I have an array that's been built after querying the database (I haven't shown the select query so the post won't be too long):

    $items = array();
      
      while ($row = mysqli_fetch_array($result))
      {
       $items[] = array('itemTitle' => $row['itemTitle'], 'itemSKULadies' => $row['itemSKULadies'], 'itemSKUMen' => $row['itemSKUMen'], 'itemDescLadies' => $row['itemDescLadies'], 'itemDescMen' => $row['itemDescMen'], 'itemPriceBoth' => $row['itemPriceBoth'], 'itemPriceFemale' => $row['itemPriceFemale'], 'itemPriceMale' => $row['itemPriceMale'], 'itemColoursBoth' => $row['itemColoursBoth'], 'itemColoursFemale' => $row['itemColoursFemale'], 'itemColoursMale' => $row['itemColoursMale'], 'Lsize' => $row['Lsize'], 'Msize' => $row['Msize'], 'itemType' => $row['itemType'], 'itemSwatchBoth' => $row['itemSwatchBoth'], 'itemSwatchFemale' => $row['itemSwatchFemale'], 'itemSwatchMale' => $row['itemSwatchMale'], 'itemImage' => $row['itemImage'], 'subcategory' => $row['subcategory']);
      }
      
      include 'catalogue_consumer.php';
      exit();
}
?>


You can see above that it includes a template file catalogue_consumer.php.

Part of this template file contains the code shown below.

        <?php 

if ($items['subcategory'] == Formalwear) {

echo "<a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=1\">Suits</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=10\">Vests</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=16\">Formal Shirts</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=12\">Bow Ties</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=15\">Cummerbunds</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=11\">Formal Ties</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=14\"> Cravats </a>";

}
?>


You can see that I'm referencing the 'subcategory' from the $items array above:

if ($items['subcategory'] == Formalwear)

When I test I get an Undefined index error:

Notice: Undefined index: subcategory in /Applications/MAMP/htdocs/site/consumer/catalogue/catalogue_consumer.php on line 151

This errors refers to the line above, ie

if ($items['subcategory'] == Formalwear)

I don't understand why it's saying it's undefined since it's in the array mentioned above. So I just wondered how I can define it so the error will be eliminated?

Appreciate any assistance.

[thorpe]

$items is a numerically indexed array. Have a look at it through print_r() and you will see.

[Wolphie]

That's because $items['subcategory'] doesn't exist.

$items is already an array, and you're making another array inside each element of the $items array to store your data.

e.g. $items[0]['subcategory'] would return the data for the first row in the database.
$items[1]['subcategory'] would return the second and so on.

[gwh]

Thanks for the replies,

I understand a bit more now.

I revised the code as follows:

        <?php foreach ($items as $item):

if ($item['subcategory'] == "Formalwear") {

echo "<a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=1\">Suits</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=10\">Vests</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=16\">Formal Shirts</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=12\">Bow Ties</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=15\">Cummerbunds</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=11\">Formal Ties</a>

  <a href=\"$url_consumer/index.php?subcatID=6&amp;itemTypeID=14\"> Cravats </a>";

}endforeach;
?>


This has eliminated the error but it's produced another problem. For example in the Suits category there are 5 items, so it's outputting 5 lots of the 7 links above. All I want to do is output 7 links - not 1 set of 7 for each item in that category as it's doing.

I think this has to do with the foreach loop, but I don't know an alternative.

Any further advice appreciated.

[gwh]

Instead of the foreach loop I tried:

$item = $items[19];

But that didn't work. Actually I don't even know if that makes sense. It gave me the following error:

Notice: Undefined offset: 19 in /Applications/MAMP/htdocs/site/consumer/catalogue/catalogue_consumer.php on line 149

[gwh]

Worked it out guys:

$item = $items[0]['subcategory'];

SOLVED