blocks|key|1091714|text|您的第一行是字符串，也许可以尝试添加|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1091715|while(($row+=+fgetcsv($handle,+"\r"))+!=+FALSE)
{

++++if(is_numeric($row[1]))
++++{+
++++++++$valueArray[]+=+$row[1];

++++++++$totalValue+=+$totalValue+%2B+$row[1];
++++++++$amountRecords%2B%2B;
++++}
}|code-block|syntax|javascript|1091716|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Your first row is string, maybe try adding

<pre><code>while(($row = fgetcsv($handle, "\r")) != FALSE)
{

 if(is_numeric($row[1]))
 { 
 $valueArray[] = $row[1];

 $totalValue = $totalValue + $row[1];
 $amountRecords++;
 }
}
</code></pre>

blocks|key|4776109|text|为什么不去掉这行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4776110|$totalValue+=+$totalValue+%2B+$row[1];|code-block|syntax|javascript|4776111|从您的循环内部，而不是使用：|4776112|$totalValue+=+array_sum($valueArray);|4776113|在完成循环之后|4776114|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Why not drop the line:

<pre><code>$totalValue = $totalValue + $row[1];
</code></pre>

from inside your loop, and instead use:

<pre><code>$totalValue = array_sum($valueArray);
</code></pre>

after completing your loop

blocks|key|3308226|text|这不是真正的问题，但是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3308227|while(($row+=+fgetcsv($handle,+"\r"))+!=+FALSE)|code-block|syntax|javascript|3308228|可以重写为|3308229|while($row+=+fgetcsv(...))+|3308230|而不是。没有必要进行显式的false检查--如果fgetcsv返回false，那么while循环无论如何都会终止。另外，这个版本更易读，风险也更小。如果您忘记了fget部分周围的()，那么您将执行与$row+=+(fgetcsv()+!=+false)等效的操作，只是简单地获取一个布尔值。|offset|length|style|CODE|3308231|entityMap^0|0|0|0|0|2H|2|2R|R|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]|$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

Not really the problem, but

<pre><code>while(($row = fgetcsv($handle, "\r")) != FALSE)
</code></pre>

can be rewritten as

<pre><code>while($row = fgetcsv(...)) 
</code></pre>

instead. There's no need for the explicit false check - if fgetcsv returns false, the while loop would terminate anyways. Plus this version is more legible, and not as risky. If you forget the <code>()</code> around the fget portion, you'll be doing the equivalent of <code>$row = (fgetcsv() != false)</code> and simply getting a boolean value.

blocks|key|3308239|text|对于内存不足错误，通常有两种方法。像往常一样，你可以选择容易但错误和困难但正确的选择。简单但错误的解决方案是将your+memory+limit增加到适当的级别：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3308240|ini_set('memory_limit',+'64M');|code-block|syntax|javascript|3308241|更好(虽然更难)的解决方案是重新设计算法，使其不需要那么多内存。这显然是更可持续和更健壮的方法。为了正确地做到这一点，您需要评估您需要对正在构建的数组执行哪些操作。例如，我编写了类似的脚本，将行导入到数据库中。我没有构建一个巨大的数组然后插入，而是分批进行，我构建了一个50-100行的数组，然后插入这些行并清除该数组(释放内存以供重复使用)。|3308242|伪代码：|3308243|for(each+row+in+file)+{
++$rows_cache[]+=+$row[1];
++if(count($rows_cache)+>=+50)+{
++++insert_these($rows_cache);
++++$rows_cache+=+array();
++}
}|3308244|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/ini.core.php#ini.memory-limit^0|1J|H|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|N|5|F|7|13|8|@]|9|@]|C|$G|H]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

With an out-of-memory error, there are two general approaches. As usual with these choices, you can pick easy-but-wrong and hard-but-right. The easy-but-wrong solution is to increase <a href="http://www.php.net/manual/en/ini.core.php#ini.memory-limit" rel="nofollow">your memory limit</a> to an appropriate level: 

<pre><code>ini_set('memory_limit', '64M');
</code></pre>

the better (although harder) solution is to re-engineer your algorithm to not need as much memory. This is clearly the more sustainable and robust approach. To do this properly, you will need to evaluate what you need to do with the array you are building. For instance, I have written similar scripts which were importing the rows to a database. Instead of building a huge array and then inserting, I did it in batches, where I built an array of 50-100 rows, then inserted those and cleared the array (freeing the memory for re-use).

Pseudo-code: 

<pre><code>for(each row in file) {
 $rows_cache[] = $row[1];
 if(count($rows_cache) &gt;= 50) {
 insert_these($rows_cache);
 $rows_cache = array();
 }
}
</code></pre>

I have a 260k line csv file that has two columns. I have read in the csv file using fgetcsv and have a while loop which reads every line in the file. In the loop I am trying to add the values from the second column to an array. 

When I have the line in to add to the array, my PHP freezes and doesn't finish. I have done debugging and the values are getting added to the array so I know that the adding to array and while loop work but I do not know why it freezes.

If I remove the line the while loop completes going through the 260k lines and then processes the rest of the file.

Here is my code:

<pre><code>$amountRecords = 0;
$totalValue = 0;
$valueArray = array();

// reads in csv file
$handle = fopen('Task1-DataForMeanMedianMode.csv', 'r');
// to skip the header names/values
fgetcsv($handle);

// creates array containing variables from csv file
while(($row = fgetcsv($handle, "\r")) != FALSE)
{

 /*
 echo "ROW CONTAINS: ";
 var_dump($row[1]);
 echo "&lt;br /&gt;";
 */

 $valueArray[] = $row[1];

 /*
 echo "VALUEARRAY NOW CONTAINS: ";
 var_dump($valueArray);
 echo "&lt;br /&gt;";
 */

 $totalValue = $totalValue + $row[1];
 $amountRecords++;

}
</code></pre>

And sample of csv file:

<pre><code>ID,Value
1,243.00
2,243.00
3,243.00
4,243.00
5,123.11
6,243.00
7,180.00
8,55.00
9,243.00
10,55.00
</code></pre>

PHP freezes when adding to array in while loop

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个260k行的csv文件，它有两列。我已经使用fgetcsv读入了csv文件，并使用了一个while循环来读取文件中的每一行。在循环中，我尝试将第二列中的值添加到数组中。当我有要添加到数组中的行时，我的PHP冻结并且没有完成。我已经完成了调试，并且值被添加到数组中，所以我知道添加到数组和while循环可以工作，但...

问PHP在while循环中添加数组时冻结
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP在while循环中添加数组时冻结EN