NotORM (PHP's ORM framework) sample code_PHP tutorial

In the Agni Download section, we released NotORM, a completely free PHP library used to simplify interaction with databases. The most distinctive feature is that it is very simple to handle table relationships. In addition, the performance of NotORM is very high, and the settings are higher than the built-in driver.

Let’s take a look at some NotORM sample code:

Connect to database:

Copy to ClipboardQuoted content: [www.bkjia.com] include "NotORM.php";
$pdo = new PDO("mysql:dbname=software");
$db = new NotORM($pdo);

Read data:

Copy to ClipboardQuoted content: [www.bkjia.com] foreach ($db->application() as $application) { // get all applications
echo "$application[title]n"; // print application title
}

Conditional query:

Copy to ClipboardQuoted content: [www.bkjia.com] $applications = $db->application()
->select("id, title")
->where("web LIKE ?", "http://%")
->order("title")
->limit(10)
;
foreach ($applications as $id => $application) {
echo "$application[title] n";
}

Read result:

Copy to ClipboardQuoted content: [www.bkjia.com] $application = $db->application[1]; // get by primary key
$application = $db->application("title = ?", "Adminer")->fetch();

Handling table associations:

Copy to ClipboardQuoted content: [www.bkjia.com] 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
}

JOIN joint query:

Copy to ClipboardQuoted content: [www.bkjia.com] // get all applications ordered by author's name
foreach ($db->application()->order("author.name") as $application) {
echo $application->author[" name"] . ": $application[title]n";
}

Result set grouping:

Copy to Clipboard引用的内容：[www.bkjia.com] 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";
}

完整实例：

Copy to Clipboard引用的内容：[www.bkjia.com] include "NotORM.php";
$connection = new PDO("mysql:dbname=software");
$software = new NotORM($connection);

foreach ($software->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
}
}
?>

http://www.bkjia.com/PHPjc/363954.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/363954.htmlTechArticle在烈火下载栏目，我们发布了NotORM，这是一个完全免费的 PHP 库，用来简化和数据库的交互。最有特色的功能是处理表关联关系非常简单。...