• 18 Jul, 2023
  • Release: v1.7 Latest

DBController

DBController is a PHP PDO wrapper that provides a convenient way to interact with a database using the PDO extension. It has all you need to execute database connection and query database..

DBController is a PHP PDO wrapper that provides a convenient way to interact with a database using the PDO extension.

Installation

You can install the package via Composer by running the following command:

composer require peterujah/db-controller

USAGES

To use DBController, follow these easy steps.

  1. Create an instance of the DBController class by passing the database configuration as an array or a path to a configuration file that returns array.
use Peterujah\NanoBlock\DBController;
// Pass the configuration as an array
$config = [
    'VERSION' => 'mysql',
    'HOST' => 'localhost',
    'PORT' => 3306,
    'NAME' => 'my_database',
    'USERNAME' => 'root',
    'PASSWORD' => 'password',
];

$handler = new DBController($config);

Or extend \Peterujah\NanoBlock\DBController to set your connection details like below

class Conn extends \Peterujah\NanoBlock\DBController{ 
    public function __construct(bool $development = false){
        $config = array(
            "PORT" => 3306,
            "HOST" => "localhost",
            "VERSION" => "mysql",
        );
        if($development){
            $config["USERNAME"] = "root";
            $config["PASSWORD"] = "";
            $config["NAME"] = "dbname";
        }else{
            $config["USERNAME"] = "dbusername";
            $config["PASSWORD"] = "dbpass";
            $config["NAME"] = "dbname";
        } 
        $this->onDebug = $development;
        parent::__construct($config);
    }
}

Initialize your custom class

$handler = new Conn($_SERVER["HOST_NAME"]=="localhost");

Now run query select, insert, update, delete etc.. using prepare statment

$handler->prepare('SELECT * FROM users WHERE username = :username LIMIT 1');
$handler->bind(':username', "Peter");
$handler->execute();
$res = $handler->getOne();
$handler->free();

Or run query select, insert, update, delete etc.. using query

$handler->query('SELECT * FROM users');
$res = $handler->getAll();
$handler->free();

Customization

Customize the configuration or enable debugging as needed.

// Set a configuration value
$handler->setConfig('VERSION', 'pgsql');

// Enable debugging mode
$handler->setDebug(true);

Error Handling

DBController provides error handling for database operations. You can retrieve the error information using the error() or errorInfo() methods.

// Get the error information for the last statement execution
$errorInfo = $handler->error();

// Print the error message
if ($errorInfo !== null) {
    echo "Error: " . $errorInfo[2];
}

Debugging

You can enable debugging mode to get more detailed information about the executed statements by calling the dumpDebug() method.

// Enable debugging mode
$handler->setDebug(true);

// Dump the debug information for the last statement execution
$handler->dumpDebug();

Methods

Use the various methods provided by the DBController class to interact with the database.

// Prepare a statement
$query = 'SELECT * FROM users WHERE id = :id';
$handler->prepare($query);

// Bind values to parameters
$handler->bind(':id', 1);

//Binds a variable to a parameter.
$handler->param(':id', 1, DBController::_INT)

// Execute the statement
$handler->execute();

// Fetch a single row as an object
$user = $handler->getOne();

// Fetch all rows as an array of objects
$users = $handler->getAll();

// Get the number of rows affected by the last statement execution
$rowCount = $handler->rowCount();

// Get the last inserted ID
$lastInsertId = $handler->getLastInsertId();

// Free up the statement cursor
$handler->free();
OptionsDescription
prepare(string)Call "prepare" with sql query string to prepare query execution
query(string)Call "query" width sql query without "bind" and "param"
bind(param, value, type)Call "bind" to bind value to the pdo prepare method
param(param, value, type)Call "param" to bind parameter to the pdo statment
execute()Execute prepare statment
rowCount()Get result row count
getOne()Get one resault row, this is useful when you set LIMIT 1
getAll()Retrieve all result
getInt()Gets integer useful when you select COUNT()
getAllObject()Gets result object
getLastInsertedId()Gets list inserted id from table
free()Free database connection
dumpDebug()Dump debug sql query parameter
errorInfo()Print PDO prepare statment error when debug is enabled
error()Print connection or execution error when debug is enabled
setDebug(bool)Sets debug status
setConfig(array)Sets connection config array
conn()Retrieve DBController Instance useful when you call "setConfig(config)"

Configuration format

Connection config array example

[
     PORT => 3306,
     HOST => "localhost",
     VERSION => "mysql",
     NAME => "dbname",
     USERNAME => "root",
     PASSWORD => ""
]

Contributing

Contributions are welcome! If you encounter any issues or have suggestions for improvements, please open an issue or submit a pull request.

License

DBController is open-source software licensed under the MIT license.
Coming together is a beginning. Keeping together is progress. Working together is success.

Let's create the next big thing together!

Contact Us
  • Find us

    Abakpa Nike, Enugu 400103

  • Email us

    info@nanoblocktech.com

    enquiry@nanoblocktech.com

  • Phone support

    +2347044293304