Blog

There are plenty of situations where we need to push MLS files to a particular clients servers and most of the time we use SSH Bash commands to achieve this but certain instances may also be doable using PHP. Such is the case when working with some client servers we may not have access to the servers root. So, a PHP solution was created.

Rather than go into an elaborate or lengthy process we came up with this simple PHP snippet that has thus far worked in most of the instances where the PHP method is required. The process is rather simple. We add a php file to a particular directory where the files reside and then set the script to run on a CRON job to automate the periodical updates. The files within the array are then pushed or uploaded via FTP to the clients domain.

Now although we could have put in conditionals to check first to see if the file exists, this particular script isn’t overtly complex as the script would not run on our end if files did not exist to begin with. However, I do plan on updating this script in no immediate haste to include a file check and even email notification features. You have no idea how many times we have clients that want to know if their daily process worked so adding in an MySQL update and notification feature are certainly forthcoming.

[php]
$host = ‘clickoncehosting.com’; // without http://, with www.
$username = ”;
$password = ’84#1!cYtg94Th’;
// Usually: /public_html/your_dirs/ or even /httpdocs/your_dirs/
$path = ‘/public_html/example/files/’;

$filelist = array(‘filename.csv’, ‘filename2.csv’, ‘filename3.csv’, ‘filename4.csv’, ‘zipfile.zip’, ‘zipfile2.zip’);
$conn_id = @ftp_connect($host);

// login with username and password
$login_result = @ftp_login($conn_id, $username, $password);

// check connection
if ((!$conn_id) || (!$login_result)) {
echo "<p align=’center’>FTP connection has failed!<br/>";
echo "Attempted to connect to $host for user $username</p>";
exit;
} else {
echo "<p align=’center’>Connected to $host, for user $username</p>";
}
if(!@ftp_chdir($conn_id, $path)){
echo "<p align=’center’>Incorrect directory path!</p>";
exit;
};

foreach($filelist as $file){
$upload = @ftp_put($conn_id, $file, $file, FTP_BINARY);
if (!$upload) {
echo "<p align=’center’>FTP upload has failed!</p>";
} else {
echo "<p align=’center’>Uploaded $file to $host as $file</p>";
}
}
// close the FTP stream
ftp_close($conn_id);
[/php]

Configuring the script for FTP upload of files.

[fancy_list style=”circle_arrow” variation=”olive”]

• Set your FTP Configration Params
• Add list of files to the array
• Upload to a directory where files reside.
• Run the script either from browser or shell command.
• I highly suggest you password protect the directory and or keep it out of the publically accessable path.

[/fancy_list]
[button link=”http://clickoncehosting.com/accounts/downloads.php” size=”medium” variation=”olive”]Download Zip File[/button]