I have created a button on PHP-MyAdmin to allow me to dump a database table to XL - Click on the button and XL opens and the table appears in XL format (I use it for account management etc).
Great, except it works on my localhost (NT 4 running Apache) but not on the remote server? On the remote, it only loads some of the tables' entries? If there are ten rows of information, it might load only 6 of them and returns this error in the process:
WARNING: fopen("dbDumps/clients/xls","w") - Permission denied /var/www/html/siteadmin/dumpBD.php on line 53
WARNING: Supplied argument not a valid File-Handle resource in /var/www/html/siteadmin/dumpBD.php on line 54
WARNING: Supplied argument not a valid File-Handle resource in /var/www/html/siteadmin/dumpBD.php on line 55
Anybody know why this is? Here are lines 51 - 55 of the code:
Put contents in file
$filename = "dbDumps/" . $table . ".xls";
$fp = fopen($filename, "w");
fwrite($fp, $contents);
fclose($fp);
