如何每天从另一台服务器自动加载数据

您好我需要创build一个自动连接到另一个服务器使用PHP库，然后我需要加载数据在MySQL数据库只有第一个file upload一个新的file upload每天。 问题是我如何每天继续上传文件到数据库我几乎在那里

这里是代码：

<?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 = 'testemail@yahoo.co.uk'; $subject = 'the subject'; $message = 'hello'; $headers = "From: The Sender Name <senderEmail@yahoo.co.uk>\r\n"; $headers .= "Reply-To: senderEmail@yahoo.coom\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'; } 

• 限制Imagemagick使用的空间和内存
• 如何使用procfs将内核数据发送给用户空间？
• Qt应用程序GUI – 自动启动–linux
• 从其他程序获取选定的文本内容
• 共享内存C ++ – PHP