Copy from file to database...

I am still trying to get my online html / php editor to work. I've put if off for some time, now I need to get it working.

I've seen some attempts at it on other sites but I want to create something simple. I can open files to read, but then I want to copy the contents to db, edit with a form, and copy back (write over) old file. This would allow me to edit files online without needing an ftp program.

I'm not looking for someone to build this for me, just a hint at existing code or ideas.

The hard parts for me:
1. assign file contents to variable, from there I can put variable into db.
2. after editing db content, how to save back to file - write over old data.


Thanks.
R.

1. You'll want the fread function(). You'll want to read the entire file this way (use filesize() as the second argument, see php.net for function reference.
Read the file to a variable, then parse the variable in your DB INSERT statement (best use a binary column type for this)

2. Other way around, read the item into a variable, then use the fwrite() function to parse to file.

Note: fwrite is binary-safe by default, but fread will only work properly if you used the 'b' option in your fopen() command. (unless you're reading text files of course :P )

Note 2: If you're using a recent version of PHP (4.3.0 or newer) you can use file_get_contents() instead of fread(). This function is binary-safe.

Thank you for your advice. This is going in the right direction. I just finished reading PHP 5 fast & easy and some of it soaked in. I remember the file commands for filesize().

Thanks again.

Once in the db I can edit, then write to a file. I'll give it a shot.
R.

you're welcome