PDOModel

Provides Complete Solution to Perform
CRUD Operations with Mysql, PGSql and Sqlite

Documentation Buy Now

PDOModel

PDOModel provides complete solution to perform CRUD (Create, Read, Update, Delete) operations on Mysql, PGSql and Sqlite Database using PHP scripts.

Support

Three different types of database support (Mysql, PGSql and SQLite).

Export

Export functions to export data in CSV, PDF, Excel, HTML, XML Format and many more..

Settings

Various debugging options like get last query, get rows inserted, error messages etc..

Database Operation

PDOModel is a PHP database abstraction and helper file for performing various database related operations like insert, delete, update, select without writing any sql queries. You can perform complex database related operations without writing any queries at all.

Documentation

Helper Functions

PDOModel provides various functions to perform database related operations in convenient manner and it allow reduce code lines, redundancy, readability of code, security and performance of your application.

PDOModels can be easily intergrated with your application and you can save lots of development time.

Documentation

Features

1. Insert Operation.

2. Update Operation.

3. Delete Operation.

4. Select Operation.

5. Multiple table join operation.

6. Table related operations like get all tables from database, truncate table, delete table, rename table etc.

7. Sub query.

8. Column based operation like getting all columns of table, primary key of table etc.

9. Export functions to export data in CSV, PDF, Excel, HTML, XML Format.

10. Helper functions like pagination, random password generation.

11. Database backup script

12. Support for PDO Transctions

13. Three different types of database support (Mysql, PGSql and SQLite)

14. Support for batch operations for insert, update and delete.

15. Execute query directly.

16. Various debugging options like get last query, get rows inserted, error messages etc.

17. Support for order by, group by, like, between, in, not in, having etc

18. Well documented and demo codes to make things easier to understand

19. Perform complex queries with multiple use of “And” and “OR” keywords

Try The Demo

F.A.Q.

PDOModel script provides various functions by which you don't need to write any queries to perform database operations.

Currently, it supports Mysql, PGSql and Sqlite database. In future, there will be support for Oracle, MSSQL etc. It depends on how extension of these database turns out.

Yes, as long as you have used proper naming for the Mysql database, you don't need it at all. Setting backtics off also helps in increasing speed as it doesn't need to parse columns. PGSql doesn't support backticks.

In sqlite, you need to pass only database file path, Please make sure you provide complete path of the file and it will work surely. Also, make sure extension for sqlite is enabled in php.ini file

Please make sure the data passed is 2-D array and it the folders permissions are correct (it will need write access). It will work surely.