I am currently building (a 1001th) community website. I already build the whole interface with hundreds of lines of CSS. Also the relational MySQL database is also build ready in MySQL Workbench.
I set up a fully working multi-language and ActiveRecord CodeIgniter workspace so I'm read-set to go.
I have one last thing I'm pondering about. The user's preferences storing methodic.
I had something like this in the DB structure:
" pref (VARCHAR(45))
" value (TEXT)
I know the methods to store arrays in the a DB-field etc. but I was wondering how others do it. I want to do it DB-wise.
Now I can achieve things like:
$query = mysql_query("SELECT * FROM user_preferences WHERE users_id == $_SESSION['user_id']");
$result = mysql_fetch_assoc($query);
// Some loop through these 2 values to combine them in a logic result
// After collecting all data storing them in a ordered array or object and store it in the SESSION or something like that