PDOModel Database abstraction and helper class for PHP

Description

PDOModel is a database abstraction and helper class for PHP that helps to do insert, update, delete, select operation of PDO without writing any queries and with much lesser code.

Below is example of how you can run select query using PDOModel, 2-3 line of code, that's it.

  
                                $/* create object of class */
                                $pdomodel = new PDOModel();

                                /* Connect to the datbase */
                                $pdomodel->connect("localhost", "pdomodel_user", "J]GgvNr9UCUT", "pdomodel");

                                /* call PDOModel function */
                                $result =  $pdomodel->select("emp");

                            

Features

  1. Perform Insert, update, delete and select operations using simple functions
  2. Three different types of database support (Mysql, PGSql and SQLite)
  3. Complex queries support with use of multiple "and" and "or"
  4. Multiple table join Operation using simple functions
  5. Table related operations like get all tables from database, truncate table, delete table, rename table etc.
  6. Subquery/inner query can be embedded
  7. Column based operation like getting all columns of table, primary key of table etc
  8. Export functions to export data in CSV, PDF, Excel, HTML, XML Format
  9. Helper functions like pagination, random password generation
  10. Best practices using PDO with use of prepared statements
  11. Support for PDO Transactions
  12. Support for batch operations for insert, update and delete
  13. Execute query directly with parameter binding
  14. Various debugging options like get last query, get rows inserted, error messages etc
  15. Support for order by, group by, like, between, in, not in, having etc
  16. Well documented and demo codes to make things easier to understand
  17. Supports method chaining