Three different types of database support (Mysql, PGSql and SQLite).
Export functions to export data in CSV, PDF, Excel, HTML, XML Format and many more..
Various debugging options like get last query, get rows inserted, error messages etc..
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
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
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” keywordsTry The Demo
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.