Managing Checkbox Look-ups in PHP

By: Steven Seiller on Tuesday, August 3, 2010
Reader Level:

A common practice in CMS content management systems is to allow content to be applied to any number of categories or tags. On a recent project, I needed to create a CMS for articles which could be related to any number of sport categories. The web site editor needed to be able to select any number of related categories for a specific article and these settings were saved in a MySQL lookup table. With this table of many-to-many relationships, I was able to populate a list of category checkboxes for each article as well as to retrieve applicable articles when a specific category was viewed.

This tutorial will show how to create an HTML form with a checkbox for each category and dynamically load settings from a MySQL database. Then, we look at a script for saving the lookup settings. Finally, we'll see the resulting lookup table in action selecting articles which have been tagged to a specific category.

Purchase this item
You can purchase this piece of content separately for $4.00

Want more?
Community MX members get unlimited access to daily articles, tutorials, extensions and support. The most comprehensive resource for Macromedia designers and developers today. Take a tour of what we offer, and discover the benefits of subscribing.

Already a member?
Simply log in using the form in the top right area of the site.