Hey everyone,

I am in the process of developing my first home brewed CMS. Things are looking good so far! I am using PHP on top of a MySQL database to run things. I want to give the user the ability to change the look of the site by editing the CSS styles, kinda like how Wordpress theme editor works. How can this be done? Does the PHP script actually edit a CSS sheet? or does it add and edit variables stored in the database that are later dumped into a dynamic CSS sheet? Whats the best possible route to take, and can anyone point me in that direction?

My advise would be to add a row in the user's account database whith a "basic" css template by default, then let user change some values using a html form with color pickers, each color selection will return a hex equivalent (you may find these pickers around very easily), this value is entered into the POST to be published instead of the original css on mysql.

At this point lets say every user has a customized css stored on their account, now how to make this css be used on the site as user logs in for example.