Download the PHP package invincible-tech-systems/easeampmysql without Composer
On this page you can find all versions of the php package invincible-tech-systems/easeampmysql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download invincible-tech-systems/easeampmysql
More information about invincible-tech-systems/easeampmysql
Files in invincible-tech-systems/easeampmysql
Package easeampmysql
Short Description A very simple and safe PHP library to execute SQL Queries as Prepared Statements on MySQL Database, in an asynchronous & non-blocking way. Methods are provided to prepare a SQL Statement & it's execution separately as different methods (to facilitate caching of prepared statements) as well as together in a single method too, all basing upon Amphp, an event driven concurrent framework in php and its Amphp\Mysql package.
License MIT
Homepage https://www.invincibletechsystems.com/
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package easeampmysql
EaseAmpMysql
A very simple and safe PHP library to execute SQL Queries as Prepared Statements on MySQL Database, in an asynchronous & non-blocking way. Methods are provided to prepare a SQL Statement & it's execution separately as different methods (to facilitate caching of prepared statements) as well as together in a single method too, all basing upon Amphp, an event driven concurrent framework in php and its Amphp\Mysql package.
Why EaseAmpMysql?
Doing SQL Queries on MySQL/MariaDB in a simple and secure way, preventing SQL Injection is always an important thing. on other hand, doing SQL Queries in an asynchronous & non-blocking way improves the responsiveness w.r.t. database queries. This library is based upom Amphp\MySQL Package.
Advantages
- Uses prepared statements
- MySQL/MariaDB Connection object supported at present
- Named parameters syntax, similar to that of PDO syntax, is supported
- While sanitizing inputs is always a good practice, values that are provided as input to
runPreparedQueryorexecuteQuerymethods serve the purpose by securely executing respective DB queries - Have required checks to find database connection errors and to reconnect to the database when preparing db queries
Getting started
With Composer, run
Note that the vendor folder and the vendor/autoload.php script are generated by Composer; they are not part of PDOLight.
To include the library,
As Amphp/dns is among the dependencies of this library, to prevent recursive DNS Server resolution errors that may occur due reasons like open_basedir restrictions/ no access to /etc/resolv.conf file on the linux server etc..., do include the following lines in your code,
Note: Do skip including the above, if incase similar custom DNS Config Loader is loaded from any of the other Amphp/dns dependent libraries like EaseAmyMysqlRedis (https://github.com/invincible-tech-systems/easeamp-mysql-redis) or EaseAmpRedis (https://github.com/invincible-tech-systems/easeamp-redis) in the application.
In order to connect to the database, you need to initialize the EaseAmpMysql class, by passing your database credentials as parameters, in the following order (server hostname, username, password, database name):
To execute a SQL query, while preparing and executing the statement in a single method, executeQuery method has to be called with SQL Query and corresponding values as associative array and the CRUD Operation Type as third parameter.
Note: Values of CRUD Operation Type include: insertWithIntegerAsPrimaryKey | update | delete | selectSingle | selectMultiple
To execute a SQL query, while preparing and executing the statement in two different methods, prepareQuery and runPreparedQuery methods has to be called one after another with SQL Query prepared using prepareQuery method and prepared statement along with corresponding values (as associative array) and the CRUD Operation Type input as third parameter has to be provided to runPreparedQuery to execute the query.
Note: Values of CRUD Operation Type include: insertWithIntegerAsPrimaryKey | update | delete | selectSingle | selectMultiple
License
This software is distributed under the MIT license. Please read LICENSE for information on the software availability and distribution.
