PDOModel – 数据库抽象和帮助程序 PHP 类

“PDOModel 是一个强大的数据库抽象和帮助程序 PHP 类，它使用 PDO 简化了插入、更新、删除和选择作，无需查询，代码最少。它无缝支持 MySQL、PostgreSQL、SQLite、Oracle 和 SQL Server 数据库。

文档

版本 1.3 – PDOModel 现在支持 Oracle 和 SQL Server 以及 PGSQL、SQLite 和 Mysql。

PDOModel 提供完整的解决方案来执行 CRUD 对三种不同类型的数据库（Mysql、Postgres 和 Sqlite）的作。它提供了各种辅助函数，可以将数据直接导出到csv、excel、xml、pdf、html 以及更多有用的功能。

如何使用 PDOModel 编写 SQL select 查询的示例

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

就是这样，你只需要写 2-3 行代码。您可以使用 PDOModel 函数编写非常复杂的查询

PDOModel 支持三种类型的数据库，Mysql、Postgres 和 Sqlite。

PDOModel 脚本允许您直接以各种数据库格式导出数据。

例子

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


/* INSERT , UPDATE AND DELETE OPERATION */

$pdomodel->insert("emp", array("firstName" => "John", "lastName" => "Jonathan", "gender" => "male"));
$pdomodel->where("orderId", 7);

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

$pdomodel->delete("order");
/* SELECT */

$result =  $pdomodel->select("emp");
/* WHERE, AND, OR, BETWEEN, GROUP BY, ORDER BY, LIKE , HAVING */

$pdomodel->where("orderNumber", "5", "!=");
$pdomodel->openBrackets ="(";

$pdomodel->where("city", "Indore", "=");

$pdomodel->andOrOperator="OR";

$pdomodel->closedBrackets =")";
$pdomodel->groupByCols = array("orderId");
$pdomodel->orderByCols = array("orderId desc", "state asc");
$pdomodel->havingCondtion = array("sum(orderId)>2");
$pdomodel->limit = "0,5";
$pdomodel->where("empId", array(36,37), "BETWEEN");
$pdomodel->where("firstName", '%P%', "LIKE");
$pdomodel->where("empId", array(36,37,39,40), "IN");
/* subquery/inner query */

$pdomodel->subQuery("select empId from emp where empId=?","empId",array(34));
/* where subquery */

$pdomodel->where_subquery("orderId", "select orderId from `order` where orderId=?", "IN",array(10));
/*rename, trucate, drop table, column name, primary key, tablefield info*/

$pdomodel->truncateTable("wp_postmeta");

$pdomodel->renameTable("states","state");

$pdomodel->dropTable("empleave");

$records = $pdomodel->columnNames("order");

$records = $pdomodel->primaryKey("order");

$records = $pdomodel->tableFieldInfo("order");
/*execute sql*/

$result =  $pdomodel->executeQuery("select * from emp where empId = ?", array(39));