store php in mysql?

matt2012

Is it possible to store php in a database in a text field then run it on a page. The idea is that you have an index.php page with a recordset and a single statement that calls the php for the page from the database.

I realise there is a problem about when the php code gets run but dosent obs_start() allow a work around for that?

the idea would to be have a one page website with everything else stored in a mysql database.

tekky

sure it's possible, but using includes would be easier...

matt2012

I use includes now, and think it is a great way to simplyfy designing complex applications.

However you can not update includes online.

The advantage with having all code stored in a database is that you can edit it easily anywhere in the world. You can mdularise it and create a system where one class can be tested against another class. The idea is to make a site that is truly dynamic from classes, css, frontend rules, backend rules. Everything can be swapped at ease.

SO 2 Questions

how do you make sure php is executed on the page even though it has to be retrieved from the database first?
what are the downsides to doing this.

AstroTeg

Originally posted by matt2012

However you can not update includes online.

Why not? [man]fopen[/man], [man]fgets[/man] (or [man]fread[/man]), [man]fclose[/man].

Open your include file, write out the new version and close the file. Depending on your needs, this could be as simple as 3 lines of code.

I'd steer away from the database approach because: You're attempting to use the database as a file system. Let the file system do what its best at - serving files (it'll even do caching on its own too). I'm positive you can do what you're talking about with files. Check out how some of the larger scale PHP projects do their file and class including (Zen Cart might be a good one).

cheese

..... or use Filezilla (FTP prog) and attach you choice of editor and you can then load a temp copy back to your PC. When you finish the edit, it gets put back to the server. only lose the file for a few milliseconds during update.

Cheers,

Neil

tekky

Originally posted by cheese
..... or use Filezilla (FTP prog) and attach you choice of editor and you can then load a temp copy back to your PC. When you finish the edit, it gets put back to the server. only lose the file for a few milliseconds during update.

Cheers,

Neil

That's not quite the definition of dynamic he was going for I don't believe... he want's things to be swappable at anytime without 'rewriting' them and uploading them by the sound of things...