Upload then move to MySQL

[treeleaf20]

If a file successfully gets uploaded to a web server does anyone know any code or knows how to move the content of that file and insert it into MySQL?

The file would be an html document.

Thanks.

[_RL_Ian]

Is the file a text file?

If so you could do something like this (I didn't test it, but it should work)

<?php
$fh = fopen("yourfile.txt", "r" );

if ($fh)
{
	while (!feof($fh))
  	{
    	$buffer .= fgets($dataFile, 4096);
  	}
}

$sql = "INSERT INTO table (field) VALUES (" . $buffer .")";
mysql_query($sql);
?>

[treeleaf20]

The file is an excel spreadsheet that is being saved as an html file. How would I display the file then?

Thanks

[Fernashes]

It shouldn't matter as long as it is HTML and therefore text. You should be able to do it the way RL(Ian) has said.