popuskin2 Posted February 27, 2009 Share Posted February 27, 2009 The file I wish to run resides on the server xxx.com/test.cvs I want to set a cron job to run the script below every day. <?php include "connect.php"; if(isset($_POST['submit'])) { $filename=$_POST['filename']; $handle = fopen("$filename", "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $import="INSERT into prices values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]')"; mysql_query($import) or die(mysql_error()); } fclose($handle); print "Import done"; } else { print "<form action='csv.php' method='post'>"; print "Type file name to import:<br>"; print "<input type='text' name='filename' size='20'><br>"; print "<input type='submit' name='submit' value='submit'></form>"; } ?> Please someone help me restructure it cos cron job can not press the submit button. Thx all Link to comment https://forums.phpfreaks.com/topic/147108-help-restructure-code-run-when-set-with-cronjob/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.