PHP coding Question

[art]

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

[ELINTPimp]

On May 7, 12:55 pm, "a...@unsu. com" <[e-mail] wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

No. Drop down menus, for things like navigation bars, have to be done
on the client side. Traditionally this is down with either CSS (I
prefer this way) or JavaScript. PHP will serve to extract the data
from MySQL and format it for the menus. Do a google search for CSS
drop down or JavaScript drop down.

Regards,

Steve

[art]

On May 7, 12:00 pm, ELINTPimp <smsi...@gmail. comwrote:

On May 7, 12:55 pm, "a...@unsu. com" <[e-mail] wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

No. Drop down menus, for things like navigation bars, have to be done
on the client side. Traditionally this is down with either CSS (I
prefer this way) or JavaScript. PHP will serve to extract the data
from MySQL and format it for the menus. Do a google search for CSS
drop down or JavaScript drop down.

Regards,

Steve

Well, I have 2 question with that information:

First, can I use my PHP script to get the data, and then echo
everything, including the javascript? I think that would work.
Second, regarding CSS, I'm not sure how that would work, since the
data is coming from the database.....

Thanks for your quick reply.

John

[ELINTPimp]

On May 7, 1:04 pm, "a...@unsu. com" <[e-mail] wrote:

On May 7, 12:00 pm, ELINTPimp <smsi...@gmail. comwrote:

On May 7, 12:55 pm, "a...@unsu. com" <[e-mail] wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

No. Drop down menus, for things like navigation bars, have to be done
on the client side. Traditionally this is down with either CSS (I
prefer this way) or JavaScript. PHP will serve to extract the data
from MySQL and format it for the menus. Do a google search for CSS
drop down or JavaScript drop down.

Regards,

Steve

Well, I have 2 question with that information:

First, can I use my PHP script to get the data, and then echo
everything, including the javascript? I think that would work.
Second, regarding CSS, I'm not sure how that would work, since the
data is coming from the database.....

Thanks for your quick reply.

John

Hi John,

Yes, that is exactly what you would do with the PHP (gather from db,
than 'echo').

As far as a CSS menu, you can do a google search to get more info/
tutorials...her e is a few:
http://sperling.com/examples/menuh/
http://www.cssplay.co.uk/menus/final_drop.html

Regards,

Steve

[art]

On May 7, 1:07 pm, ELINTPimp <smsi...@gmail. comwrote:

On May 7, 1:04 pm, "a...@unsu. com" <[e-mail] wrote:

On May 7, 12:00 pm, ELINTPimp <smsi...@gmail. comwrote:

On May 7, 12:55 pm, "a...@unsu. com" <[e-mail] wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

No. Drop down menus, for things like navigation bars, have to be done
on the client side. Traditionally this is down with either CSS (I
prefer this way) or JavaScript. PHP will serve to extract the data
from MySQL and format it for the menus. Do a google search for CSS
drop down or JavaScript drop down.

Regards,

Steve

Well, I have 2 question with that information:

First, can I use my PHP script to get the data, and then echo
everything, including the javascript? I think that would work.
Second, regarding CSS, I'm not sure how that would work, since the
data is coming from the database.....

Thanks for your quick reply.

John

Hi John,

Yes, that is exactly what you would do with the PHP (gather from db,
than 'echo').

As far as a CSS menu, you can do a google search to get more info/
tutorials...her e is a few:http://sperling.com/examples/menuh/h...inal_drop.html

Regards,

Steve

I also saw this:
http://roshanbh.com.np/2008/01/popul...x-and-php.html

What do you think of that?

john

[The Natural Philosopher]

ar*@unsu.com wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

Sure. Use the PHP to create the javascript.

[The Natural Philosopher]

ar*@unsu.com wrote:

On May 7, 12:00 pm, ELINTPimp <smsi...@gmail. comwrote:

>On May 7, 12:55 pm, "a...@unsu. com" <[e-mail] wrote:

>>Hi,
I'm sure a PHP genius will know this one.
I need to create 3 linked drop down menus on the page. The data is
coming from Mysql / PHP script.
I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.
Is there a way to create 3 linked drop down menus using PHP???
Thank you.
John

No. Drop down menus, for things like navigation bars, have to be done
on the client side. Traditionally this is down with either CSS (I
prefer this way) or JavaScript. PHP will serve to extract the data
from MySQL and format it for the menus. Do a google search for CSS
drop down or JavaScript drop down.

Regards,

Steve

Well, I have 2 question with that information:

First, can I use my PHP script to get the data, and then echo
everything, including the javascript?

Yes.

I think that would work.

Second, regarding CSS, I'm not sure how that would work, since the
data is coming from the database.....

CSS is styling pure and simple.

You might use that to make things visible or invisible, or control
whether they drop over or under other objects.

Javascript does the actions

CSS controls the styles that are invoked by the actions.

Php handles the data and writes the javsacript on a per page basis.

Thanks for your quick reply.

John

[Tim Streater]

ar*@unsu.com wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page.
The data is coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

What do you mean by "linked menu" ??

[art]

On May 7, 1:34 pm, Tim Streater <timstrea...@wa itrose.comwrote :

[e-mail] wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page.
The data is coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

What do you mean by "linked menu" ??

Well, you select something in the first drop down, and that will
display certain items in the second drop down, etc.....

The URL above seems the simplest to implement. I can just change the
SQL statements and such to match my database......

It looks like it is using AJAX, so most of the code is written for
me. I think I'll go with that, rather than having PHP echo out the
javascript, which can get very cumbersome..... .

Opinions?

And thank you.....

john

[Tim Streater]

In article
<a8************ *************** *******@s50g200 0hsb.googlegrou ps.com>,
"ar*@unsu.c om" <am****@iwc.net wrote:

On May 7, 1:34 pm, Tim Streater <timstrea...@wa itrose.comwrote :

[e-mail] wrote:

Hi,

I'm sure a PHP genius will know this one.

I need to create 3 linked drop down menus on the page.
The data is coming from Mysql / PHP script.

I see lots of examples with this in Javascript, but I am getting the
data from my PHP script via MySQL.

Is there a way to create 3 linked drop down menus using PHP???

Thank you.

John

What do you mean by "linked menu" ??

Well, you select something in the first drop down, and that will
display certain items in the second drop down, etc.....

Right. I thought you meant that but wanted to be sure. When I had to do
this, I started off with the PHP generating a lot of javascript so that
all combinations were covered. This worked OK, but rapidly ceased to
scale.

My second approach involved iframes - putting the second and subsequent
menus in an iframe (a table cell constrains its size nicely). When a
choice is made in the first menu, the javascript causes the iframe to
get loaded with a page. You have to feed the page with the result of the
first menu choice so the PHP in the page can get the right data from the
database for the second menu. Third one works the same.

I've also verified that I can implement this using AJAX, but since the
first approach works I'm unlikely to change it any time soon.

Others may possibly indicate a better container than an iframe to hold
the <select>.