dayatfadila7/firebirdclassic

firebird using ibase laravel >= 5.1

Firebird Classic

This is a package for firebird laravel >=5.1 using ibase function and that not using pdo because numeric in pdo firebird return random number., _(*1)

feature

• excute query
• insert
• update
• delete

Installation

composer require dayatfadila7/firebirdclassic, _(*2)

or add manual in composer.json

```"require": { ..... "dayatfadila7/firebirdclassic": "^1.0" ...... },, <sub>(*3)</sub>

Next, add your new provider to the providers array of config/app.php: ```'providers' => [ // ... FireBirdClassic\FirebirdClassicServiceProvider::class, // ... ],, <sub>(*4)</sub>

### How to use it, <sub>(*5)</sub>

first you must add IbaseQuery namespace use FireBirdClassic\Query\IbaseQuery; than create constructor :, <sub>(*6)</sub>

public function __construct() { $this->command = new IbaseQuery; }, <sub>(*7)</sub>

feature ibase query

a. execute for excute query

$this->command->execute($query);, <sub>(*8)</sub>

example: $query = "SELECT * FROM USER"; $this->command->execute($query);, <sub>(*9)</sub>

b. create

$this->command->create($table,$data); example : $data = ['USERNAME'=>'Sarah',['PASSWORD']=>'yourname']; $this->command->create('USER',$data);, <sub>(*10)</sub>

b. update

$this->command->update($>table, $data, $condition) example : $data = ['USERNAME'=>'Sarah',['PASSWORD']=>'yourname']; $condition = ['ID'=>1]; $this->command->update('USER',$data);, <sub>(*11)</sub>

c. delete

$this->command->delete($table, $condition); example: $condition = ['ID'=>1]; $this->command->update('USER',$condition);, <sub>(*12)</sub>

note :

$data and $codition is array. for execute sql create,update and delete you must run function execute. example : $command = $this->command->create('USER',$data); $this->command->execute($command);, <sub>(*13)</sub>