[xmxpcom]

I have a text file need to be loaded into a table.

1. How could I write a php program to load the text file into a table?
2. How Could I load the text file automatically every one minute?
Since I do not have access to my ISP server, I guess I can not use cron job to do it.

[fattycat]

This will load a text file into a database table.



$db_host="localhost";
$db_username="your_sql_username";
$db_password="your_sql_password";
$db_database="your_database_name";

$some_file = 'your_textfile.txt';
$fp = fopen($some_file, "r");
$em_footer = fread($fp, filesize($filename));
fclose($fp);

mysql_connect($db_host,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");

$query = "INSERT INTO your_database_table (fieldone, fieldtwo) VALUES ('$valone, '$valtwo)";
mysql_query($query);
mysql_close();

[xmxpcom]

(quote)
$query = "INSERT INTO your_database_table (fieldone, fieldtwo) VALUES ('$valone, '$valtwo)";

Thank you for your code. How Do I related ('$valone, '$valtwo)" to the fields in the text file, should be the first row of the text fie be field name?

Please advice.