Home > Article > Backend Development > Solution to open_basedir restriction in effect in PHPExcel, openbasedir_PHP tutorial
When using PHPExcel to export execl, I found that there was no problem locally, but when I transferred the website to the rented server, it Error reported, details are as follows:
Warning: realpath() [function.realpath]: open_basedir restriction <span>in</span> effect. File(/tmp) <span>is</span> not within the allowed path(s): (/data/home:/usr/home:/data/home/tmp:/usr/home/tmp:/<span>var</span>/www/disablesite) <span>in</span> /data/home/【服务器名称】/htdocs/【项目地址】/Classes/PHPExcel/Shared/File.php on line <span>136</span><span> 找到对应的File.php的136行,只是sys_get_temp_dir方法的最后一行,查阅网上的方法直接把该方法给替换掉就好了。 </span>
The code is as follows:
<span>public static function sys_get_temp_dir()<br />{<br />if</span> (ini_get(<span>'</span><span>upload_tmp_dir</span><span>'</span>)!==<span>false</span><span>) { </span><span>if</span>($temp = ini_get(<span>'</span><span>upload_tmp_dir</span><span>'</span><span>)) { </span><span>if</span><span> (file_exists($temp)) { </span><span>return</span><span> realpath($temp); } } } </span><span>if</span> ( !function_exists(<span>'</span><span>sys_get_temp_dir</span><span>'</span><span>)) { </span><span>if</span> ($temp = getenv(<span>'</span><span>TMP</span><span>'</span><span>)) { </span><span>if</span><span> (file_exists($temp)) { </span><span>return</span><span> realpath($temp); } </span><span>if</span> (($temp!=<span>''</span>) &&<span> file_exists($temp)) { </span><span>return</span><span> realpath($temp); } } </span><span>if</span> ($temp = getenv(<span>'</span><span>TEMP</span><span>'</span><span>)) { </span><span>if</span><span> (file_exists($temp)) { </span><span>return</span><span> realpath($temp); } } } <br />}</span>