Dynamic Page Storage

[utmanns]

I have a function that is used to build News pages. When it is called it reads in a page, replaces some fields, names the page and then stores it.

My problem is with trying to decide on the easiest way to make these pages editable from my site.

I store all the News information except the Main body in the database. The only place the Main body exists is in the stored file that was created by the function.

I have narrowed down two possiblites to make these editable-

1). Store the Main Body in the database so it can be edited, a new page can be created and the old one deleted.

2.) Instead of creating files in the first place at storage, I place the main body in the database and then everytime the page is accessed it is drawn on the fly.

I am mostly concerned with performance. Any recomendations would be appreciated.

[ednark]

ask yourself what you want to do with the info... for simple storage sql as a database may a bit much...

if you don't need to use any of the features of sql.. combining columns in results, and dynamic searches... then you might not need it...

if the rest of your site exists in sql.. and each page load you are already making a connection, you won't suffer a huge hit by using it, and it may make your main body code more similar to the rest of your site...

neither solution is stupid.. i would choose whichever is easiest for you to implement...

[utmanns]

Thanks for the reply ednark-

I am using the database to log users so I do need the Sql. I guess I was just worried about the time it would take to bring in a file, change it and then display it.

I was trying the following code to create my page on the fly, without retrieving the message body and it seemed fairly fast, but I am worried about the pace when 20 - 50 people connect at one time.

function buildnewspage($news_id,$title_link,$short_desc,$news_body,$author,$district)
$pagetitle="newspage".$news_id;
    $handle = fopen ("input.php", "rb");


while (!feof ($handle)) {
    $buffer = fgets($handle, 4096);
    $invariables=array("temp_replace_titlelink","temp_replace_shortdesc","temp_replace_newsbody","temp_replace_author");
    $outvariables=array($title_link,$short_desc,$news_body,$author);
    $cleanbuffer= str_replace($invariables, $outvariables, $buffer);
     echo ($cleanbuffer);
}
fclose ($handle);