Download the PHP package javanile/hamper without Composer
On this page you can find all versions of the php package javanile/hamper. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download javanile/hamper
More information about javanile/hamper
Files in javanile/hamper
Package hamper
Short Description Developer friendly database library for vtiger
License MIT
Informations about the package hamper
Hamper DB
Developer friendly database library for vtiger. Hamper improove the code quality and the readbility of your PHP code around database access and manipulation.
Why I use it?
Here is a list of compelling reasons to use it
- Avoid old-style loop over results.
- Use by default associative array for fields.
Installation
You can install the package via composer:
Usage
You simply get your $hdb
object to access on database
📃 Documentation
😎 The documentation lists all the functions you can use to make the code simple and easy to read.
The access you have on the data inside the database is based on extraction methods that return array
and that you can easily manipulate with foreach
.
Use the functions well because they allow you to take a single record or a list of records or all the values of a column.
Before starting to use it, read the list of functions carefully, and you will automatically use the best one based on the context.
For each function you are also presented, the "😿 Legacy", the version of the old style Vtiger code you can replace with Hamper functions,
comparing them, and you will realize how Hamper improves your work.
All Functions
The following methods are used to manipulate records into database
- Execute query -
$hdb->query(...)
- Get a single record -
$hdb->fetch(...)
- Get a list of records -
$hdb->fetchAll(...)
- Get a value from record -
$hdb->fetchValue(...)
- Get value by key column -
$hdb->value(...)
- Check if record exists -
$hdb->exists(...)
- Insert a record -
$hdb->insert(...)
- Get last ID -
$hdb->lastInsertId(...)
- Update a single record -
$hdb->update(...)
- Delete a single record -
$hdb->delete(...)
The following methods are used to manipulate database tables and fields
- Create new table -
$hdb->create(...)
¶
Execute query
Executes the given parametric query
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->query(...)
function
[back to top ☝]
¶
Get a single record
Fetches the next row from the result set rows by the given parametric query.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->fetch(...)
function
[back to top ☝]
¶
Get a list of records
Returns an array containing all of the result set rows by the given parametric query.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->fetchAll(...)
function
[back to top ☝]
¶
Get a value from record
Fetches the next row from the result set rows by the given parametric query.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->fetchValue(...)
function
[back to top ☝]
¶
Get value by key column
Execute a query to check if record with specific key and value exists.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->value(...)
function
[back to top ☝]
¶
Check if record exists
Execute a query to check if record with specific key and value exists.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->exists(...)
function
[back to top ☝]
¶
Insert a record
Inserts the given record within the selected table.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->insert(...)
function
[back to top ☝]
¶
Get last ID
Return last insert ID value for the selected table.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->lastInsertId(...)
function
[back to top ☝]
¶
Update a single record
Updates the given record with the given data.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->update(...)
function
[back to top ☝]
¶
Delete a single record
Deletes the given record within the given table.
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->delete(...)
function
[back to top ☝]
¶
Create new table
Usage
Examples
This method is useful to handle this situations
😿 Legacy
Please, replace this kind of legacy code with the $hdb->create(...)
function
[back to top ☝]
Changelog
Please see CHANGELOG for more information on what has changed recently.
Testing
Contributing
Please see CONTRIBUTING for details.
Security
If you discover any security related issues, please email bianco@javanile.org instead of using the issue tracker.
Socialware
We highly appreciate if you create a social post on Twitter with following button
Credits
This project exists thanks to all the people who contribute.
Support us
Javanile is a community project agency based in Sicily, Italy. You'll find an overview of all our projects on our website.
Does your business depend on our contributions? Reach out us on Patreon.
License
The MIT License (MIT). Please see License File for more information.