Export to excel error in PHP reports

Question

I export reports as excel using PHP & MySql. I can export and open the file from my localhost using my source code, but unable to do in the server. When I try to export it shows "Warning: tempnam() [function.tempnam]: open_basedir restriction in effect. File() is not within the allowed path(s): (/home:/tmp:/usr) in /home/xx/xx.inc.php on line 205." I googled through, but I'm unable get the solution.

$this->_tmpfilename=tempnam("/tmp", "excelreport");

$fh=fopen($this->_tmpfilename, "w+b");

This is the code that used. What's wrong.

Check your server temp path and necessary folder permissions — swapnesh, May 20 '13 at 09:21
What library are you using to create your Excel file? If it uses temporary files, then it should provide some method for you to say where those files are created — Mark Baker, May 20 '13 at 09:23

score 0 · Answer 1 · answered May 20 '13 at 09:22

0

Your hosting restricts your PHP activity within your home folder. Create a tmp folder within your home folder (i.e. /home/xx/tmp/ ), chmod it 777 to solve this problem.

Note: the /tmp folder is used by the server itself. In shared hosting environment, you are often restricted not to touch the server's system folders ( folders other than /home )

answered May 20 '13 at 09:22

Raptor

53,206
45
230
366

I tried & still the same warning message – Raj May 20 '13 at 09:41
what is the full path of your file ? – Raptor May 20 '13 at 09:42
/home/xx/public_html/pms/excelreport – Raj May 20 '13 at 10:17
then your code should be `$this->_tmpfilename=tempnam("/home/xx/public_html/pms/", "excelreport");` – Raptor May 20 '13 at 10:35

Export to excel error in PHP reports

1 Answers1