CODEWITHSUNDEEP
phpmysqli
user2872510
user2872510

Reputation: 115

Fetching data from database into array

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

Upvotes: 0

Views: 60

Answers (2)

Genus
Genus

Reputation: 284

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);
}

Upvotes: 1

Dan
Dan

Reputation: 9488

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

Upvotes: 2

Related Questions