我的程序能把本地excel导入到本地数据库中，但是传到服务器上就不行了？？？要把本地excel上传到服务器再导入么。。.。。只有22分了。。。抱歉。。。。
回复讨论(解决方案)
测试下不就知道...你上次到了服务器，你读的是那里的excel？
我读的是本地的excel，我的文件超过了2m，我还没解决上传超过2m的文件呢。。。你知道php如何上传大文件么
2M还叫大文件，你看下php.ini配置文件中的upload_max_filesize是多大
php如何上传大文件啊，我改了php.ini里的php_value upload_max_filesize 10M
php_value post_max_size 10M
php_value max_input_time 300
php_value max_execution_time 300
ini_set('upload_max_filesize', '10M');
ini_set('post_max_size', '10M');
ini_set('max_input_time', 300);
ini_set('max_execution_time', 300);
然后重启啊
还是不行啊
不行是指什么？ 建议贴出错误信息以供分析。
不知道出现了什么问题，或许可以在本地导入数据库之后把本地数据库导出sql再导入线上数据库，也是个解决方法
推荐使用navicat for mysql，这个工具很强大，完全可以满足你要导入excel到数据库的需求，而且简单方便。
php_value upload_max_filesize = 10M
php_value post_max_size = 10M
只在 .htaccess 中生效
ini_set('upload_max_filesize', '10M');
ini_set('post_max_size', '10M');
不会生效，因为执行到的时候，文件早就传过了
你应该在 php.ini里
upload_max_filesize = 10M
post_max_size = 10M
并重启 web 服务
php_value upload_max_filesize = 10M
php_value post_max_size = 10M
只在 .htaccess 中生效
ini_set('upload_max_filesize', '10M');
ini_set('post_max_size', '10M');
不会生效，因为执行到的时候，文件早就传过了
你应该在 php.ini里
upload_max_filesize = 10M
post_max_size = 10M
并重启 web 服务
thanks
When would you use a trait versus an abstract class or interface in PHP?Apr 10, 2025 am 09:39 AMIn PHP, trait is suitable for situations where method reuse is required but not suitable for inheritance. 1) Trait allows multiplexing methods in classes to avoid multiple inheritance complexity. 2) When using trait, you need to pay attention to method conflicts, which can be resolved through the alternative and as keywords. 3) Overuse of trait should be avoided and its single responsibility should be maintained to optimize performance and improve code maintainability.
What is a Dependency Injection Container (DIC) and why use one in PHP?Apr 10, 2025 am 09:38 AMDependency Injection Container (DIC) is a tool that manages and provides object dependencies for use in PHP projects. The main benefits of DIC include: 1. Decoupling, making components independent, and the code is easy to maintain and test; 2. Flexibility, easy to replace or modify dependencies; 3. Testability, convenient for injecting mock objects for unit testing.
Explain the SPL SplFixedArray and its performance characteristics compared to regular PHP arrays.Apr 10, 2025 am 09:37 AMSplFixedArray is a fixed-size array in PHP, suitable for scenarios where high performance and low memory usage are required. 1) It needs to specify the size when creating to avoid the overhead caused by dynamic adjustment. 2) Based on C language array, directly operates memory and fast access speed. 3) Suitable for large-scale data processing and memory-sensitive environments, but it needs to be used with caution because its size is fixed.
How does PHP handle file uploads securely?Apr 10, 2025 am 09:37 AMPHP handles file uploads through the $\_FILES variable. The methods to ensure security include: 1. Check upload errors, 2. Verify file type and size, 3. Prevent file overwriting, 4. Move files to a permanent storage location.
What is the Null Coalescing Operator (??) and Null Coalescing Assignment Operator (??=)?Apr 10, 2025 am 09:33 AMIn JavaScript, you can use NullCoalescingOperator(??) and NullCoalescingAssignmentOperator(??=). 1.??Returns the first non-null or non-undefined operand. 2.??= Assign the variable to the value of the right operand, but only if the variable is null or undefined. These operators simplify code logic, improve readability and performance.
What is Content Security Policy (CSP) header and why is it important?Apr 09, 2025 am 12:10 AMCSP is important because it can prevent XSS attacks and limit resource loading, improving website security. 1.CSP is part of HTTP response headers, limiting malicious behavior through strict policies. 2. The basic usage is to only allow loading resources from the same origin. 3. Advanced usage can set more fine-grained strategies, such as allowing specific domain names to load scripts and styles. 4. Use Content-Security-Policy-Report-Only header to debug and optimize CSP policies.
What are HTTP request methods (GET, POST, PUT, DELETE, etc.) and when should each be used?Apr 09, 2025 am 12:09 AMHTTP request methods include GET, POST, PUT and DELETE, which are used to obtain, submit, update and delete resources respectively. 1. The GET method is used to obtain resources and is suitable for read operations. 2. The POST method is used to submit data and is often used to create new resources. 3. The PUT method is used to update resources and is suitable for complete updates. 4. The DELETE method is used to delete resources and is suitable for deletion operations.
What is HTTPS and why is it crucial for web applications?Apr 09, 2025 am 12:08 AMHTTPS is a protocol that adds a security layer on the basis of HTTP, which mainly protects user privacy and data security through encrypted data. Its working principles include TLS handshake, certificate verification and encrypted communication. When implementing HTTPS, you need to pay attention to certificate management, performance impact and mixed content issues.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Atom editor mac version download
The most popular open source editor
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
Zend Studio 13.0.1
Powerful PHP integrated development environment
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
SublimeText3 Chinese version
Chinese version, very easy to use
