AutoCRUD
AutoCRUD是一个php下的持久层，虽然它目前只支持MySQL数据库，但是它无需配置，也很方便实用。已建立下面几个表为例
CREATE TABLE `article` (
`articleid` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`content` text,
`datetimestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`articleid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `article2category` (
`article` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`category` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`article`,`category`)
) TYPE=MyISAM;
CREATE TABLE `category` (
`categoryid` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`parent` smallint(5) UNSIGNED DEFAULT '0',
PRIMARY KEY (`categoryid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `comment` (
`commentid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(25) DEFAULT '',
`author` varchar(255) DEFAULT NULL,
`article` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`commentid`),
KEY `article` (`article`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `user` (
`userid` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL DEFAULT '',
`password` varchar(255) DEFAULT '',
PRIMARY KEY (`userid`),
UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=1;
基本操作
1 初始化
<?php
include ('autocrud/autocrud.php');
$crud = new AutoCRUD;
$result = $crud->connect ('sa', '', 'demo');
if (autocrud_is_error($result) == true) {
// error occured, find out what error
echo $result->getCode() . ': ' . $result->getMessage();
die();
}
$crud->generate(); // 该函数会自动生成一些存取数据所用的代码到数据库里面
?>
2 插入纪录
<?php
// ...
// setup AutoCRUD
// ...
$new_row = array('title' => 'My article', 'content' => 'Article content goes here', 'datetimestamp' => time());
$result = $crud->article->insert ($new_row);
if (autocrud_is_error($result) == true) {
// error occured, find out what error
echo $result->getCode() . ': ' . $result->getMessage();
die();
}
echo 'Row inserted';
?>
3 更新纪录
<?php
$row = array('title' => 'New title 2', 'content' => 'New Article content goes here', 'datetimestamp' => time());
$id = '1';
$crud->article->where = "articleid = " . $crud->quote($id);
$result = $crud->article->update ($row);
// we left out the title, so error should be returned
if (autocrud_is_error($result) == true) {
// error occured, find out what error
echo $result->getCode() . ': ' . $result->getMessage();
die();
}
echo 'Record updated';
?>
4 删除纪录
<?php
// ...
// setup AutoCRUD
// ...
$crud->article->delete(1);
echo 'Record delete';
?>
5 选择纪录
<?php
// ...
// setup AutoCRUD
// ...
// Get a list of articles
$list = $crud->article->select();
echo 'Number of records: ' . count($list) . '';
foreach ($list as $article) {
echo $article['title'] . '';
}
?>
<?php
// Specify WHERE and ORDER BY
$crud->article->where = "articleid != 6";
$crud->article->orderby = "title DESC";
// Get a list of articles
$list = $crud->article->select();
echo 'Number of records: ' . count($list) . '';
foreach ($list as $article) {
echo $article['title'] . '';
}
?>
翻页处理
<?php
// Do paging
$crud->article->paging = true; # Enable paging
$crud->article->perpage = 2; # Set number of records to show per page
$crud->article->currentpage = (empty($_GET['page'])) ? 1 : $_GET['page']; # Set current page
// Get a list of articles
$list = $crud->article->select();
echo 'Number of records: ' . count($list) . '';
foreach ($list as $article) {
echo $article['title'] . '';
}
if ($crud->article->currentpage > 1) {
echo '<a href="?page=' . ($crud->article->currentpage-1) . '">Previous Page</a> ';
}
if ($crud->article->currentpage < $crud->article->totalpages) {
echo ' <a href="?page=' . ($crud->article->currentpage+1) . '">Next Page</a>';
}
?>
<?php
// Get article #5
$article = $crud->article->get(5);
if ($article == false) {
echo 'Article doesn\'t exist';
}
echo '<pre>';
print_r ($article);
echo '</pre>';
?>
6 处理多表连接
<?php
// Setup relationship
$crud->comment->addRelationship ($crud->article, 'article', 'articleid', 'many-to-one');
// Get articles and their comments
$crud->article->join ('comment');
$articles = $crud->article->select();
echo '<pre>';
print_r ($articles);
echo '</pre>';
?>
<?php
// Setup relationship
$crud->comment->addRelationship ($crud->article, 'article', 'articleid', 'many-to-one');
// Get comments and their article
$crud->comment->join ('article');
$comments = $crud->comment->select();
echo '<pre>';
print_r ($comments);
echo '</pre>';
?>
<?php
// Setup relationship
$crud->article2category->addRelationship ($crud->category, 'category', 'categoryid', 'many-to-many');
$crud->article2category->addRelationship ($crud->article, 'article', 'articleid', 'many-to-many'); // Get articles and the categories they belong to
$crud->article->join ('category');
$articles = $crud->article->select();
echo '<pre>';
print_r ($articles);
echo '</pre>';
?>
页:
[1]