Export to excel error in PHP reports [duplicate]

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
– swapnesh, Commented May 20, 2013 at 9: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
– Mark Baker, Commented May 20, 2013 at 9:23

Raptor · Accepted Answer · 2013-05-20 09:22:06Z

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, 2013 at 9:22

Raptor

54.4k47 gold badges254 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Raj Over a year ago

I tried & still the same warning message

Raptor Over a year ago

what is the full path of your file ?

Raj Over a year ago

/home/xx/public_html/pms/excelreport

Raptor Over a year ago

then your code should be $this->_tmpfilename=tempnam("/home/xx/public_html/pms/", "excelreport");

Collectives™ on Stack Overflow

Export to excel error in PHP reports [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related