Simple PDO query returns memory-size error

Question

I tried to make a simple pdo request to select all values of a table

<?php public function query($query) { $this->stmt = $this->query($query); } ?>

But when I call it like

$db->query('SELECT * FROM teams'); $teams = $db->resultset(); print_r($teams);

an error occured

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 65484 bytes) in /var/www/flunky/functions/mysql.class.php on line 29

I tried to increase the memory size in php.ini and with ini_set('memory_limit', '512M');, but it doesn´t work. Can anybody help me?

Your Common Sense · Accepted Answer · 2019-09-18 17:15:12Z

18

Run this code before running a query

$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);

Further reading Buffered and Unbuffered queries

I tried to increase the memory size in php.ini and with ini_set('memory_limit', '512M');, but it doesn´t work.

It worked, actually.

The error message says that this exact amount were exhausted.

edited Sep 18, 2019 at 17:15

answered Apr 9, 2014 at 13:13

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

sydev Over a year ago

Next error occured: 'Fatal error: Call to undefined method database::setAttribute() in /var/www/flunky/backend.php on line 38' I used it with my $db variable '$db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); $db->query('SELECT * FROM teams'); $teams = $db->resultset(); print_r($teams);'

Your Common Sense Over a year ago

you tagged your question with PDO, so I provided solution for PDO

sydev Over a year ago

Yeah and it is PDO, or not? why does he called it an "undefined method"?

Your Common Sense Over a year ago

because your "database" is anything but PDO

Paul Spiegel Over a year ago

Shouldn't it be false for unbuffered queries? Or how is this going to fix the memmory issue?

Collectives™ on Stack Overflow

Simple PDO query returns memory-size error

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related