How To Produce Multidimensional Array From While Loop?

Question

I have this function :

function userKids(mysqli $Con, $Parent) {
    $stmt = $Con->prepare('SELECT KidsName, KidsAge, KidsGender FROM Kids WHERE Parent = ?');
    $stmt->bind_param('s', $Username);
    $stmt->execute();

    $Kid = null;
    $Kids = array();
    $stmt->bind_result($Kid, $KidsAge, $KidsGender);
    while($stmt->fetch()) {
        $Kids[] = $Kid;
    }
    return $Kids;
}

currently my WHILE loop produce array like this :

Array ( [0] => john [1] => jane )

Now, how to produce multidimensional array so I can get the Age and Gender as well, like this :

Array
(
[john] => Array
  (
  [0] => 3
  [1] => male
  )
[jane] => Array
  (
  [0] => 2
  [1] => female
  )
)

you can benefit a lot from Object Oriented Programming, Robert — STT LCU
– STT LCU, Commented Apr 19, 2013 at 7:05
What you want will overwrite results, if you have 2 kids with name "John". I hope you notice. — BlitZ
– BlitZ, Commented Apr 19, 2013 at 7:06
Try to put not KidsName as array key, but something unique, like IDKid, so it never might be repeated in SELECT result set. Or just leave your idea. Your choise. — BlitZ
– BlitZ, Commented Apr 19, 2013 at 7:17

Paul · Accepted Answer · 2013-04-19 07:04:43Z

4

Change the line:

$Kids[] = $Kid;

To:

$Kids[$Kid] = array($KidsAge, $KidsGender);

answered Apr 19, 2013 at 7:04

Paul

142k28 gold badges285 silver badges272 bronze badges

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

1 Comment

Daan Timmer Over a year ago

As CORRUPT has mentioned, your solution will overwrite duplicate first names.

Barmar · Accepted Answer · 2013-04-19 07:06:26Z

1

I recommend that you use an associative array for the second dimension as well. So:

$Kids[$Kid] = array('age' => $KidsAge, 'gender' => $KidsGender);

answered Apr 19, 2013 at 7:06

Barmar

789k57 gold badges554 silver badges669 bronze badges

Comments

Casimir et Hippolyte · Accepted Answer · 2013-04-19 07:12:21Z

1

replace the end of your code by:

$stmt->bind_result($KidName, $KidAge, $KidGender);
while($stmt->fetch()) {
    $Kids[$KidName] = array($KidAge,$KidGender);
}
return $Kids;

answered Apr 19, 2013 at 7:12

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

Collectives™ on Stack Overflow

How To Produce Multidimensional Array From While Loop?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related