Basic content management

We need a basic content management system to manage dynamic (often small) parts of the HTML code on our site. The code parts are to be saved in a mysql database. The code shall be inserted by us at specific places in our php code by a function call: insert_htmlcode_here($placement_id). Further requirements: •Secure admin log in (using php sessions -> $_SESSION[‘isAdmin’] should be available also for other use) •When admins surf the website they should be able to doubleclick on the page elements to enter edit mode (only the page elements that are shown by the function defined above). I.e. the script should surround the custom html code with a “div” tag to detect an ondlblclick event. •Edit mode means opening a sized new window with a textarea element to edit the html code of the element that was clicked. It must include a preview button to see the code “in action” in it’s original location (update the parent window using innerHtml on the div tag), before storing to the mysql base with a save button. •The edit window must also include a version history for future publishing. Example: say I have 2 different future versions of the same HTML code to be shown: version 1 to be published at 22.30 on 2006-12-01 and to be seen until 12.25 on 2006-12-05. Version 2 is to be published on 18.49 2006-12-24 and be viewable until 19.50 2006-12-24. In the meantime, the time between the two versions, the function should return just an empty string. •Archive versions -we must also be able to recall and view previous versions of the code. •Tab buttons to switch between archive versions, current edit mode, and future versions of the code in the edit window. (Important: remembering what has been written already in the current edit window) •The first times a new element_id is inserted into the php code - i.e. when I for the first time insert the php code” insert_htmlcode_here(7);” and the id 7 is not used before it should display “click to edit” for admins in the browser. When the admin has clicked this link we should enter edit mode, and the necessary rows should be inserted into the mysql table. Uploaded is a basic example of php code that hopefully clarifies things a bit.