Re: dynamically populate drop-down list and dynamically include html file
- From: IchBin <weconsul@xxxxxxx>
- Date: Wed, 30 Aug 2006 16:21:42 -0400
Jerry Stuckle wrote:
Yi Chen wrote:We have a drop down list on a PHP page, with several product names, and
when people click one item, we will refresh the same page with the
product name as parameter, and in turn we want to include a HTML file
into the content area of the same page.
I know it is recommended to put everything into database, but we want
the web site to be very "portable", so the drop-downlist and the
content should both in text files.
Let's say the drop-down list will be poplulated from the product.txt
file, and there will be a file for each corresponding item in the
drop-down list. From the user point of view, if he wants to add a new
product, he will just need to open the product.txt file, and add a new
line with the product name, "Laptop", then add a new text file named
"laptop" in the same folder which contains the HTML fragment to be
included in the content area.
What is the easiest way to do this?
I'd use a database. The vast majority of sites use MySQL for a database, but if you want it to be portable you can use the PEAR::MDB2 package. It's portable to many different databases.
You could do it with a flat file, but it will make your job a lot harder (and the data much more prone to errors).
If you opt to use PEAR::MDB2 you may want to look at PEAR HTML_QuickForm for loading the dropdown. You can do it using three lines of code. Here I am loading a Category dropdown. Take a peek at the Docs.
// Create a HTML <Select> and define the DB column and label
$s =& $form->createElement('select','u_category','Category:' );
//
// Load the <Select> from DB with SQL select
$s->loadQuery($MDB2, $category_dropdown_select);
//
// Add the <Select> object to the HTML Form
$form->addElement($s);
--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
.
- References:
- Prev by Date: Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' PDO exception
- Next by Date: Re: What editor is the most common in PHP developer?
- Previous by thread: Re: dynamically populate drop-down list and dynamically include html file
- Next by thread: easy php1-8 problem
- Index(es):
Relevant Pages
|
