Package Data | |
---|---|
Maintainer Username: | dayatfadila |
Maintainer Contact: | dayat.recovery@gmail.com (Dayat Fadila) |
Package Create Date: | 2017-02-23 |
Package Last Update: | 2017-03-29 |
Language: | PHP |
License: | MIT |
Last Refreshed: | 2025-02-12 15:03:33 |
Package Statistics | |
---|---|
Total Downloads: | 30 |
Monthly Downloads: | 0 |
Daily Downloads: | 0 |
Total Stars: | 0 |
Total Watchers: | 2 |
Total Forks: | 0 |
Total Open Issues: | 0 |
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.
composer require dayatfadila7/firebirdclassic
.....
"dayatfadila7/firebirdclassic": "^1.0"
......
},
Next, add your new provider to the providers array of config/app.php:
```'providers' => [
// ...
FireBirdClassic\FirebirdClassicServiceProvider::class,
// ...
],
### How to use it
first you must add IbaseQuery namespace
use FireBirdClassic\Query\IbaseQuery;
than create constructor :
public function __construct()
{
$this->command = new IbaseQuery;
}
#### feature ibase query
##### a. execute for excute query
$this->command->execute($query);
example:
$query = "SELECT * FROM USER";
$this->command->execute($query);
##### b. create
$this->command->create($table,$data);
example :
$data = ['USERNAME'=>'Sarah',['PASSWORD']=>'yourname'];
$this->command->create('USER',$data);
##### b. update
$this->command->update($>table, $data, $condition)
example :
$data = ['USERNAME'=>'Sarah',['PASSWORD']=>'yourname'];
$condition = ['ID'=>1];
$this->command->update('USER',$data);
##### c. delete
$this->command->delete($table, $condition);
example:
$condition = ['ID'=>1];
$this->command->update('USER',$condition);
##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);