PDO::FETCH_ASSOC Question

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Addos
Forum Contributor
Posts: 305
Joined: Mon Jan 17, 2005 4:13 pm

PDO::FETCH_ASSOC Question

Post by Addos »

: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.

Code: Select all

<?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'];
} ?>
User avatar
Christopher
Site Administrator
Posts: 13592
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: PDO::FETCH_ASSOC Question

Post by Christopher »

$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(),
(#10850)
Post Reply