Is it possible? I don't want to use PHP for querying, so can I use it only for the connection while using javascript code for the query?
It'd be great if someone can provide an example of it.
Asked
Active
Viewed 124 times
1
-
2you can't use javascript on client side to connect directly to the database, you have to use API – Moustafa Elkady Dec 05 '19 at 11:34
-
2Not possible, your database is at the server-side, and can be accessed from the server only. – Teemu Dec 05 '19 at 11:35
-
Does this answer your question? [Run a SQL query in JS](https://stackoverflow.com/questions/37453671/run-a-sql-query-in-js) – robinvrd Dec 05 '19 at 11:35
-
You can use Node? – Martin Dimitrov Dec 05 '19 at 11:40
-
1Use AJAX if possible otherwise you can't add query in js – HP371 Dec 05 '19 at 11:40
-
1The idea that you could create a database connection in one language, and then use it in a different one, is already absurd enough to begin with. – 04FS Dec 05 '19 at 11:44
-
@Teemu well, one could simply open up the db ports to the public .... ;) – Jonas Wilms Dec 06 '19 at 10:54
-
@JonasWilms Indeed, I wouldn't do that though, and I suppose you wouldn't either. – Teemu Dec 06 '19 at 12:00
1 Answers
1
You can't query MySQL through JS because by default JS is clientside meaning it has no direct access to the databse server. If that were possible then anyone could just edit your JS and query whatever they want from the DB.
You can potentially use AJAX to call a PHP function from inside your JS code but all database queries have to be done through PHP since that's where you create the connection.
If you wanted to build your own request in JS then you'd have to switch to a framework like AngularJS or Node.js where the back-end is written in JS rather than PHP, but these are more complex.
Grumbunks
- 1,027
- 1
- 7
- 21
-
1For sure you *can* but as you point out in your second sentence *you don't want that* – Jonas Wilms Dec 06 '19 at 10:54
-
@JonasWilms True, I just did it. Installed serverside js and now I'm able to query through it. – Zuberi Dec 07 '19 at 04:11