2017 © Pedro Peláez
 

library hx-db

Database abstraction class

image

guinso/hx-db

Database abstraction class

  • Saturday, July 2, 2016
  • by guinso
  • Repository
  • 1 Watchers
  • 0 Stars
  • 15 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 7 Versions
  • 0 % Grown

The README.md

hx-db

RDBMS utility tool, (*1)

Install Package

Composer

//PHP 7
{
  "require": {
    "guinso/hx-db": "2.0.*"
  }
}

//PHP 5
{
  "require": {
    "guinso/hx-db": "1.0.*"
  }
}

Manual

require_once("hx-db-directory/src/autoload.php");

Example

Basic PDO operation

$pdo = new \PDO(...); //put standard parameter for PDO
$db = new \Hx\Db\SimpleDb($pdo);

//execute SQL
$sql = "SELECT * FROM account WHERE name = :name";
$pdoStatement = $db->runSql(
  $sql,
  array(":name" => "john")
);
foreach($row in $pdoStatement)
  //process each row data...

//execute SQl from file
$result = $db->runSqlFile("sql-script-file-path"); //only return number of affect row (Int)

//transaction
$db->BeginTransaction();
$db->CommitTransaction();
$db->RollBackTransaction(); //rollback

SQL script Generator

Currently only support simple SELECT, INSERT, and UPDATE SQL, (*2)

$pdo = new \PDO(...);
$sqlService = new \Hx\Db\SqlService(new \Hx\Db\SimpleDb($pdo));

//Select SQL
$sqlSelect = $sqlService->createSelectSql();
$sqlSelect->table("datatable-name a")
  ->column("a.name")
  ->column("a.address AS addr")
  ->where("a.age > :age")
  ->order("a.name DESC")
  ->group("a.nationality")
  ->join("INNER JOIN", "invoice b", "a.name = b.name")
  ->paginate(0, 10);

//to get sql script
$sqlScript = $sqlSelect->generateSql();

//to direct execute
$sqlStatement = $sqlSelect->execute(array(":age" => 18));

The Versions

02/07 2016

dev-master

9999999-dev

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database

04/06 2016

2.0.0

2.0.0.0

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database

30/12 2015

1.0.5

1.0.5.0

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database

30/12 2015

1.0.4

1.0.4.0

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database

30/12 2015

1.0.3

1.0.3.0

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database

30/12 2015

1.0.2

1.0.2.0

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database

27/12 2015

1.0.0

1.0.0.0

Database abstraction class

  Sources   Download

MIT

The Requires

  • php >=5.6

 

database