asked on How do you retrieve results from a PDO Array using this format?
I've got to mimic the approach taken by some preexisting code in the way I retrieve the results from a SELECT statement. Generally, I use PDO::FETCH_OBJ just because it's familiar and straight forward. In this instance, I'm using PDO::FETCH_ASSOC and I'm stuck.
I've got a recordset of 32 rows. Here's my code thus far:
$selectTerms=$conn->prepar
$selectTerms->execute();
$selectTermsCount=$selectT
$selectTermsArray=$selectT
for($x=0; $x<$selectTermsCount; $x++)
{
echo $selectTermsArray[$x]['ter
}
Right now I'm getting an error that says I've got an undefined offset. If I do this:
echo $selectTermsArray['term']
I get the first row repeated 32 times.
How do I need to code this thing so I get my rows documented correctly?
I've got a recordset of 32 rows. Here's my code thus far:
$selectTerms=$conn->prepar
$selectTerms->execute();
$selectTermsCount=$selectT
$selectTermsArray=$selectT
for($x=0; $x<$selectTermsCount; $x++)
{
echo $selectTermsArray[$x]['ter
}
Right now I'm getting an error that says I've got an undefined offset. If I do this:
echo $selectTermsArray['term']
I get the first row repeated 32 times.
How do I need to code this thing so I get my rows documented correctly?
PHP
Last Comment
Member_2_248744
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
And Slick, I just saw your post. Thanks for validating what I was able to discover only after some trial and error.
As far as why I need all the rows, I've been tasked with replacing some deprecated code and every situation where a recordset needed to be retrieved the approach was to identify the number of rows in the recordset and then use a for loop to print everything. I replaced that with a "while" and a fetch(PDO::FETCH_OBJ) and it's worked just fine.
In this instance though, there was a specified number of times the code needed to loop through the recordset and I couldn't tell just how necessary it was, but I decided to preserve their thought process and do it like this:
...and there you have it. Preserve their paradigm while incorporating the PDO dynamic.
Thanks!
As far as why I need all the rows, I've been tasked with replacing some deprecated code and every situation where a recordset needed to be retrieved the approach was to identify the number of rows in the recordset and then use a for loop to print everything. I replaced that with a "while" and a fetch(PDO::FETCH_OBJ) and it's worked just fine.
In this instance though, there was a specified number of times the code needed to loop through the recordset and I couldn't tell just how necessary it was, but I decided to preserve their thought process and do it like this:
$selectSystolicQueryArray=$selectSystolicQuery->fetchAll(PDO::FETCH_ASSOC);
for($x=0; $x<$num; $x++) {
/*
SYSTOLIC;
*/
$sysrangeorder = $selectSystolicQueryArray[$x]['rangeorder'];
...and there you have it. Preserve their paradigm while incorporating the PDO dynamic.
Thanks!
thanks 4 points, , just a suggestion, it always better to NOT get rows from the database, if you are NOT going to use them, so maybe instead of the -
for($x=0; $x<$num; $x++) {
you add to the SELECT string a LIMIT using the variable $num , so you don't get rows you would not need?
for($x=0; $x<$num; $x++) {
you add to the SELECT string a LIMIT using the variable $num , so you don't get rows you would not need?
Thanks!