{"id":6833,"date":"2025-03-06T04:14:06","date_gmt":"2025-03-06T04:14:06","guid":{"rendered":"https:\/\/s-o-s.net\/product\/pdomodel-database-abstraction-and-helper-php-class\/"},"modified":"2025-04-17T18:58:16","modified_gmt":"2025-04-17T18:58:16","slug":"pdomodel-database-abstraction-and-helper-php-class","status":"publish","type":"product","link":"https:\/\/s-o-s.net\/en_gb\/product\/pdomodel-database-abstraction-and-helper-php-class\/","title":{"rendered":"PDOModel – Database abstraction and helper PHP class"},"content":{"rendered":"


\n
\nLIVE PREVIEW<\/a> LIVE ORDER $15<\/a>
\n
\n
\nPDOModel – Database abstraction and helper PHP class<\/span><\/a>
\n ddeveloper<\/a>
\n<\/p>\n

“PDOModel is a powerful database abstraction and helper PHP class that simplifies insert, update, delete, and select operations using PDO\u2014no queries required and with minimal code. It seamlessly supports MySQL, PostgreSQL, SQLite, Oracle and SQL Server databases.”. <\/h2>\n

Documentation<\/a>
\n<\/p>\n

Version 1.3 – PDOModel now supports Oracle and SQL Server along with PGSQL, SQLite and Mysql.<\/p>\n

\nPDOModel provides a complete solution to perform CRUD<\/strong> operations on three different types of databases (Mysql, Postgres and Sqlite). It provides various helper functions to export data directly to csv,excel,xml,pdf,html<\/strong> and many more useful functions.
\n<\/p>\n

Example of how to write SQL select query using PDOModel<\/h3>\n


\n$pdomodel = new PDOModel(); \/\/create object of the PDOModel class
\n$pdomodel->connect(\"localhost\", \"root\", \"\", \"pdocrud\");\/\/connect to database
\n$result = $pdomodel->select(\"emp\"); \/\/select * from `emp`
\n<\/code>
\n<\/p>\n

That’s it, you need to write just 2-3 line of code. You can write very complex queries using PDOModel functions<\/p>\n

\n
\n\"PDOModel
\n
\nPDOModel supports three type of database, Mysql, Postgres and Sqlite.
\n<\/h2>\n

\n
\n\"PDOModel
\n
\nPDOModel script allows you to export data directly in various database formats.
\n<\/h2>\n

\"PDOModel
\n<\/p>\n

Examples<\/h2>\n


\n$pdomodel = new PDOModel();\/\/create object
\n$pdomodel->connect(\"localhost\", \"root\", \"\", \"pdocrud\");\/\/connect to database - three different database type available<\/p>\n

\/* INSERT , UPDATE AND DELETE OPERATION *\/
\n$pdomodel->insert(\"emp\", array(\"firstName\" => \"John\", \"lastName\" => \"Jonathan\", \"gender\" => \"male\"));<\/p>\n

$pdomodel->where(\"orderId\", 7);
\n$pdomodel->update(\"order\", array(\"orderNumber\"=>\"44\", \"customerName\"=>\"BKG\", \"address\"=>\"140 shakti nagar\"));<\/p>\n

$pdomodel->where(\"orderId\", 7);
\n$pdomodel->delete(\"order\");<\/p>\n

\/* SELECT *\/
\n$result = $pdomodel->select(\"emp\");<\/p>\n

\/* WHERE, AND, OR, BETWEEN, GROUP BY, ORDER BY, LIKE , HAVING *\/
\n$pdomodel->where(\"orderNumber\", \"5\", \"!=\");<\/p>\n

$pdomodel->openBrackets =\"(\";
\n$pdomodel->where(\"city\", \"Indore\", \"=\");
\n$pdomodel->andOrOperator=\"OR\";
\n$pdomodel->closedBrackets =\")\";<\/p>\n

$pdomodel->groupByCols = array(\"orderId\");<\/p>\n

$pdomodel->orderByCols = array(\"orderId desc\", \"state asc\");<\/p>\n

$pdomodel->havingCondtion = array(\"sum(orderId)>2\");<\/p>\n

$pdomodel->limit = \"0,5\";<\/p>\n

$pdomodel->where(\"empId\", array(36,37), \"BETWEEN\");<\/p>\n

$pdomodel->where(\"firstName\", '%P%', \"LIKE\");<\/p>\n

$pdomodel->where(\"empId\", array(36,37,39,40), \"IN\");<\/p>\n

\/* subquery\/inner query *\/
\n$pdomodel->subQuery(\"select empId from emp where empId=?\",\"empId\",array(34));<\/p>\n

\/* where subquery *\/
\n$pdomodel->where_subquery(\"orderId\", \"select orderId from `order` where orderId=?\", \"IN\",array(10));<\/p>\n

\/*rename, trucate, drop table, column name, primary key, tablefield info*\/
\n$pdomodel->truncateTable(\"wp_postmeta\");
\n$pdomodel->renameTable(\"states\",\"state\");
\n$pdomodel->dropTable(\"empleave\");
\n$records = $pdomodel->columnNames(\"order\");
\n$records = $pdomodel->primaryKey(\"order\");
\n$records = $pdomodel->tableFieldInfo(\"order\");<\/p>\n

\/*execute sql*\/
\n$result = $pdomodel->executeQuery(\"select * from emp where empId = ?\", array(39));<\/p>\n

<\/code>
\n<\/p>\n

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

    \n<\/p>\n

    Version 2.1<\/h3>\n

    <\/p>\n

    Added-<\/p>\n