Download the PHP package silverslice/easydb without Composer
On this page you can find all versions of the php package silverslice/easydb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download silverslice/easydb
More information about silverslice/easydb
Files in silverslice/easydb
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 easydb
EasyDb
EasyDb is a simple wrapper over standart myslqi extension.
What does this library offer you?
- Use placehoders with different types to pass data into query safely.
- Select one cell or all rows with only one method.
- Insert and update rows by passing column-value arrays.
- Use transactions with only one method.
- Executes multiple queries to load your sql dumps.
- Peforms multiple inserts and
insert... on duplicate updatequeries without ton of code.
Install
Use composer to install library.
composer require silverslice/easydb
Connect to the database
Placeholders
EasyDb uses placeholders to place data in the query.
Types of placeholders
? - smart
In most cases you can use this placeholder. It automatically detects your value and correctly formats it.
- Integer value will be inserted as is.
- Null value will be inserted as NULL keyword.
- Database expressions will be inserted as is.
- In other cases value will be inserted as string.
?i - integer
Value will be cast to int with intval function.
?s - string
Value will be escaped with mysqli internal escape function and will be wrapped with single quote.
?f - float
Value will be cast to float with floatval function.
?a - array
This placeholder expects array, correctly escapes and quotes its values, and separates them by comma.
It is useful in queries like SELECT * FROM table WHERE id IN (1, 2, 3)
?u - set
This placeholder expects column-value array and generates code for SET clouse
?e - escape
Value will be escaped with mysqli internal escape function.
?p - part
Value will be inserted as is. Use this placeholder to insert already prepared part of sql query.
Make query dinamically
If your query depends on some conditions you can use prepare method to replace all placeholders in string with passed parameters.
This string may be inserted into query safely.
Exceptions
EasyDb converts all database errors to \Silverslice\EasyDb\Exception. Use getQuery method to get the query which caused an error.
Example:
Selecting rows
getOne
Peforms query and fetchs first cell from the first result row
Parameters:
- string $query - The SQL query
- mixed $param1 - Parameter for the first placeholder
- mixed $param2 - Parameter for the second placeholder
- ...
Returns:
- string|null
getAssoc
Peforms query and fetchs first result row as an associative array
Returns:
- array|null
getAll
Peforms query and fetchs all result rows as an associative array
Returns:
- array
getColumn
Peforms query and fetchs one column from the result set as an enumerate array
Returns:
- array
getPairs
Peforms query and fetchs key-value pairs from the result set.
Returns:
- array
getAllKeyed
Peforms query and fetchs key-values pairs from the result set.
Returns:
- array|bool
Modifying rows
insert
Inserts row into table
Parameters:
- string $table - Table name
- array $params - Column-value pairs
- bool $ignore - Use or not IGNORE keyword
Returns:
- mixed - Inserted row id or true if table hasn't autoincrement field
update
Updates table rows
Parameters:
- string $table - Table name
- array $params - Column-value pairs
- array $where - UPDATE WHERE clause(s). Several conditions will be concatenated with AND keyword
Returns:
- int - The number of affected rows
insertUpdate
Inserts or updates table row using INSERT... ON DUPLICATE KEY UPDATE clause
Parameters:
- string $table - Table name
- array $insert - Column-value pairs to insert
- array $update - Column-value pairs to update if key already exists in table
Returns:
- int - The number of affected rows: 1 if row was inserted or 2 if row was updated
multiInsert
Inserts multiple rows into table
Parameters:
- string $table - Table name
- array $fields - Field names
- array $data - Two-dimensional array with data to insert
- bool $ignore - Use or not IGNORE keyword
Returns:
- int - The number of affected rows
delete
Deletes table rows
Parameters:
- string $table - Table name
- array $where - UPDATE WHERE clause(s). Several conditions will be concatenated with AND keyword
Returns:
- int - The number of affected rows
Using transactions
beginTransaction
Starts a transaction
commit
Commits the current transaction
rollback
Rolls back current transaction
transaction
Runs code in transaction
Parameters:
- callable $process - Callback to process
Returns:
- bool - True if transaction was successful commited, false otherwise
Throws:
- \Silverslice\EasyDb\Exception
Example:
Advanced
Expressions
Columns in SQL queries are sometimes expressions, not simply column names from a table. You can create an object of type Expression to insert expression into sql.
Multi queries
Use multiQuery method to execute several queries which are concatenated by a semicolon, for example to load sql dump from file.
multiQuery
Executes one or multiple queries which are concatenated by a semicolon
Parameters:
- string $queries
Returns:
- bool
Throws:
- \Silverslice\EasyDb\Exception
Example:
