Add/get data to/from two Dimensional array Doesn't work

Question

I'm trying to add data from database to 2-dimensional array and then unpacking.

This function is in a folder named imsConnection.php

function getCurrency() {
  global $cn;
  $sql = "select * from Currency";
  $res = mysqli_query($cn, $sql);
  $a = array();
  if (mysqli_num_rows($res) > 0) {
    while ($row = mysqli_fetch_array($res)) {
      $a[] = array($row['currencyID'], $row['currencyName']);
    }
  }
  return $a;
}

And to unpack it into drop box:

<select name="drpCurrency" required>
  <?php
    require_once("imsConnection.php");
    $a = getCurrency();
    foreach($a as $i) {
      echo "<option value='$i'>$a[$i]</option>";
    }
  ?>
</select>

You don't need $a[$i] as $i is already the element - just echo the $i['currencyName'] — dWinder
– dWinder, Commented Mar 17, 2019 at 10:53

dWinder · Accepted Answer · 2019-03-17 20:39:52Z

2

To make a formal answer: If you create multi dimentaion array and you loop with foreach you need to echo the value according the key you need. In you case:

    foreach($a as $i)
        echo "<option value='" . $i["currencyID"] ."'>" . $i['currencyName'] . "</option>";

I recommend you change your array do be according key - change the getCurrency function as:

while($row = mysqli_fetch_array($res)){
    $a[$row['currencyID']] = $row['currencyName'];

Then you can use it as:

$a = getCurrency();
foreach($a as $k => $i)
    echo "<option value='$k'>$i/option>";

Assuming you want the value as currency ID and the option content as the currency name

answered Mar 17, 2019 at 20:39

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

Add/get data to/from two Dimensional array Doesn't work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related