Re: [PHP-DB] refreshing form select boxes with javascript. possible?
Hi, Javascript could be a solution, but only if you have reasonable amount of data. You can find attached a sample HTML page which uses the DOM for doing this. HTH Sorin Ifrim - Original Message - From: Kepa Lyman <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 08, 2001 2:09 AM Subject: [PHP-DB] refreshing form select boxes with javascript. possible? > > Hi, > > I have a MySQL database that contains a table of composer names/ID > numbers, another of symphonies/ID numbers, and another of > symphonies/composer ID's. The problem is that under the search form > now, the search by name does a simple query to the symphonies/ID table > and gets back a result of all available symphonies. > This is cumbersome. What I would like to be able to do, is once the > composer name select box on the search form is selected, have the > symphony name form re-update itself to include only those symphonies > done by the composer. I imagine this would use a javascript "onSelect," > but every time I try to include PHP code in a onselect it gets run > anyway. Any way around this? Can javascript call an exterior PHP > include or something? Without refreshing the whole page? Any ideas? > > the url for the project is symphonynet.datablocks.net. It's the free > datablocks php/MySQL deal, sometimes the connection is pretty slow. > > Thanks, > > Kepa Lyman > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] refreshing form select boxes with javascript. possible?
Hi, I have a MySQL database that contains a table of composer names/ID numbers, another of symphonies/ID numbers, and another of symphonies/composer ID's. The problem is that under the search form now, the search by name does a simple query to the symphonies/ID table and gets back a result of all available symphonies. This is cumbersome. What I would like to be able to do, is once the composer name select box on the search form is selected, have the symphony name form re-update itself to include only those symphonies done by the composer. I imagine this would use a javascript "onSelect," but every time I try to include PHP code in a onselect it gets run anyway. Any way around this? Can javascript call an exterior PHP include or something? Without refreshing the whole page? Any ideas? the url for the project is symphonynet.datablocks.net. It's the free datablocks php/MySQL deal, sometimes the connection is pretty slow. Thanks, Kepa Lyman -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] refreshing form select boxes with javascript. possible?
No, JavaScript is "Client" side, while PHP is "Server" side script, so to call php scripts you have to make a request to the server. If the amount of data is not very large you can get all data needed to run the "application" client side, load the data into JavaScript arrays and refresh the select boxes using JavaScript scripts. Otherwise you must reload the page and process the values posted by the form. HTH. Jayme. http://www.conex.com.br/jjeffman -Mensagem Original- De: Kepa Lyman <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: quarta-feira, 7 de fevereiro de 2001 22:09 Assunto: [PHP-DB] refreshing form select boxes with javascript. possible? > > Hi, > > I have a MySQL database that contains a table of composer names/ID > numbers, another of symphonies/ID numbers, and another of > symphonies/composer ID's. The problem is that under the search form > now, the search by name does a simple query to the symphonies/ID table > and gets back a result of all available symphonies. > This is cumbersome. What I would like to be able to do, is once the > composer name select box on the search form is selected, have the > symphony name form re-update itself to include only those symphonies > done by the composer. I imagine this would use a javascript "onSelect," > but every time I try to include PHP code in a onselect it gets run > anyway. Any way around this? Can javascript call an exterior PHP > include or something? Without refreshing the whole page? Any ideas? > > the url for the project is symphonynet.datablocks.net. It's the free > datablocks php/MySQL deal, sometimes the connection is pretty slow. > > Thanks, > > Kepa Lyman > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]