Help - Search - Member List - Calendar
Full Version: Can jscript make a QUERY to MYSQL, obtain data and put the values in some text boxes?
WorkTheWeb Forums > Webmaster Resources > PHP Help
Support our Sponsors!
David Mndez
Hi,

I need to make a SELECT query to MYSQL (probably with PHP) but through
jscript, then with jscript put the results in some objects!!.

The idea is that when the user click a <select> item and with 'onclick'
event jscript 'call' a PHP file (that makes a QUERY to MYSQL [SELECT data1,
data2, data3 FROM TABLE WHEN ID='SELECT.VALUE') so JScript obtain data1,
data2 and data3. Then with this data and jscript put in on zom text boxes.

Can this be done?

thank you.

Kieren Evans
David Mndez wrote:
QUOTE
Hi,

I need to make a SELECT query to MYSQL (probably with PHP) but through
jscript, then with jscript put the results in some objects!!.

The idea is that when the user click a <select> item and with 'onclick'
event jscript 'call' a PHP file (that makes a QUERY to MYSQL [SELECT data1,
data2, data3 FROM TABLE WHEN ID='SELECT.VALUE') so JScript obtain data1,
data2 and data3. Then with this data and jscript put in on zom text boxes.

Can this be done?

thank you.


ok i do know of an example where javascript called a php file [which

could then do whatever] ... see the firefox downloadometer here:
http://www.infocraft.com/projects/ffcounter/
the php file in question retrieved an rss feed however im sure there is
a way to change that if you just use the js for inspiration

David Alexander
David,

I think that you should be able to find some good resources if you do a web
search on "remote scripting."

The URLs that I have are,

http://www.codeproject.com/aspnet/AlvaroRemoteScripting.asp

http://msdn.microsoft.com/library/en-us/rm...html/rmscpt.asp

but they are oriented towards ASP. I came across examples in other
languages, but I didn't save the links because I work in ASP. Hope this
helps.

David

"David Mndez" <[Email Removed]> wrote in message
news:[Email Removed]...
QUOTE
Hi,

I need to make a SELECT query to MYSQL (probably with PHP) but through
jscript, then with jscript put the results in some objects!!.

The idea is that when the user click a <select> item and with 'onclick'
event jscript 'call' a PHP file (that makes a QUERY to MYSQL [SELECT
data1,
data2, data3 FROM TABLE WHEN ID='SELECT.VALUE') so JScript obtain data1,
data2 and data3. Then with this data and jscript put in on zom text boxes.

Can this be done?

thank you.



Jan831
In bericht <[Email Removed]>, schreef [Email Removed] ...
QUOTE
Hi,

I need to make a SELECT query to MYSQL (probably with PHP) but through
jscript, then with jscript put the results in some objects!!.



this looks like an example of AJAX, where javascript is used to update a page
instead of updating the complete page. It's a rather new approach on dynamic
websites. Google uses it a lot (gmail, google suggest, google maps, ...)

http://en.wikipedia.org/wiki/AJAX
or use google

Jan831


PHP Help | Linux Help | Web Hosting | Reseller Hosting | SSL Hosting
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2006 Invision Power Services, Inc.