Download the PHP package davidfricker/dataabstracter without Composer
On this page you can find all versions of the php package davidfricker/dataabstracter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download davidfricker/dataabstracter
More information about davidfricker/dataabstracter
Files in davidfricker/dataabstracter
Package dataabstracter
Short Description Minimalist data abstraction and pseudo content provider framework
License MIT
Informations about the package dataabstracter
DataAbstracter
This package is a wrapper around the PDO DBMS driver. It enables easy paramterisation of queries with one function call, aditionally it expoess CRUD operations.
Install
Using composer
composer require DavidFricker/DataAbstracter
Usage
API
delete()
Remove one or more rows. As this is intended to be a simple helper function the only 'glue' to hold together the where clauses is 'AND' more complex delete statements should be performed using run()
.
Example
update()
Update one or more rows. This is intended to be a simple helper function the only 'glue' to hold together the where clauses is 'AND' more complex update statements should be performed using run()
.
Example
fetch()
Pull one or more rows. As this is intended to be a simple helper function the only 'glue' to hold together the where clauses is 'AND' more complex update statements should be performed using run()
. IMPORTANT: Ensure the $columns variable does not contain user input as it is inserted as-is into the statement and as so creates an SQL injection vulnerable.
Example
insert()
Create a new row.
Example
run()
Execute any SQL query. To ensure your query is safe from SQL injection attacks pass all values via the $bind
array.
Example
rowCount()
Fetch the number of rows returned from the last query performed.
Example
Bugs
Please report bugs by creating an issue and supply code to replicate the issue. Code contributions are always welcome.
Licence
Released under the MIT licenses.