Download the PHP package catsand/pdo-database-wrapper without Composer
On this page you can find all versions of the php package catsand/pdo-database-wrapper. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package pdo-database-wrapper
PDO Database Wrapper
Simple PDO Wrapper with named and question mark placeholders for easy and fast development. Try it!
Requirements
- PHP 5.3 or greater
- PDO extension
Instalation
Download the files.
- You can download them directly and extract them to your web directory.
Composer
composer require catsand/pdo-database-wrapper
Clone the repo
git clone https://github.com/catsAND/PDO-Database-Wrapper.git
Features
- Simple syntax.
- Question mark placeholders with types.
- Named placeholders.
Functions
List
- query
Return number of affected rows
- select
Return array with results
- selectCell
Return string with first column value from first row
- selectRow
Return array with all columns from first row
- selectArray
Return array with first columns from rows as value
- selectHash
Return array with first columns from rows as key and second columns from rows as value
- insert, insertIgnore, replace
Return numbers of affected rows
Column names obligatory need to be in $valueArray first array as key or in $columnsArray array as value.
Examples
Avalaible placeholders:
? — bind value with autotype
?r — bind raw value to SQL query without verification
?i — bind value as integer
?s — bind value as string
?f — bind value as float
?b — bind value as boolean
?n — bind value as null
?q — bind value as string without HTML tags
?a — bind value as integer array.
?j — bind value as string array.
?h — bind value as string array with key as column name and value as column value.
?w — bind value as string array with key as column name and value as column value with delimiter AND.
Named placeholders
Support
If you like this script please support by staring or forking the repository.
How to contribute
Always welcome
- Create an issue on GitHub, if you have found a bug or for enhancement.
- Create a Pull requests for open bug/feature issues.
Thanks to
License
This project is licensed under the MIT License - see the LICENSE.md file for details