Download the PHP package easeappphp/pdolight without Composer
On this page you can find all versions of the php package easeappphp/pdolight. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download easeappphp/pdolight
More information about easeappphp/pdolight
Files in easeappphp/pdolight
Package pdolight
Short Description A very simple and safe PHP library to execute PDO based database queries. 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.
License MIT
Homepage https://www.easeapp.org/
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 pdolight
PDOLight
A very simple and safe PHP library to execute PDO based database queries. 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.
Why PDOLight?
Doing SQL Queries on MySQL/MariaDB in a simple and secure way, preventing SQL Injection is always an important thing. This library is kept simple so, queries can be written and values are provided as an associative array when making DB queries.
Advantages
- Uses prepared statements
- MySQL/MariaDB Connection object supported at present
- Named parameters supported basically instead of question mark
"?"placeholders - 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,
In order to connect to the database, you need to initialize the PDOLight class, by passing your database credentials as parameters, in the following order (server hostname, username, password, database name, charset, port number, pdo default fetch mode):
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: insert | 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: insert | update | delete | selectSingle | selectMultiple
License
This software is distributed under the MIT license. Please read LICENSE for information on the software availability and distribution.
All versions of pdolight with dependencies
ext-pdo Version *