DESIGN CONCEPT (performance) - switch/arrays/forms

From: Bruce Young <hbrucey(at)yahoo(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: DESIGN CONCEPT (performance) - switch/arrays/forms
Date: 2003-05-30 23:41:43
Message-ID: 20030530234143.2520.qmail@web10403.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

Responses

Browse pgsql-php by date

  From Date Subject
Next Message brew 2003-05-31 03:36:44 Re: DESIGN CONCEPT (performance) - switch/arrays/forms
Previous Message scott.marlowe 2003-05-30 14:47:27 Re: [PHP] help ?