PHP array taking up too much memory

Question

I have a multidimensional array. The array itself is fine. My problem is that the script takes up monster amounts of memory, and since I'm running this on my MAMP install on my iBook G4, my computer freezes up. Below is the full script.

$query = "SELECT * FROM posts ORDER BY id DESC LIMIT 10"; 
$result = mysql_query($query);
$posts = array();
while($row = mysql_fetch_array($result)){

            $posts[$row["id"]]['post_id'] = $row["id"];
            $posts[$row["id"]]['post_title'] = $row["title"];
            $posts[$row["id"]]['post_text'] = $row["text"];
            $posts[$row["id"]]['post_tags'] = $row["tags"];
            $posts[$row["id"]]['post_category'] = $row["category"];

foreach ($posts as $post) {
   echo $post["post_id"];
}

Is there a workaround that still achieves my goal (to export the MySQL query rows to an array)?

-Dylan

How much memory is being used? Have you measured using memory_get_usage? — Charles
– Charles, Commented Jun 16, 2010 at 3:32
It can't possibly be a problem with a syntax error caused by the missing } after the loop which doesn't get reported since error reporting is turned off, can it? :) — deceze
– deceze ♦, Commented Jun 16, 2010 at 3:34

user367861 · Accepted Answer · 2010-06-16 03:32:52Z

1

If that code is verbatim, copied/pasted directly from your code, one thing that caught my eye (unless I am seeing things) is the absence of the closing '}' for the while loop???

Cheers, Alex

answered Jun 16, 2010 at 3:32

user367861

941 bronze badge

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

1 Comment

Dylan Taylor Over a year ago

Yeah that was my typo. It's there in my code. Thanks for the heads-up!

Sarfraz · Accepted Answer · 2010-06-16 03:13:16Z

0

This is strange because you have set the limit of 10 already. Note that you are specifying associative array eg $row["title"] while using mysql_fetch_array function, add second parameter to it MYSQL_ASSOC or use mysql_fetch_assoc function instead:

while($row = mysql_fetch_assoc($result)){
   $posts[$row["id"]]['post_id'] = $row["id"];
   $posts[$row["id"]]['post_title'] = $row["title"];
   $posts[$row["id"]]['post_text'] = $row["text"];
   $posts[$row["id"]]['post_tags'] = $row["tags"];
   $posts[$row["id"]]['post_category'] = $row["category"];
}

You might want to use the array_chunk function to chunks from array and manipulate those chunks however you want.

answered Jun 16, 2010 at 3:13

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

2 Comments

Dylan Taylor Over a year ago

Thanks but it didn't do the job

Dylan Taylor Over a year ago

It's not an error message - the page just never loads and the httpd process (the MAMP process) goes way up to 28mb and climbing. I have to stop the page load and force quit the process.

Collectives™ on Stack Overflow

PHP array taking up too much memory

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related