Database Access Object wrapper for PHP and PDO in a single class

PdoOne. It's a simple wrapper for PHP's PDO library compatible with SQL Server (2008 R2 or higher), MySQL (5.7 or higher) and Oracle (12.1 or higher).

This library tries to work as fast as possible. Most of the operations are simple string/array managements and work in the bare metal of the PDO library, but it also allows to create an ORM using the extension eftec/PdoOneORM.

Turn this

$stmt = $pdo->prepare("SELECT * FROM myTable WHERE name = ?");
$stmt->bindParam(1,$_POST['name'],PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->get_result();
$products=[];
while($row = $result->fetch_assoc()) {
  $product[]=$row; 
}
$stmt->close();

into this

$products=$pdoOne
    ->select("*")
    ->from("myTable")
    ->where("name = ?",[$_POST['name']]) 
    ->toList();

or using the ORM (using eftec/PdoOneORM library)

ProductRepo // this class was generated with echo $pdoOne()->generateCodeClass(['Product']); or using the cli.
    ::where("name = ?",[$_POST['name']])
    ::toList();

Table of contents

<!-- TOC -->

• Database Access Object wrapper for PHP and PDO in a single class
• Table of contents
  • Examples
  • Installation
    • Install (using composer)
    • Install (manually)
  • How to create a Connection?
    • OCI
  • How to run a SQL command?
    • 1. Running a raw query
    • 2. Running a native PDO statement
    • 3. Running using the query builder
    • 4. Running using an ORM
    • 5. Run a query with a different mode
  • How to work with Date values?
  • How to run a transaction?
  • Custom Queries
    • tableExist($tableName)
    • statValue($tableName,$columnName)
    • columnTable($tablename)
    • foreignKeyTable($tableName)
    • createTable($tableName,$definition,$primaryKey=null,$extra='',$extraOutside='')
    • tableSorted($maxLoop = 5, $returnProblems = false, $debugTrace = false)
    • validateDefTable($pdoInstance,$tablename,$defTable,$defTableKey)
    • foreignKeyTable
  • Query Builder (DQL)
    • select($columns)
    • count($sql,$arg='*')
    • min($sql,$arg='*')
    • max($sql,$arg='*')
    • sum($sql,$arg='*')
    • avg($sql,$arg='*')
    • distinct($distinct='distinct')
    • from($tables)
    • where($where,[$arrayParameters=array()])
      • Where() without parameters.
      • Where() with parameters defined by an indexed array.
      • Where() using an associative array
      • Where() using an associative array and named arguments
      • Examples of where()
    • order($order)
    • group($group)
    • having($having,[$arrayParameters])
    • End of the chain
      • runGen($returnArray=true)
      • toList($pdoMode)
• toPdoStatement($pdoMode)
• fetchLoop($callable,$pdoMode) * toMeta() * toListSimple() * toListKeyValue() * toResult() * firstScalar($colName=null) * first() * last() * sqlGen()
  • Query Builder (DML)
    • insert($table,$schema,[$values])
    • insertObject($table,[$declarativeArray],$excludeColumn=[])
    • update($$table,$schema,$values,[$schemaWhere],[$valuesWhere])
    • delete([$table],[$schemaWhere],[$valuesWhere])
  • Cache
    • How to configure it?
    • Example using apcu
  • Sequence
    • Creating a sequence
    • Creating a sequence without a table.
    • Using the sequence
  • Fields
  • Encryption
  • How to debug and trace errors in the database?
    • Setting the log level
    • Throwing errors
    • Getting the last Query
    • Generating a log file
  • CLI
    • Run as cli
    • Run as CLI interative
      • Examples
    • Run CLI to generate repository classes.
    • cli-classcode
    • cli-selectcode
    • cli-arraycode
    • cli-json
    • cli-csv
    • UI
    • How to run the UI?
    • DDL Database Design Language
    • Nested Operators
    • DQL Database Query Language
    • DML Database Model Language
    • Validate the model
    • Recursive
      • recursive()
      • getRecursive()
      • hasRecursive()
  • Benchmark (mysql, estimated)
  • migration from 3 to 4
  • Error FAQs
    • Uncaught Error: Undefined constant eftec_BasePdoOneRepo::COMPILEDVERSION
  • Changelist

<!-- TOC -->

Examples

| ExampleTicketPHP | Example cupcakes | Example Search | Example Different Method | |------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------| | <img src="https://camo.githubusercontent.com/3c938f71f46a90eb85bb104f0f396fcba62b8f4a/68747470733a2f2f74686570726163746963616c6465762e73332e616d617a6f6e6177732e636f6d2f692f3436696b7061376661717677726533797537706a2e6a7067" alt="example php bladeone" width="200"/> | <img src="https://github.com/EFTEC/example.cupcakes/raw/master/docs/result.jpg" alt="example php bladeone cupcakes" width="200"/> | <img src="https://github.com/EFTEC/example-search/raw/master/img/search_bootstrap.jpg" alt="example php bladeone search" width="200"/> | <img src='https://github.com/escuelainformatica/example-pdoone/raw/master/docs/database.jpg' width=200 /> |

More examples:

Example Mysql PHP and PDO using PDOOne

Installation

This library requires PHP 7.1 and higher, and it requires the extension PDO and the extension PDO-MYSQL (Mysql), PDO-SQLSRV (sql server) or PDO-OCI (Oracle)

Install (using composer)

Edit composer.json the next requirement, then update composer.

  {
      "require": {
        "eftec/PdoOne": "^4.0.1"
      }
  }

or install it via cli using

composer require eftec/PdoOne

Install (manually)

Just download the folder lib from the library and put in your folder project.