read file from folder then insert contents into table

mrsocks

i may be missing the obvious here.

i would like to create a script that reads a file from a folder then uses that information to insert into a table.

ex.
read test.txt file (has html in it)
insert test.txt contents into certain cell in a table.

i have tried fopen, but cant get any data to display or read.
tried readfile but that just displays the content in the browser.

any suggestions would be great.

thanks

matt_wilkes

Hi mate !

You could use something like this...

<?php

$filename="textfile.txt";    // <- exact path of text file
$fd=fopen($filename, "r");

while ($text = fgets($fd,4096)){
	print "$text";
}
fclose($fd);

</td>
</tr>
</table>

Good luck !

ednark

matt_wilkes solution will work...

but php has some special built-in functions that are supposed to make this even easier

read up on these they should all solve your problem:

[man]readfile[/man]
[man]include[/man]
[man]require[/man]

mrsocks

i have tried:

readfile but that seesm to only display the file in the browser, i dont need it to do that, just read it annd then instert it into the cell in my table.
include: i currently use that to read the txt files and insert the info into a form that we use to modify the items. that words great but i cant seem to think of how it would work in my situation. doesnt include get the file contents and work them into the html? i just need it to be read and then inserted into the celll.

-require: havent tried it, but not sure how that would work either (in my situation, i know ho wto use include and require normally, but can i use either of these to assign the contents as a variable that i can use to insert into the cell?)

thaks for the feedback.

happy holidays.

ednark

why won't this work:
just place your readfile where you would otherwise have printed it


$file_name = "./cell1.txt";

print "<table>"
print "<tr>"
print "<td>"

readfile($file_name);

print "</td>"
print "</tr>"
print "</table>"

mrsocks

oh... i see where the confusion is...

sorry about this.

I mean i want to read the text file and insert it into a cell in a table IN A DATABASE.

i am really sorry for the confusion. i am able to get the functions to work for it to read into html tables but not to get the info and have it go to the database table.

briansol

try something like this:

<?
$file_name = "./cell1.txt";

$html =<<< EHTML
<table>
<tr>
<td>
readfile($file_name);
</td>
</tr>
</table>
EHTML;

$sql = "INSERT INTO table (field) VALUES ($html);"
//db stuff here....
?>