PHP Developers Network
http://forums.devnetwork.net/

PDO::FETCH_ASSOC Question
http://forums.devnetwork.net/viewtopic.php?f=1&t=147869
Page 1 of 1

Author:  Addos [ Fri Nov 30, 2018 6:04 am ]
Post subject:  PDO::FETCH_ASSOC Question

:roll: I'm trying to learn OOP and convert some old scripts to the latest. (Testing all this locally) I can't see why I cannot get either of the loops to work below. If I comment out var_export($row); everything gets out-putted so I know my connection and query is OK.
Any ideas as to what else I need to try as I've exhausted my research at the mo ?
Thank you.

Syntax: [ Download ] [ Hide ]
<?PHP $stmt = $pdo->prepare("SELECT * FROM queue ORDER BY customer_name ASC");
                        $stmt->execute();
                        $row = $stmt->fetchAll(PDO::FETCH_ASSOC);

                        if(!$row) exit('No rows');
        echo $stmt->rowCount();
                        //var_export($row);
                        //$stmt = null;

   while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
           
           echo $row['date_due'];
           echo $row['customer_name'];
        }
       
        $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach($results as $row) {
               
                echo $row['date_due'];
            echo $row['customer_name'];
} ?>

Author:  Christopher [ Fri Dec 14, 2018 11:16 pm ]
Post subject:  Re: PDO::FETCH_ASSOC Question

$stmt->fetchAll(PDO::FETCH_ASSOC); will fetch all the rows selected, so you are at the end of the dataset. You don't need to loop. Either use fetchAll() or loop and use fetch(),

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/