help unzipping

[matbennett]

Hoping that someone can help with this.

I am writing a script that will run via cron every night to get a large zipped CSV file from a remote server then import it into my database.

File handling is not an area that I have really had need to look at before, so there are a few new steps here for me to handle.

So far I can grab the zip file and save it to my server (baby steps!).

Now I need to unzip it so that I can read the CSV file into my database. The server that I am doing this on does not appear to have the zip module installed, so I have been trying to do this with:

system("unzip  $destinationFile "); 

However, this does not appear to be doing a lot and no unzipped files are to be found.

Can anyone steer me on to the right path with this?

[dalecosp]

Are you sure you can get any result from a backtick/system/shell_exec command?

<?
// a simple test, perhaps...

$result=system('ping -t 1 localhost');
echo $result;
?>

Most sysadmins are paranoid, and the web user (nobody/www/daemon, whoever) has no shell, therefore, no success running such a command.

You'd also need to be sure that the server had the correct zip Sw installed...

[matbennett]

Well the ping worked, but zip is not installed on the server 🙁

Oh well. Time to deal with the big CSV!