Hi list!
i am working on a little project where i have a PHP script that selects a form
(located on hard drive)
using the switch statement and "include". for example:
switch ($type)
{
case 1:
include 'forms/add_edit/form_book.php';
break;
default:
show_error("Item Type not found",1);
}
i have about 5 scripts that use switch statement to select forms.
Problem is, right now i only have 1 category ($type). Now when i add about 10
or 20+ more categories, these scripts will start to become a pain to maintain
with all the switch/cases.
My idea is to have a category table with references to the forms on disk so i
can fetch it into an array; search the array to find the corresponding form for
the category id, and include that form;
example:
Category table
id | name | form
---+-------+---------------
1 | Book | form_book.php
--------------------------
$type = $HTTP_GET_VARS['type'];
# select id, form from categories;
# assign array values returned by query
# search if category exists ($type) and present error message
# present corresponding form to $type.
----------
My concern is, would this be too much work on the database and would it be
better to manually code it into the PHP script.
if this concept could work fine, could anyone give me an example on how to do
this? i am just learning PHP. thanks a lot.
- bruce
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com