This extension allows you to call Sql operations without using any script.
This can connect to the MySQL Database with it’s url,username and password.
It would connect to the server directly with JDBC, there won’t be any kind of third party interfering in the connection, the connection is directly between Your Application And The MySQL Server.
Image From : JDBC Tutorial
There is one more specialty of this extension, It supports prepared statement block to prevent Sql Injection.
A prepared statement is a feature used to execute the same (or similar) SQL statements repeatedly with high efficiency.
Prepared statements basically work like this:
- Prepare: An SQL statement template is created and sent to the database. Certain values are left unspecified, called parameters (labeled “?”). Example: INSERT INTO MyGuests VALUES(?, ?, ?)
- The database parses, compiles, and performs query optimization on the SQL statement template, and stores the result without executing it
- Execute: At a later time, the application binds the values to the parameters, and the database executes the statement. The application may execute the statement as many times as it wants with different values
This does not require any kind of special configuration, you just need to allow all IP address at remote sql because every mobile phone ip address is different
Thanks to @chaimk for Sponsoring this extension!
You can ask me any doubt below.
PayPal - 17.5 USD
PayTM - 1000 INR