phptricks/database_class

A database class which uses the PDO extension, Supports many drivers

5.0.0 2020-10-03 22:44 UTC

Requires

• ext-json: *
• ext-pdo: *
• symfony/console: ^5.1

MIT

• mohammad walid anzawi

README

A database class which uses the PDO extension.

• Allows one connection with the database and deny duplicate connection,
• this speeds up to use the database and reduces the load on the server.
• supports many drivers (mysql, sqlite, PostgreSQL, mssql, sybase, Oracle Call Interface -oci-)

If you have any issue please open issue to fix it.

any suggestions would you like added or modified write to us at <[e-mail]>

install via composer

composer require phptricks/database_class

{
    "require": {
        "phptricks/database_class": "^5.0"
    }
}

Create First Migration :

php phptricks migrate:make UsersTable create -table=users

Migrate Tables :

php phptricks migrate

Create First Model :

php phptricks model UserModel --table=users

results :

use PHPtricks\Orm\Model;
class UserModel extends Model
{
    protected $_table = 'users';
}

Select All Data :

$user = new UserModel();
$allUsers = $user->select();

Insert Data :

$user = new UsersModel();
$user->insert([
    'username' => 'al-anzawi',
    'email' => '[e-mail]'
]);

Full Documentation :

PHPtricks-ORM Full Documentation

Change Log :

5.0.0

• ADD : Modeling System
• ADD : Migrations
• ADD : Commands-line
• ADD : Joins [Models Relation]
• ADD : groupBy() method
• ADD : toJsonFormatted() method
• ADD : drop() method - to delete tables
• MODIFY : Database Class
• MODIFY : toArray() Method

please note: version 5.0.0 ** not ** compatible with old versions. if you using PHPtricks-ORM v4.x.x or older in your project and you want to upgrade to v5.0.0, you need to change a lot of things to meet new version.

4.1.0

• ADD : parseWhere(array $cons, $type = "AND") method
• ADD : lastInsertedId() method
• ADD : createOrUpdate($values, $conditionColumn = []) method
• ADD : findBy($column, $value) method
• REMOVE: empty() method

4.0.0

• MODIFY : namespace to PHPtricks\Orm
• MODIFY : files structure

3.1.0

• FIX : Duplicate connection
• ADD : Some methods
  • each() -> to each all collection values
  • map() -> to map all results
  • all() -> to get all results
  • last() -> to get last selected record
  • filter() -> to filter values
  • keys() -> to get collection keys
  • toJson() -> to convert results to json format
• ADD : convert results to json format when use collection as string automatically

3.0.0

• ADD : direct update functionality
• FIX : dataView method with first method
• MODIFY : methods chaining technique
  • select, first, find, paginate NOW return Database Object
  • but you can use results as array or object
  • any time you can add ->results() to convert to array or object

2.1.0

• Add : pagination functionality
• Add : count method
• Add : dataView method (to display 'selected results' in a table)
• FIX : in() method
• FIX : notIn() method

2.0.0

• ADD : supports multi drivers
  • mysql
  • PostgreSQL
  • sqlite
  • msSql
  • sybase
  • Oracle Call Interface (OCI)
• ADD : multi where
• ADD : type of where
• ADD : show query
• FIX : default constraint
• ADD : limit function
• ADD : offset function
• rebuilt 80% of methods
• change License terms

1.1.0

• ADD Some Data Definition Language (DDL) functions.
  • ADD Create New Table
  • ADD Drop Table
  • ADD Alter Table
    • ADD new Column
    • Change Column Name
    • Drop Column
    • Rename Column

1.0.1

• FIX: first() method to compatible with PHP V +5.3.0

1.0.0

• First Release