Display a text file

25lez25

If you have a text file, sometext.txt, can you place it in your mysql table in a field " textfiles" and what would be a command in a while loop that could display the contents of the file ?

while($row = mysql_fetch_array($result))
{

If you can do this, is there any advantage over just placing the text directly into the field, not as a file, and printing the text?

ereptur

Why would you want to put this file in a MySQL Database? You could do so if you set up a table with a BLOB field. BLOB fields accept binary input.

My suggestion would be to leave the file where it's at and to read it to the screen, just use

$file_contents=file("sometext.txt");
echo $file_contents;

25lez25

For example I'll rephrase the question:

while($row = mysql_fetch_array($result))
{

include (“$row['textfiles']”);

Looking for the proper syntax for the include function here or comparable that would do the following:

so that if the value in the textfiles field for any row was sometext.txt, the include function would then display the contents of sometext.txt;
would like a different text file to be displayed depending upon which row was being looked at. This is when the text file is very long and so maybe it is better to put the lengthy text into a file than directly input the text into the database.

ednark

http://www.mysql.com/doc/en/BLOB.html

read up on two types you might want to use here...

see if these manual pages answer your question for you

25lez25

Also wondering if a field of your table was instead, 'HTMLfile', and in each row of that field was entered somefile.HTML

while($row = mysql_fetch_array($result))
{

include (“$row['HTMLfile']”);

Would it be possible to do an include function above so that the contents of somefile.HTML would be displayed ? What would the correct syntax be for this?

Thanks