From PHP to HTML?

[Mr Initial Man]

I've considered converting both my websites from being PHP-based to HTML and/or XML based. I have reasons...

1) Most of the pages of my personal site are includes-based; being a writer of fiction, I have text files here, there and everywhere. A few more files will make no difference.

2) The Coach Random comic is complete; Future updates are unlikely. To make the code for comics compact, I've come up with an XML setup that works well.

3) The host my two websites are on is having difficulties with its MySQL database. This is the second time a hack attack has sent it sprawling. I'd like to get away from server-side stuff, since it seems to be problematic.

[KDLA]

So.... what's your question? :)

[Mr Initial Man]

Is this a wise thing to do, or should I just wait the problems out?

[Declan1991]

Personally, I'd hate to move away from a MySQL database. I really like them. But then, XML is just as good, I just don't like it as much.

[scragar]

Personally, I'd hate to move away from a MySQL database. I really like them. But then, XML is just as good, I just don't like it as much.
XML and MySQL are just as good, but useful for two completely different things, XML is great for smallish amounts of data, and for being human editable, MySQL is fantastic for both large and small amounts of information, but a human is unlikly to be able to edit the database.


As for the discussion at hand I think if your content is fairly static(as in not changing all the time) then exporting it all to HTML with a few server side includes would probably be your best bet(although the comic needs some thinking about, that would be a fair number of pages). as for you having text files here, there and everywhere.I'm sure they could be sorted out better(into a few directories), sorting them via purpose or name would be a good idea, although that would again, require edits to the code..

[Ultimater]

I personally let the task choose its own language according to what I feel most comfortable with from the programming end from the perspective of how well I program it such that the language has enough power to get the job done and which ever I feel is more suitable for the job so I can move on and keep things organized.
In other words whichever you feel most comfortable with to get the job done based on the specific task and situation after taking into account things like database issues and the whole picture. After weighing the scales what you feel is the better answer. Don't be afraid to mix languages and make use of the strengths of one language over another while also using another language for its power in another area. As long as you successfully express yourself with the language.

[Mr Initial Man]

As for you having "text files here, there and everywhere." I'm sure they could be sorted out better(into a few directories), sorting them via purpose or name would be a good idea, although that would again, require edits to the code..

Oh, they're all sorted into proper directories; I'm just saying I've got a lot of text files.