Posted by J.O. Aho on 10/01/62 11:23

gene.ellis@gmail.com wrote:
> Hello everyone,
>
> I am in the midst of creating a database driven website in which I
> create newstories that are published on a website. I create the stories
> via a web interface, and this data is inserted into a SQL database. All
> of the newstories are simply dynamically created .php pages based on
> the data which has been inserted into the database. My question is does
> anyone have any suggestions for how to create a testing environment? In
> the current setup, when the data is placed into the database, that
> means it is visable to everyone. I would really like a way to insert it
> into the database, and then only have the content visable to the pages
> on my development server. And then somehow "publish" this new content
> so that it can then be visable on the production server. What are your
> sugggestions or ideas? Thank you very much!
>

If the development machine uses the same database, then just include another
column which may have the values 0 and 1, default set to 0, in the "production
servers" scripts, set that the column has to have the value 1 to be displayed.

If you use two different databases, then you just have to export/import the
content of the database.


//Aho

[Back to original message]