Revert to HTML ??? 1

[kwkride]

I'm using a free host for my website.
It's one that I build for a non-profit organization.
Several times a month there are times when you can't access my website because there are too many connections to their MySQL database. Is there some way that I could set up my site to go to an html version when this happens instead of giving the user a criptic error mesage?

 

[Cagliostro]

in such cases the answer is to uprgade the computer. Ion Filipski

filipski@excite.com

 

[rycamor]

Yes, its fairly easy, actually. Maybe you are using mysql_connect(hostname,username,password) in its most simple form.

The preferred method when debugging is:

mysql_connect("hostname","username","password") or die(mysql_error());

This outputs the actual MySQL error message if a database connection fails. For your purposes, you can easily change that to something like:

mysql_connect("hostname","username","password") or die(error_handler());

Then you just create a function called "error_handler()" which redirects the user to a static HTML page if the database connection fails. Or, if you want it to be a little more sophisticated, just instruct your error_handling function to include() the appropriate block of HTML code from an outside file. This way, your users stay on the same page, having a seamless experience, without knowing that anything has gone wrong.

 

[kwkride]

Thanks for the info, I really appreciate it.

I know that moving the site to a better host is the real answer, but they don't want to spend any money . . . .

 

[mcvdmvs]

It is also possible to make hard html copies every now and the of ure php pages, i dunno if this is php sided or serversided. But maybe the provider supports it. In that way u can display ure pages without using the mysql db, and if u refresh the pages every hour its up-to-date and also much faster, cause u will parse pure html to the client with no database or script action. mcvdmvs
-- "It never hurts to help" -- Eek the Cat