How do I load data automatically from another server everyday [duplicate]

Hi I need to create something automatic that connects to another server using a php library and then I need to load the data in a mysql database only the first file uploads a new file is uploaded everyday. The problem is how do I continue uploading a file everyday to the database I am almost there

Here is the code:

<?php include 'core/init.php'; include 'includes/overall/header.php'; //connection to linux server $conn = ssh2_connect('xxx.xxx.xx.xxx', 22); $destinationPath = '/path/to/destination/path/'; $localPath = 'C:\path\to\local\path\'; //checks if the connection is successful or not if(ssh2_auth_password($conn, 'username', 'password')){ echo '<script type="text/javascript">alert("Authentication was successful"); </script>'; //javascript pop up when successful }else{ die("Authentication failed"); } if(ssh2_scp_recv($conn, $destinationPath, $localPath)){ echo '<h2>Todays file recieved</h2>'; //if file was recieved from server to local echo todays file recieved, putting the file in localpath }else{ //if the file was not uploaded send an email for radar file too be uploaded $to = '[email protected]'; $subject = 'the subject'; $message = 'hello'; $headers = "From: The Sender Name <[email protected]>\r\n"; $headers .= "Reply-To: [email protected]\r\n"; $headers .= "Content-type: text/html\r\n"; mail($to, $subject, $message, $headers); 

}

$string = file_get_contents('http://localhost/Prototype/core/edit.txt', 'r');//get contents of file from web used to read the file $myFile = 'C:wampwwwPrototypecoreedit.txt';//file directory $fh = fopen($myFile, 'w') or die("Could not open: " .mysql_error());//open the file fwrite($fh, $string); fclose($fh); $result = mysql_query("LOAD DATA LOCAL INFILE '$myFile'". "INTO TABLE `restartdata` FIELDS TERMINATED BY ',' "); if (!$result) { die("Could not load." . mysql_error()); }else{ echo 'data loaded in the database'; }