iassasin / fidb

v0.3.0 2025-02-06 15:37 UTC

Requires

• php: >=7.1

Requires (Dev)

• php-coveralls/php-coveralls: ^2
• phpunit/phpunit: ^9

MIT

• iassasin

• database
• db
• database interface

Published on Packagist.org on 2025-02-06 15:44 UTC

README

Very simple and lightweight database connection wrapper making easer and safer to construct queries.

Install

Use composer to install fidb:

composer require iassasin/fidb

Usage

require_once 'vendor/autoload.php';

use Iassasin\Fidb\Connection\ConnectionMysql;

$db = new ConnectionMysql($host, $database, $user, $password);

$db->query('INSERT INTO table(num, str, txt) VALUES(%d, %s, %s)',
	123, 'string', 'and "text"'); // automatic string escaping

// build queries of any complexity with variables
$bs = $db->select()
	->column('str')
	->table('table')
	->where('num > %d', 30);

foreach ($bs->execute()->fetchAll() as $row){
	echo $row['str'];
}

More examples see in example