First Post This Forum! : PhP - Auto Update MySQL

[Vorspire]

First Post This Forum! : PhP - Auto Update MySQL

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]

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]

Try something like this

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

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... http://www.runuo.com/forums/showthread.php?t=72410

 

[MuadDib]

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