A Question:

[batskeets]

Here's one for the db-savvy kids out there: Is there a way to burn a website onto CD, and have its PHP and MySQL documents work properly on said CD?

I kind of doubt that such a method exists, but if anyone knows of one, *please* enlighten me! The ONHW apparently burns its web site onto a resource CD every quarter, and the only good way I can think of to get the database-driven info over is saving the docs from a browser window and renaming them properly. It'd be nice if they didn't have to do that every time.

If you couldn't tell, I'm working on the web site as we speak, and the answer to the above question is going to affect one of my decisions on how to re-structure the database.'

Damnit, my headache is coming back. >_< I hate that.

Comments

[wednesday]

I think the answer is, "not unless the end user is prepared to take the contents of the CD and set them up on a PHP/MySQL-enabled web server on their own."

[threeleet.livejournal.com]

This is true. So there are basically 2 scenarios w/ their appropriate choices:

1) You're showing off your L337 coding skills to someone (potential employer?), so you want them to be able to view the raw PHP and db structure, in which case you just copy the php file structure and mysql db files to the CD, and whoever's running it has to have a server running PHP & mysql to view it.

2) You want a CD with the content as viewed via the web, without the raw PHP & db stuff visible, in which case you have to make a "canned" demo. I had to do this several times for NewHomeNetwork (now simply a skeleton w/ links to affiliate pages), and it basically consisted of going to one of each type of record page & saving it w/ all the images & stuff. We had some fancy GUI program to do it, but since it was only for demo (i.e. something to fit on a floppy and show potential clients, not mirror the entire thousands of home records of the site), and there was only 1 of each page type, I had to go in & edit some links by hand so they didn't point to non-existant pages. If you're doing a full site mirror, though, you can just use wget -r, although care must be taken to not make infinite copies of each page w/ slightly longer query strings on each one, which will depend on the file names & stuff.

[sagarmatha.livejournal.com]

On CD's:

PHP documents, yes, they're relatively static.

MySQL database, no, they're dynamic as all hell and require write access.

[nukey.livejournal.com]

I'd look into using "wget --mirror" and a few other flags. I know it is possible to have it automatically rename .php to .html, and there's lots of info in that help file

http://www.openconcept.ca/index.php/Linux/wget (http://www.openconcept.ca/index.php/Linux/wget) sorta has a starter for that.

[drinkdrano.livejournal.com]

Oh it took me like eighteen hundred times listening to that song to realize it's about anal sex. I was like, :o when I realized it.

I'm html-illiterate so I can't be of any actual help aside from making unnecessary comments(if that can be considered helpful).