Possible Duplicate:
How to connect to SQL server database from javascript?
How can I run sql query inside javascript function? Hope you can help. many thanks.
-
1If it was possible, it would be a huge security hole! Javascript is generally client-side, and that would mean that users of your web site could make arbitrary SQL queries.Philippe Plantier– Philippe Plantier2011-09-10 17:07:35 +00:00Commented Sep 10, 2011 at 17:07
-
2Are you refer to SQLite supported by Chrome and Firefox?ajreal– ajreal2011-09-10 17:08:08 +00:00Commented Sep 10, 2011 at 17:08
-
Please read then re-read the first sentence of the accepted answer on the referenced post, then ignore the middle bit containing the script example, then read the second last sentence. Use ajax calls to server side scripts to do stuff like this.Kev– Kev2011-09-11 12:48:50 +00:00Commented Sep 11, 2011 at 12:48
Add a comment
|
3 Answers
Unless you are using something like node.js, the javascript code is executed on the client side (in the user's browser), so it doesn't have access to the SQL server.
You should do the SQL query on the server side (e.g. in PHP or the language you use on the server side), and do Ajax requests on the client side.
Comments
Short answer is, you can't. But you can use ajax to fire a request to the server, which runs the query and returns the results.
6 Comments
Philippe Plantier
... and it would be a terrible idea to do so, because any user could then run arbitrary SQL queries. Bad, bad, bad.
Yuck
@Gruikya: A terrible idea to use AJAX? Really?
Arnaud Le Blanc
@Gruikya, hopefully he was not suggesting to send SQL queries to the server for it to execute them directly ;)
Philippe Plantier
A terrible idea to use AJAX to send a SQL request to the server, which the server would then execute. (Unless you are writing some kind of SQL console, that is)
Philippe Plantier
@arnaud576875 better safe than sorry! I actually saw an intern do something like that on a web application: a SQL query was generated using Javascript, then sent to the server which executed it without even any kind of attempt at sanitization. Eww.
|
JavaScript is client side, SQL is server side. Probably you just have to write a server script, like in PHP, that return sql results and with javascript and AJAX technology get that results and work on it with javascript on client side. Learn about AJAX and ie. jQuery.
5 Comments
szamil
"ability to connect to the server" - SQL server installed on client machine? Isn't it still server-side SQL?
szamil
I see that we have misunderstood. I was thinking about running SQL query on client side, you are talking about sending SQL query to SQL server (which, as described above in comments, may be bad idea)...