notorm 是一个 php 库,用来简化和数据库的交互。最有特色的功能是处理表关联关系非常简单。另外 notorm 的性能非常的高,设置高过内置的驱动。
连接数据库
include "NotORM.php";
$pdo = new PDO("mysql:dbname=software");
$db = new NotORM($pdo);
ECTouch是上海商创网络科技有限公司推出的一套基于 PHP 和 MySQL 数据库构建的开源且易于使用的移动商城网店系统!应用于各种服务器平台的高效、快速和易于管理的网店解决方案,采用稳定的MVC框架开发,完美对接ecshop系统与模板堂众多模板,为中小企业提供最佳的移动电商解决方案。ECTouch程序源代码完全无加密。安装时只需将已集成的文件夹放进指定位置,通过浏览器访问一键安装,无需对已有
读取数据
foreach ($db->application() as $application) { // get all applications
echo "$application[title]\n"; // print application title
}
立即学习“PHP免费学习笔记(深入)”;
条件查询
$applications = $db->application()
->select("id, title")
->where("web LIKE ?", "http://%")
->order("title")
->limit(10)
;
foreach ($applications as $id => $application) {
echo "$application[title]\n";
}
读取结果
$application = $db->application[1]; // get by primary key
$application = $db->application("title = ?", "Adminer")->fetch();
立即学习“PHP免费学习笔记(深入)”;
处理表关联
echo $application->author["name"] . "\n"; // get name of the application author
foreach ($application->application_tag() as $application_tag) { // get all tags of $application
echo $application_tag->tag["name"] . "\n"; // print the tag name
}
立即学习“PHP免费学习笔记(深入)”;
JOIN联合查询
// get all applications ordered by author's name
foreach ($db->application()->order("author.name") as $application) {
echo $application->author["name"] . ": $application[title]\n";
}
立即学习“PHP免费学习笔记(深入)”;
结果集分组
echo $db->application()->max("id"); // get maximum ID
foreach ($db->application() as $application) {
// get count of each application's tags
echo $application->application_tag()->count("*") . "\n";
}
立即学习“PHP免费学习笔记(深入)”;
完整例子
application()->order("title") as $application) { // get all applications ordered by title
echo "$application[title]\n"; // print application title
echo $application->author["name"] . "\n"; // print name of the application author
foreach ($application->application_tag() as $application_tag) { // get all tags of $application
echo $application_tag->tag["name"] . "\n"; // print the tag name
}
}
?>










