1
官网:http://demo.digitaldreamstech.com/PDOModel/
2
PDOModel provides complete solution to perform CRUD (Create, Read, Update, Delete) operations on Mysql, PGSql and Sqlite Database using PHP scripts.
译:
对MySQL、PGSQL和SQLite数据库执行CRUD(创建、读取、更新、删除)操作的完整解决方案,是PHP类。
主要特性(功能:
- Perform Insert, update, delete and select operations using simple functions(提供一些处理IUDS操作的函数)
- Three different types of database support (Mysql, PGSql and SQLite)(支持三种类型的数据库)
- Complex queries support with use of multiple “and” and “or”(支持复杂索引,可以用与或或)
- Multiple table join Operation using simple functions
- Table related operations like get all tables from database, truncate table, delete table, rename table etc.
- Subquery/inner query can be embedded
- Column based operation like getting all columns of table, primary key of table etc
- Export functions to export data in CSV, PDF, Excel, HTML, XML Format
- Helper functions like pagination, random password generation
- Best practices using PDO with use of prepared statements
- Support for PDO Transactions
- Support for batch operations for insert, update and delete
- Execute query directly with parameter binding
- Various debugging options lik