Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php批量导入数据出错解决方案

php批量导入数据出错解决方案

WBOY
Release： 2016-06-13 13:51:36
Original
1268 people have browsed it

php批量导入数据出错
我现在要做的是，把一个产品数据从EXCEL中导入到PHP的MYSQL中，导入的过程中，总是会提示“Allowed memory size of 167772160 bytes exhausted (tried to allocate 689919 bytes) in D:\wamp\www\Company\product\admin\uploadOrder.php on line 167”这个错误，然后我分成第100条导入时，就不会提示这个错误，这个是不是内存溢出，有没有好的解决方法呢？

------解决方案--------------------
php.ini中讲memory_limit选项设置大一点，然后重启apache或nginx就行了
------解决方案--------------------
文件太大了，这样的话可以用source命令直接导入！
------解决方案--------------------

探讨

我用ini_set('memory_limit','-1');就不会提示错误，请问这样会不会影响到其它

------解决方案--------------------
不过都是设置成0，至于负数没试过
Related labels：
bytes limit memory php
source：php.cn
Previous article： php怎么调用.net的webservice？100分送上 Next article： 从原本的框架文件拆解出一函数.有关问题是不知道如何调用.
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2187
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2333
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1961
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1846
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1899
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template