Download the PHP package mk/database-connection-handler without Composer
On this page you can find all versions of the php package mk/database-connection-handler. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download mk/database-connection-handler
More information about mk/database-connection-handler
Files in mk/database-connection-handler
Package database-connection-handler
Short Description PDO wrapper for using MySQL databases with less configuration and more ease
License MIT
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 database-connection-handler
DatabaseConnectionHandler
DatabaseConnectionHandler is a simple PDO wrapper. The DatabaseConnectionHandler allows easy access to a MySQL database through PDO. It includes a singleton pattern which can be used to open up only one database connection throughout the whole project, so that your application not run into handling to many connections to your database. It also has a certain use pattern which is described below.
Requirements
- PHP version 5.3.1 or higher
- MySQL database to connect to (for now)
Installation
Composer
composer require mk/database-connection-handler
Manually
- Just copy the included files into a folder in your project and include the
DatabaseConnectionHandler.phpwherever you want in your php files to use it. - To give the connection credentials for your own database please edit the file
DataBaseConnection.phpand fill out the placeholders with your own mysql server informations.
Roadmap / Specifications
- [x] Uses namespaces
- [x] PHP 7+ compatible
- [x] Error handling with exceptions
- [x] Use of
?and:paramsyntax for prepared statements - [ ] Feel free to raise an issue or more features
Usage
Namespace
Use \MK\DB as namespace.
Open up connection / create an instance
After including DatabaseConnectionHandler.php into a php file you need the get the current instance over the static function getInstance(). After that you are ready to query your database.
Query the database
After creating an instance of the DatabaseConnectionHandler you can use the query() method to either fetch results or just query inserts or anything else.
The query() method has two parameters:
- \$query is the SQL query string.
- \$arguments is an array with certain arguments for the query string. This argument could also be left empty.
A query with parameters is build up like any query in PDO you use "?" to signal the DatabaseConnectionHandler that there is a matching argument for the placeholder in the \$arguments array. So i.e.:
This prepared statement behaviour also work as in pure PDO with named placeholders:
Get results from your query
To get results for your query every query() method call returns a DatabaseResult object. This object holds all the queried data and also the selected rows of the query and the last insert id, if it's meaningful.
The DatabaseResult has the following methods:
getSelectedRows(): Returns the found rows for a query if meaningful.nextRow(): Returns the next row of a query if meaningful. This row is an associated array with the queried columns as keys.fetchAll(): Instead of returning only the next row of the query this method returns all rows which are left packed in an array.getLastInsertID(): Returns the last insert id if meaningful.
Here is a simple example of how to use the DatabaseResult object:
