search
HomeBackend DevelopmentPHP Tutorialphp5.4.17 如何配置才能支持 pear运行?

php PHP5 pear

原先使用的apache2.2+php 5.2.17,近期因为用户增多了,php代码占系统负载相当高,所以想升级php到最新版的 5.4.17,原本满怀希望5.4能提高代码性能,帮我暂时解决掉燃眉之急!
 却发现5.4很多地方跟5.2不兼容,原先5.2能用的功能在5.4都跑不起来!   可愁死我了! 

安装pear 时候执行的以下操作:
cd php/php go-pear.pharpear list -- 执行正常


如:原导出 excel 用的 pear库:Spreadsheet_Excel_Writer-0.9.3 ,装5.4之后发现默认不带pear的安装包,费尽周折装上 pear之后,这个导出excel功能也运行不起来。莫名奇妙的报了下面的错误:
Warning: require(../../inc/conn.php): failed to open stream: No such file or directory in C:\wwwroot\excel.php on line 2PHP Fatal error:  require(): Failed opening required '../../inc/conn.php' (include_path='.;C:\php\pear') in C:\wwwroot\excel.php on line 2Fatal error: require(): Failed opening required '../../inc/conn.php' (include_path='.;C:\php\pear') in C:\wwwroot\excel.php on line 2


导出代码在5.2版本是可以正常运行的,可5.4版本弄的我是一头雾水!~ 
请遇到过此类问题的兄弟帮解答下吧!多谢了! 

回复讨论(解决方案)

你可能要放弃 pear 了,或者就是放弃 php5.3及以上版本
php 升级太快,同时又给自己加了许多限制
pear 的贡献者们没有精力跟上 php 的变革步伐,或者根本就不赞同 php 的变革

你可能要放弃 pear 了,或者就是放弃 php5.3及以上版本
php 升级太快,同时又给自己加了许多限制
pear 的贡献者们没有精力跟上 php 的变革步伐,或者根本就不赞同 php 的变革  额,问题这么严重。。
我现在用的 5.2.17性能有些跟不上了,迫切需要优化。不然我也不会随便改动版本的~ 

请问版主 php导出excel 可有什么好方法啊? 之所以用pear 就是因为他有 Spreadsheet_Excel_Writer 这个性能比较不错的excel导出类库,原先用的phpexcel 性能太差劲了,而csv格式又不能满足需要!~
如果您那有好用的导出excel方式提供,不胜感激啊!!~

如果是仅仅需要 Spreadsheet_Excel_Writer 类,那倒不妨将他及相关文件拷贝出来
不过在 php5.4 中报错不多的话,改一下还是可以用的

如果是仅仅需要 Spreadsheet_Excel_Writer 类,那倒不妨将他及相关文件拷贝出来
不过在 php5.4 中报错不多的话,改一下还是可以用的

我试过拷贝这个类库到站点目录,5.4版本执行仍然是没反应 打开php.ini的错误日志 也没输出什么问题,只有在 php安装目录 执行 

php c:\wwwroot\excel.php 的时候会输出上面的错误!~

我现在也是迫不得已而为之。 请问版主 可有其他好的导出excel的方法啊?!谢谢!

system.php 
function tmpdir() 改为 static function tmpdir() 

OLE.php
function Asc2Ucs($ascii) 改为 static function Asc2Ucs($ascii)
function LocalDate2OLE($date = null) 改为 static function LocalDate2OLE($date = null)

Worksheet.php 2490行
$this->_append(&$string, true); 改为 $this->_append($string, true);

这样就应该可以了,如果还有错的话,生成的 xsl 文件中是可以看到错误信息的

system.php 
function tmpdir() 改为 static function tmpdir() 

OLE.php
function Asc2Ucs($ascii) 改为 static function Asc2Ucs($ascii)
function LocalDate2OLE($date = null) 改为 static function LocalDate2OLE($date = null)

Worksheet.php 2490行
$this->_append(&$string, true); 改为 $this->_append($string, true);

这样就应该可以了,如果还有错的话,生成的 xsl 文件中是可以看到错误信息的

多谢 多谢 我试试1~

system.php 
function tmpdir() 改为 static function tmpdir() 

OLE.php
function Asc2Ucs($ascii) 改为 static function Asc2Ucs($ascii)
function LocalDate2OLE($date = null) 改为 static function LocalDate2OLE($date = null)

Worksheet.php 2490行
$this->_append(&$string, true); 改为 $this->_append($string, true);

这样就应该可以了,如果还有错的话,生成的 xsl 文件中是可以看到错误信息的  
哎,试过了,依然没有效果!~ 没有任何报错~

Statement
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
PHP Performance Tuning for High Traffic WebsitesPHP Performance Tuning for High Traffic WebsitesMay 14, 2025 am 12:13 AM

ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

Dependency Injection in PHP: Code Examples for BeginnersDependency Injection in PHP: Code Examples for BeginnersMay 14, 2025 am 12:08 AM

You should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.

PHP Performance: is it possible to optimize the application?PHP Performance: is it possible to optimize the application?May 14, 2025 am 12:04 AM

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

PHP Performance Optimization: The Ultimate GuidePHP Performance Optimization: The Ultimate GuideMay 14, 2025 am 12:02 AM

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

PHP Dependency Injection Container: A Quick StartPHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPDependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyPHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools