How to read HTML or TXT file and output the data?

[koolkicks311]

Does anyone know if this is possible?
Script reads a HTML file or a TXT file and output the data to MySQL database.

 

[Jim_]

What format is the data in the html or text file in? It's probably possible to parse it using php.

 

[xemiterx]

It is certainly possible to read a file with PHP with file() or file_get_contents() or fread(). Once you have read the information you can do what you like with it, including saving it to a database. If you are more specific with what data you have and what exactly you need to do with it you might get better information.

 

[legend2]

use this and change the lines with //update to match what you have.

$file = "location/filename.extension"; //update
$databasehost = "localhost"; //update
$databaseuser = "username"; //update
$databasepassword = "password"; //update
$databasename = "name"; //update

if(file_exists($file)) {
  $content = addslashes(@file_get_contents($file));
  @mysql_connect($databasehost,$databaseuser,$databasepassword);
  @mysql_select_db($databasename);
  @mysql_query("insert into tablename values(...,'$content',...)");  //update
}