Problem: We are going to be creating various types of content (news (HTML Pages), Articles (HTML Pages), Whitepapers (HTML and PDF Files), and video (short news and presentations) and we need to be able to organize, display and search the content.
Ideally, we’d be looking at something with a data model that could handle the following attributes:
Content Type - (News, Article, Whitepaper, Case Study, etc).
File Type - (HTML, PHF, video, etc).
Filename - The actual file name of the content (.htm, .pdf, .swf files)
Access Type - (Open, Registration Required, Paid)
Cost – if paid content – the cost.
Description (short 1 paragraph description)
Front Flag - this indicates if this content item (more specifically the name and the description) are on the main page of the section corresponding to the content type. For example on the Real RFID site, there are 3 sections (News, Articles and Whitepapers). If this flag were set the name and description would display in that section on the main page (in the sort sequence indicated by sort sequence field).
Sort sequence (if active in a section)
Additionally, there will be an archive page available for each section that has ALL of the content created for the section without regard to whether it is currently on the main page. In other words, News, Articles and Whitepapers will each have an archive page that will have a listing (in creation date order) of all pages created for that section of the site. But only those that we mark as being on the front page show up in the small section on the main page of the site for that type of content (news, articles, whitepapers, etc.).
We’d like to be able to search using both keywords and text. Potentially the easiest way to do this might be to always place the keywords and the description as meta tags in the file (although I’m not sure how you do this with video).
We'd consider anything that addresses the requirements (open source PHP whatever). The site is PHP.