Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-php by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group