Database
  • Get started
    • Database for PHP
    • Install / configure
    • Quick reference
  • Dbi
    • Instance model
    • Instance configuration
    • Instance methods
    • Query examples
  • Dba
    • Query builder
    • Put Methods
    • Scope Methods
    • Return Methods
  • SQLI
    • Query execution
    • Request Methods
    • Query Methods
Powered by GitBook
On this page
  • Install using composer
  • Configure
  • Basic usage
  1. Get started

Install / configure

Install using composer

composer require stilmark/database

Configure

Database connection credentials should be set using in the .env file.

.env
DB_HOST=127.0.0.1
DB_DATABASE=test
DB_USERNAME=test
DB_PASSWORD=test

Basic usage

index.php
require('/vendor/autoload.php');

use Symfony\Component\Dotenv\Dotenv;
use Stilmark\Database\Dba;

$dotenv = new Dotenv();
$dotenv->load(ROOT.'/.env');

# Build sql queries or ...
$users = Dba::instance()->table('users')->list();

# Extend your models on Dbi()
$users = User::list();
PreviousDatabase for PHPNextQuick reference

Last updated 2 months ago