content management

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I would really appreciate some advice from anyone who has worked with or
developed their own content management system.

This is my scenario, when i have finished creating a site, i want to be able
to add in the CMS with a minimum amount of fuss. I want to be able to get
the CMS to recognize all the tables and somehow allow me to set the tables
and fields that the client can update safely (i.e. if it is an employment
recruitment site then they will be able to add jobs but not job_id). This
will save me so much time rather than having to handcode the CMS for every
site.

I think i have an answer to my problem, and would be interested to hear your
opinion. When i install the CMS it will read the existing tables and create
2 new tables:

CMS_TABLES
cms_table_id(PK)
cms_table_name
cms_table_is_editable

CMS_FIELDS
cms_field_id(PK)
cms_table_id(FK)
cms_field_name
cms_field_is_editable
cms_field_type
cms_field_size
cms_field_is_primary_key

As an administrator I will be able to set fields and tables which are
editable. Now when i go to the database management page i can do 'SELECT *
FROM CMS_FIELDS WHERE cms_table_id = '$_GET[table_id]' AND
cms_field_editable = TRUE

Also does anyone have any suggestions for editing static content?

Any comments here would be greatly appreciated.

Thanks





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux