Skip to content
Advertisement

PDO looping through and printing fetchAll

I’m having trouble getting my data from fetchAll to print selectively.

In normal mysql I do it this way:

JavaScript

In PDO, I’m having trouble. I bound the params, then I’m saving the fetched data into $rs like above, with the purpose of looping through it the same way..

JavaScript

Now comes the trouble part. What do I do PDO-wise to get something matching the while loop above?! I know I can use print_r() or dump_var, but that’s not what I want. I need to do what I used to be able to do with regular mysql, like grabbing $id, $n, $k individually as needed. Is it possible?

Thanks in advance..

Advertisement

Answer

It should be

JavaScript

If you insist on fetchAll, then

JavaScript

PDO::FETCH_ASSOC fetches only column names and omits the numeric index.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement