Transitioning to PDO/MySQL. Need help with SELECT statement, Do I have to bind value?

On a select statement without a WHERE clause, do I have to bind anything using PDO?

I am getting the following error:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 32 bytes)
on "$query2->execute();" line.


$query2 = $conn->prepare('SELECT * FROM `download');
// Do I bind a value here?
$query2->execute();

while ($row2 = $query2->fetch(PDO::FETCH_ASSOC))
{
    
 echo $row2['image']."<BR>";

}

Open in new window

lawrence_devAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GaryCommented:
No you can just do

$query2 = $conn->query('SELECT * FROM `download');

while ($row2 = $query2->fetch(PDO::FETCH_ASSOC))
{
...

Open in new window


But that error means you are running out of memory
Are there a lot of rows being returned?

Search the php.ini file for
memory_limit =

...and increase the limit.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lawrence_devAuthor Commented:
Thanks Gary!
I have 17040 rows,  None being returned.  If I place php.ini in the same folder, PDO stops working for some reason...  

Still working on it...
0
GaryCommented:
Add this to the top of the php page to get any errors reported

    error_reporting(E_ALL);

32 MB is rather small for a site, 64 or 128 would be better.
But you are returning a lot of rows - is there a reason?

If you are using a custom php.ini file you should place it in the site root.
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

GaryCommented:
I've just noticed a syntax error in your code

Should be (no need for the backticks and you were missing the closing one)

$query2 = $conn->query('SELECT * FROM download');

Open in new window

0
lawrence_devAuthor Commented:
Thanks Gary for all of your help!!  Memory Limit issue with IonCube required for PDO.  Fixed it and it is good!
0
lawrence_devAuthor Commented:
Thanks again!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.