Static html in Dreamweaver

Using a database in Dreamweaver to produce static html

[dramstore]

Hi

Question regarding dreamweaver and static html pages.

I'm fairly familiar with dreamweaver but not when used with a database.
I currently have a 60 page site which is static html on a unix machine. Tired of the headaches of hardcoding changes in dreamweaver I want to put my data into a database and use dreamweaver to produce the pages.

I am reluctant to convert all the static html files into php and use dynamic html as the user enters no information and therefore the pages served to everyone will be exactly the same.
I would image dynamic html would be a machine overhead I dont need, also I see a lot of sites serving up mysql errors instead of the site so I'm trying to avoid this and produce static html PC side and upload plain .html files to my unix server.

Question is - can I use a database and sql in dreamweaver to produce static .html files?

Thanks.

[krt1]

I doubt DW has a feature for that but you can make a script in a language such as PHP that will generate .html files from the database information.

Those SQL errors on other sites are mainly because the user gave up on their site and doesn't care... thus doesn't maintain his code. MySQL errors shouldn't worry you because if you think about it, MySQL and other databases are used everywhere without problem eg. this forum

[leveldisc]

Welcome to WebmasterWorld.

Are you sure you should be doing this?

[4specs]

I think you are missing a key feature of DreamWeaver and FrontPage - static includes.

DW calls them library functions - you put the static include in the library and include it on your page. When you update the library, every page is updated and needs to be uploaded.

FP calls them HTML Includes and the function is similar.

This combines the best - less editing of sitewide includes and static service. You will have to edit every page once to include the code, and then you are done.

I use the DW library function to include a php include that does the same, except changes do not require an upload. I am running php on each page to gzip the file for most users in any case.

[dramstore]

Thanks for the advice on this - not decided on the way forward for this site yet, but for anyone reading this with a similar query I also thought of a work around could be to use a temp web site with DW, php and mysql as normal to produce a dynamic html site. Then from the real site use a 'WGET -R' to pull all the files from the temp site over.

Although the files would still be .php they would all contain static data - a bit messy but should work.

LevelDisc - what do you mean by that?