By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

populate one menu from another

P: n/a
I thought this would be simple and there would be advice / tutorials
everywhere for this, but now that I'm working on it, I can't find any
reference except for ASP or Javascript code. PHP/MySQL - 3 form select
menus: Project, Categories, Subcategories. When a Project is selected, the
Categories list is populated based on Project selected, then Subcategories
list is populated based on Category selected. I see this all over the Net,
but through 10 books, there isn't anything specific. I think I get lost
with some of PHP structure since I've been using DW - I end up editing most
of it in order to follow it, but DW works pretty good for getting initial
testing done. I just can't seem to find further guidance on this. So far I
have:

<form enctype="multipart/form-data" action="add_file.php" method="post">
<table>

<tr>
<td width="23%" rowspan="2" valign="top"><p><strong>Project:<br />
</strong>
<select name="project">
<?php
do {
?>
<option value="<?php echo
$row_projects['projCode']?>"><?php echo $row_projects['projCode']?></option>
<?php
} while ($row_projects = mysql_fetch_assoc($projects));
$rows = mysql_num_rows($projects);
if($rows 0) {
mysql_data_seek($projects, 0);
$row_projects = mysql_fetch_assoc($projects);
}
?>
</select>
</p>
<p><strong>
Category:
<select name="category" id="category">
<option>Select a category...</option>
<option value="<?php echo $row_categories['catName']?>"><?php
echo $row_categories['catName']?></option>
<?php
do {
?>
<?php
} while ($row_categories = mysql_fetch_assoc($categories));
$rows = mysql_num_rows($categories);
if($rows 0) {
mysql_data_seek($categories, 0);
$row_categories = mysql_fetch_assoc($categories);
}
?>
</select>

</strong></p>
<p>

</p></td>
<td width="26%" valign="top"><p><strong>Subcategory:</strong>
<select name="subcategory" id="subcategory">
<option>Select a subcategory...</option>
<?php
if (isset('category'))
{
if ($row_subcat['catID']==$row_categories['catID'])
{
do
{?>
<option value="<?php echo $row_subcat['subcatName']; ?>"></option>
<?php
}
while ($row_subcat = mysql_fetch_assoc($subcat));
$rows = mysql_num_rows($subcat);
if($rows 0)
{
mysql_data_seek($subcat, 0);
$row_subcat = mysql_fetch_assoc($subcat);
}
}
}
}
?>
</select>

Thanks for any help with this.

Chris
Jul 10 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Mosf of the examples you have seen are probably using javascript, with
php you realise the page needs to reload when a cat is chosen? PHP
can't dynamically update the menu without loading the page again, you
would the user to choose a catergory, then have a submit button to post
the var or a link like page/index.php?cat1=$cat1 and so forth. Probably
recommend javascript for this though.

Flamer.
Chris wrote:
I thought this would be simple and there would be advice / tutorials
everywhere for this, but now that I'm working on it, I can't find any
reference except for ASP or Javascript code. PHP/MySQL - 3 form select
menus: Project, Categories, Subcategories. When a Project is selected, the
Categories list is populated based on Project selected, then Subcategories
list is populated based on Category selected. I see this all over the Net,
but through 10 books, there isn't anything specific. I think I get lost
with some of PHP structure since I've been using DW - I end up editing most
of it in order to follow it, but DW works pretty good for getting initial
testing done. I just can't seem to find further guidance on this. So far I
have:

<form enctype="multipart/form-data" action="add_file.php" method="post">
<table>

<tr>
<td width="23%" rowspan="2" valign="top"><p><strong>Project:<br />
</strong>
<select name="project">
<?php
do {
?>
<option value="<?php echo
$row_projects['projCode']?>"><?php echo $row_projects['projCode']?></option>
<?php
} while ($row_projects = mysql_fetch_assoc($projects));
$rows = mysql_num_rows($projects);
if($rows 0) {
mysql_data_seek($projects, 0);
$row_projects = mysql_fetch_assoc($projects);
}
?>
</select>
</p>
<p><strong>
Category:
<select name="category" id="category">
<option>Select a category...</option>
<option value="<?php echo $row_categories['catName']?>"><?php
echo $row_categories['catName']?></option>
<?php
do {
?>
<?php
} while ($row_categories = mysql_fetch_assoc($categories));
$rows = mysql_num_rows($categories);
if($rows 0) {
mysql_data_seek($categories, 0);
$row_categories = mysql_fetch_assoc($categories);
}
?>
</select>

</strong></p>
<p>

</p></td>
<td width="26%" valign="top"><p><strong>Subcategory:</strong>
<select name="subcategory" id="subcategory">
<option>Select a subcategory...</option>
<?php
if (isset('category'))
{
if ($row_subcat['catID']==$row_categories['catID'])
{
do
{?>
<option value="<?php echo $row_subcat['subcatName']; ?>"></option>
<?php
}
while ($row_subcat = mysql_fetch_assoc($subcat));
$rows = mysql_num_rows($subcat);
if($rows 0)
{
mysql_data_seek($subcat, 0);
$row_subcat = mysql_fetch_assoc($subcat);
}
}
}
}
?>
</select>

Thanks for any help with this.

Chris
Jul 10 '06 #2

P: n/a
Gary L. Burnore wrote:
On 10 Jul 2006 16:13:03 -0700, "flamer di******@hotmail.com"
<di******@hotmail.comtop posted like a moron and wrote:

>>Mosf of the examples you have seen are probably using javascript, with
php you realise the page needs to reload when a cat is chosen? PHP
can't dynamically update the menu without loading the page again, you
would the user to choose a catergory, then have a submit button to post
the var or a link like page/index.php?cat1=$cat1 and so forth. Probably
recommend javascript for this though.


The php code can generate the javascript code. Best of both "hello
worlds".

>>Flamer.
And you can generate javascript code without php, also.

You completely missed the point.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 11 '06 #3

P: n/a
Hi All,

I did find several Javascript-based sets of code, but knew I need something
where the JS controls the element but had no 'static' variables or arrays .
One of them has Javascript refresh the page, and another keeps the
visibility off of secondary listboxes until the primary one is selected. I
think I will try this one as the <optionscan be populated with PHP, then
the Javascript/CSS controls when they appear. I did this with a cascading
menu - where the JS/CSS only controlled the element (byID) and it worked
fine. If this works out, I will post the final code here.

Thanks,
Christina

"Jerry Stuckle" <js*******@attglobal.netwrote in message
news:Mp******************************@comcast.com. ..
Gary L. Burnore wrote:
>On 10 Jul 2006 16:13:03 -0700, "flamer di******@hotmail.com"
<di******@hotmail.comtop posted like a moron and wrote:

>>>Mosf of the examples you have seen are probably using javascript, with
php you realise the page needs to reload when a cat is chosen? PHP
can't dynamically update the menu without loading the page again, you
would the user to choose a catergory, then have a submit button to post
the var or a link like page/index.php?cat1=$cat1 and so forth. Probably
recommend javascript for this though.


The php code can generate the javascript code. Best of both "hello
worlds".

>>>Flamer.

And you can generate javascript code without php, also.

You completely missed the point.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jul 11 '06 #4

P: n/a
I have faced exactly the same problem:

Chose a region,then a county then a district...

Two choices with PHP without using javascript. First one is to present
each question one at a time and pass the values through the forms which
is a PITA!

Second one. Generate a single drop down list that looks like the
following:-

------Primary1
---Secondary1
Tertiary1
Tertiary2
Tertiary3
--Secondary2
Tertiary4
Terrary5
------Primary2
---Secondary3
Tertiary6
Tertiary7
and validate that the user has selected a valid tertiary value before
processing the form

If you want my code post a reply here and I will pm you

Obiron
Chris wrote:
Hi All,

I did find several Javascript-based sets of code, but knew I need something
where the JS controls the element but had no 'static' variables or arrays .
One of them has Javascript refresh the page, and another keeps the
visibility off of secondary listboxes until the primary one is selected. I
think I will try this one as the <optionscan be populated with PHP, then
the Javascript/CSS controls when they appear. I did this with a cascading
menu - where the JS/CSS only controlled the element (byID) and it worked
fine. If this works out, I will post the final code here.

Thanks,
Christina

"Jerry Stuckle" <js*******@attglobal.netwrote in message
news:Mp******************************@comcast.com. ..
Gary L. Burnore wrote:
On 10 Jul 2006 16:13:03 -0700, "flamer di******@hotmail.com"
<di******@hotmail.comtop posted like a moron and wrote:
Mosf of the examples you have seen are probably using javascript, with
php you realise the page needs to reload when a cat is chosen? PHP
can't dynamically update the menu without loading the page again, you
would the user to choose a catergory, then have a submit button to post
the var or a link like page/index.php?cat1=$cat1 and so forth. Probably
recommend javascript for this though.
The php code can generate the javascript code. Best of both "hello
worlds".
Flamer.
And you can generate javascript code without php, also.

You completely missed the point.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 12 '06 #5

P: n/a
<comp.lang.php>
<frothpoker>
<12 Jul 2006 06:02:20 -0700>
<11*********************@m79g2000cwm.googlegroups. com>
I have faced exactly the same problem:

Chose a region,then a county then a district...

Two choices with PHP without using javascript. First one is to present
each question one at a time and pass the values through the forms which
is a PITA!

Second one. Generate a single drop down list
You could use the ip address and store via a flatfile .

$skunk=$_SERVER['REMOTE_ADDR'];
$bjob=str_replace(".","_",$skunk);

$filename="demo/$bjob" . "_menu.php";
$fp=fopen($filename,"r");
$qaz=fgets($fp); $temp1=trim($qaz);
fclose($fp);

$filename="demo/$bjob" . "_demo.php";
$fp=fopen($filename,"r");
$qaz=fgets($fp); $temp1=trim($qaz);
fclose($fp);

read/write to suit etc .
--
Encrypted email address
www.emailuser.co.uk/?name=KRUSTOV
Jul 12 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.