[RESOLVED] Strangest Thing I've Ever Seen - foreach loop woes

lelyea

I am pulling rows of data from a MySQL database, dumping them into a table on a web page to be edited and submitting to the code below.

There are 649 rows of data in the MySQL table, and my web form sends 4 pieces of data from each row in the MySQL table. There should be 2596 pieces of data.

The below stops with a count of 1000 every time. If I delete the top ten rows of data in the MySQL table - it still stops at 1000.

I have increased timeout in php.ini (doubled it). I have went from 256 mb memory to 2 gb memory, and back to 1 gb memory - if I change memory in php.ini to 128mb it still stops at 1000.

This code worked when the MySQL table had under 300 rows of data.

Any help troubleshooting or possible solutions greatly appreciated.

<?php
ini_set('memory_limit', '1024M');
$mycount = 0;
foreach($_POST as $key=>$value)
{
echo "$key=$value";
echo " count: ".$mycount;
$mycount = $mycount +1;
echo "<br />";
}
?>

dalecosp

Probably not PHP's fault ... could you show us the query?

Try appending "LIMIT 10000" to it and see what happens?

select something from some_table where condition = value limit 10000;

dalecosp

Also, depending on what you're doing, exactly (and I can't tell from what you've posted), there is a PHP INI directive "post_max_size" if the SQL line of inquiry doesn't yield results.

lelyea

Added the following line to my php.ini and it fixed the problem. PHP has a default max input vars of 1000. Thank you everyone for your speedy replies.

max_input_vars = 4000

dalecosp;11053103 wrote:
Also, depending on what you're doing, exactly (and I can't tell from what you've posted), there is a PHP INI directive "post_max_size" if the SQL line of inquiry doesn't yield results.

Weedpacket

Incidentally, being faced with four thousand form fields that need editing sounds like a nightmare job. (The max_input_vars setting is a security measure since one way to attack a web site involves spamming form processors with thousands of values.)