Fetching data from database into array

Question

I am using mysqli to fetch data from the database and put it into an array with a while loop. When i echo out the array i get an empty array however in a function i previously did this code worked but it had a different result from the database. I know that the database is giving out good data because when i echo out the result $idGroup it gives me 2 which is correct.

Ps i know it will keep replacing itself because i don't specify an index private function Groups() { $functionRun = 0; $i = 0; $helperArray = array(); $this->grouplist = array();

  $query = "SELECT GroupName, Groups.idGroup  
            FROM Groups
            INNER JOIN Members
            ON Groups.idGroup = Members.idGroup
            WHERE Members.idMember = ? ";

  //prepare query and execute
  if($stmt = $this->connection->prepare($query))
  {

    $stmt->bind_param('s', $this->id);
    $stmt->execute();
    $stmt->bind_result($GroupName, $idGroup);

    while ($stmt->fetch()) 
    {

       $helperArray[] = $idGroup;

    }

        echo $helperArray;
 }

You should use print_r on $helperArray, not echo

Dan
– Dan

2014-03-03 23:50:07 +00:00
Commented Mar 3, 2014 at 23:50 — Dan
– Dan, Commented Mar 3, 2014 at 23:50
wow easy fix should have known that thanks

user2872510
– user2872510

2014-03-03 23:51:33 +00:00
Commented Mar 3, 2014 at 23:51 — user2872510
– user2872510, Commented Mar 3, 2014 at 23:51

Dan · Accepted Answer · 2014-03-03 23:50:52Z

2

Use print_r when dealing with arrays. Use echo on strings.

answered Mar 3, 2014 at 23:50

Dan

9,4885 gold badges44 silver badges76 bronze badges

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

Comments

Genus · Accepted Answer · 2014-03-03 23:52:39Z

1

Try this

 $query = "SELECT GroupName, Groups.idGroup  
        FROM Groups
        INNER JOIN Members
        ON Groups.idGroup = Members.idGroup
        WHERE Members.idMember = ? ";

//prepare query and execute
if($stmt = $this->connection->prepare($query))
{

$stmt->bind_param('s', $this->id);
$stmt->execute();
$stmt->bind_result($GroupName, $idGroup);
$helperArray =array();
while ($stmt->fetch()) 
{

   $helperArray[] = $idGroup;

}

    print_r($helperArray);
}

answered Mar 3, 2014 at 23:52

Genus

2843 silver badges10 bronze badges

Collectives™ on Stack Overflow

Fetching data from database into array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related