First Post This Forum! : PhP - Auto Update MySQL

[Vorspire]

w00t for the first post of this forum!

Is it possible to make a php script that will automatically take data from a .txt file and enter it into tables in MySQL on LocalHost?

If so, how can i make MyRunUO upload to an FTP instead of ODBC to the Database, as the database i use does not support external connection...

[Phantom]

Originally Posted by Admin Vorspire

w00t for the first post of this forum!

Is it possible to make a php script that will automatically take data from a .txt file and enter it into tables in MySQL on LocalHost?

If so, how can i make MyRunUO upload to an FTP instead of ODBC to the Database, as the database i use does not support external connection...

Why don't you make it support an external connection. There is no reason you can't, can even only allow connections from a certain ip/dns address.

The answer to your question, is yes its possible, but it wouldn't perform very well.

[Vorspire]

The service host i am using say that ODBC could cause security risks... So they won't install it.

[TMSTKSBK]

Is it possible to make a php script that will automatically take data from a .txt file and enter it into tables in MySQL on LocalHost?

most assuredly, and I have no idea.

[LightShade]

I didn't test this, but I think this is what you're looking for....

PHP Code:

mysql_connect("localhost","username","password") or die ("Couldn't Connect to Server...");
mysql_select_db("database") or die ("Couldn't Connect to Database...");
$fp = fopen("test.txt", "r");
while (!feof)
{
$text = fgets($fp, 255);
$query ="INSERT INTO table (field)";
$query.=" VALUES ('$text')";
$result=mysql_query($query);
} 


[MuadDib]

You could always make the php script to run on your shard pc as cmdline task through the task scheduler and do it that way. Does your host allow non-local host connections to the mysql databases?

Or, Modify the server to fire that connection and do the same. Send the text file's info through the connection in the server. I've done very similar in the past, using a shard script to update a mysql db on the fly from an in game command (listing of all npc types and such). Was not on RunUO though, but, with the C# it should be very easily done.

[Kenny164]

Nice advice, but a bit late... [RunUO 2.0 RC1] Complete Automated Web Accounting Service 1.0

[MuadDib]

Better late than never...... always forget to check thread dates, hehehe.