PDO ForEach Loop in array (PHP)

Question

I want to have all results from my database in one array

my function:

function GetWinkelProduct($g_Winkel) {
    global $g_Conn;

    $l_Stmt = $g_Conn->prepare("SELECT pd_id FROM `producten_:Winkel`");
    $l_Stmt->bindValue(':Winkel', $g_Winkel, PDO::PARAM_INT);
    $l_Stmt->execute();


    $l_qurries = new dbquery();
    $l_LastProduct = $l_qurries->GetLastProduct($g_Winkel);

    while($l_Row = $l_Stmt->fetch(PDO::FETCH_ASSOC)){
        $out = array();

        foreach($l_Row as $product){
            $out[] = $product['pd_id'];
        }
    }
        return $out;        
}

other page: <?php print_r($l_qurries->GetWinkelProduct($g_Winkel)); ?>

only I get the first result in the array and when I do $product['pd_id'] I get only the last result.

@javabrett I deleted the foreach loop though it was needed but only with a while loop it works fine. — Erwin
– Erwin, Commented May 27, 2015 at 12:02

Deenadhayalan Manoharan · Accepted Answer · 2015-05-27 11:59:57Z

2

Try this...

Change fetch to fetchAll in while loop and renove foreach inside while loop

function GetWinkelProduct($g_Winkel) {
    global $g_Conn;

    $l_Stmt = $g_Conn->prepare("SELECT pd_id FROM `producten_:Winkel`");
    $l_Stmt->bindValue(':Winkel', $g_Winkel, PDO::PARAM_INT);
    $l_Stmt->execute();


    $l_qurries = new dbquery();
    $l_LastProduct = $l_qurries->GetLastProduct($g_Winkel);

    while($l_Row = $l_Stmt->fetchAll(PDO::FETCH_ASSOC)){
        $out = array();


            $out[] = $l_Row ['pd_id'];

    }
        return $out;        
}

ref:http://php.net/manual/en/pdostatement.fetchall.php

answered May 27, 2015 at 11:59

Deenadhayalan Manoharan

5,45214 gold badges33 silver badges50 bronze badges

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

Comments

Diogo Cunha · Accepted Answer · 2015-05-27 12:03:11Z

0

You must initialize the array outside the while loop and you don't need the foreach.

that way you are creating a new array every time the while iterates, that way you end up replacing the array.

    $out = array();    
    while($l_Row = $l_Stmt->fetchAll(PDO::FETCH_ASSOC)){
          $out[] = $l_Row['pd_id'];
    }
    return $out;

answered May 27, 2015 at 12:03

Diogo Cunha

1,19411 silver badges23 bronze badges

Collectives™ on Stack Overflow

PDO ForEach Loop in array (PHP)

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