Text File to Mysql database

[freebsd_dude]

Hello All,

I need to make a Php script that will run at the command line.

I have a text file that gets updated every hour. The text file has the data in a sql statement.

The contents of the text is:

INSERT INTO testdata VALUES ('154A', 'user1');
INSERT INTO testdata VALUES ('155A', 'user2');
INSERT INTO testdata VALUES ('156A', 'user3');
INSERT INTO testdata VALUES ('157A', 'user4');

named users.txt

Thank you

😕

[laserlight]

If you're on a Unix type system, e.g. FreeBSD, you could consider using the cron table.

[freebsd_dude]

Do you have any example of a php command script that would so this?

thank you

Originally posted by laserlight
If you're on a Unix type system, e.g. FreeBSD, you could consider using the cron table.

😕 😕

[laserlight]

Unfortunately no.

From what I know, you have to set the cron table normally, since basically what it does is run something (in this case a PHP script) at regular intervals.