PHP Forms Help on list menus

theunies

I have to list menus in a form. Both list menus are created by a database. I need a user's input on one list menu to change the options in another list menu. Can someone help me?

$rows_affected = mysql_affected_rows($dbh);

if ($rows_affected > 0) {			

	$area = $area . "<label><select name='tour_id'><option>Hotel</option>" ;

	while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) { 


		$area = $area . "<option value='" . $row{'area'} . "'>" . $row{'area'} . "</option>";

		}

	 $area = $area . "</select></label>" ;

}

$query = "SELECT hotel, tour_id FROM concierge_program ";

$result = mysql_query($query);

$rows_affected = mysql_affected_rows($dbh);

if ($rows_affected > 0) {			

	$hotel = $hotel . "<label><select name='tour_id'><option>Hotel</option>" ;

	while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) { 


		$hotel = $hotel . "<option value='" . $row{'tour_id'} . "'>" . $row{'hotel'} . "</option>";

		}

	 $hotel = $hotel . "</select></label>" ;

}
?>

NogDog

Welcome to the forum.

Please note that we have a whole bunch of "bbcode" tags here for formatting your posts, most importantly the

[/b] tag for making your code samples much more legible and color-coded.

Anyway, the sort of thing you are talking about will require client-side processing (i.e.: JavaScript), since PHP is running on the server and has no idea what the user is doing in the browser. You will either need to generate the necessary JavaScript from your PHP script and output it within the HTML that you generate, or you could use an [url=http://www.google.com/search?q=AJAX+and+PHP]AJAX implementation[/url], combining JavaScript and PHP.

theunies

I'm not familiar with AJAX. Is there some way you can explain it to me in more detail or show me an example?

halojoy

theunies wrote:
I'm not familiar with AJAX.
Is there some way you can explain it to me in more detail or show me an example?

AJAX is practically a new word for 'JAVA'. The 'J' stands for Javascript.

As java had gotten into shadow of popular PHP,
they had to invent some new word for it, I think.
.. and it WORKED!!! 😃

AJAX is now very popular. There are many variants.
Even bundles of JAVA + PHP, like an ajax-variant called XAJAX.
PrototypeJS (JS=javascript) is another.

some links for explore this

http://en.wikipedia.org/wiki/AJAX

http://www.prototypejs.org/
http://en.wikipedia.org/wiki/Xajax

http://xajaxproject.org/

There are Complete Frameworks in AJAX.
For your website setup.
http://en.wikipedia.org/wiki/Ajax_framework

regars 🙂
halojoy

NogDog

Halojoy: note that Java and JavaScript are two different programming languages (which unfortunately, for various marketing reasons at the start, share the word "Java" in their name).

Anyway, AJAX refers to the use of a particular functionality with JavaScript that allows you to send HTTP requests and then wait for and process the response by using a XMLHttpRequest object. The request would be sent to a server-side script (e.g.: PHP) tailored to return appropriate data to such a request (which can send post or get data just like a form would), and then the XMLHttpRequest object waits for a response. When it gets a successful response, it can take the text/data returned from the server and manipulate the page contents via the DOM objects.