How to run PHP FILE for specific time and update Database fields automatically

Question

I am very new in php/mysql. After searching everywhere I am asking here: my client has provided me one txt file, now I need a script to run frequently so that txt new data file will run and also at the same time update a database.

One option I have read about is Cron, but my client denied that solution, so I can only go with a PHP (or, if possible, ajax or jquery) based solution.

My code so far:

<?php
$string = file_get_contents("mytest.php/test1.txt", "r");
$myFile = "E:/path/test.txt";
$fh = fopen($myFile, 'w') or die("could not open: .mysql_error());
fwrite($fh,$string);
fclose($fh);

// Here is the connection file
$sql=mysql_connect("localhost","root","");
if(!$sql) {
  die("couldnotconnect:", . mysql_error());
}
mysql_select_db("timer"); // databse name
$result=mysql_query("LOADDATAINFILE'$myFile'" ."INTOTABLEchangedtFieldsTERMINATEDBY''");
if (!$result) {
  die("couldnotload . " . mysql_error());
}
?>

But this code is not working properly. Basically just another text file through I just want to update my database like:

Database Field:

Name (varchar 250)
LastModification timestamp

thank you sir, but i am not able to use cron whole day i have searched for this but client has denied that i have to use only php, or else i can do with ajax or jquery if possible, anyway thank you for review my question. — Prerak Dave, Apr 24 '13 at 16:22
Please only put the code in the code tag. Crontab is really the only way you're going to get it done. — Alexis Tyler, Apr 24 '13 at 16:24
Well sir, i have no much idea about cron or crontab, let me check it out first.. — Prerak Dave, Apr 24 '13 at 16:26

score 1 · Answer 1 · edited May 23 '17 at 10:25

Your client needs to understand that cron is the correct solution to this problem. If your script needs to run on a regular schedule, cron is the way to accomplish it.

If you are unable to convince him, there are two other less optimal options. The first is to make your script run all the time without exiting. It will sleep for a period, wake up, check if the current time matches the scheduled run time, and act accordingly.

The second is to make use of an online scheduling service to execute your script via an HTTP request at the specified time. The online scheduling service will use cron under the hood, but your client doesn't need to know that.

score 0 · Answer 2 · answered Apr 24 '13 at 16:30

0

You don't necessarily need the scheduled task/CRON to be run on the webserver. You can have the PHP file on your webserver, and have a scheduled task or cron script on another machine that called the PHP script (via HTTP GET or SSH terminal) and this would solve your problem.

You could also schedule this call on 2 different clients for redundancy and have a flag (for that day) to be set to true in order to gaurantee the PHP script is only run once daily.

When I mean flag I mean a database row, a value in a file or anything other way to check that the script has been run for that day.

answered Apr 24 '13 at 16:30

Menelaos

23,508
18
90
155

actually i need script which run frequently which should run not a single time in a one day but multiple times.. – Prerak Dave Apr 24 '13 at 16:47
if SOME 1 CAN HELP ME WITH AJAX OR JQUERY THAT IS ALSO REALLY APPRECIATE, STILL STRUGGLING FOR LOOKING SUCH A CODE – Prerak Dave Apr 25 '13 at 05:53
@Prerak Dave It is bad etiquette to use all caps locks. – Menelaos Apr 25 '13 at 10:28

How to run PHP FILE for specific time and update Database fields automatically

2 Answers2