news 表的结构为
news(
news_id, // 新闻ID
title, // 新闻标题
content, // 新闻内容
created_at, // 创建时间
updated_at, // 更新时间
is_active // 是否显示
)
1.添加模块文件和配置文件
2.添加前端路由
3 添加Model
<global>
<models>
<news>
<class>Www_News_Model</class>
<resourceModel>news_mysql4</resourceModel>
</news>
<news_mysql4>
<class>Www_News_Model_Resource</class>
<entities>
<news>
<table>news</table>
</news>
</entities>
</news_mysql4>
</models>
<resources>
<news_read>
<connection>
<use>default_read</use>
</connection>
</news_read>
<news_write>
<connection>
<use>default_write</use>
</connection>
</news_write>
</resources>
</global>
4.配置安装脚本
<news_setup>
<setup>
<module>Www_News</module>
<class>Www_News_Model_Resource_Setup</class>
</setup>
<connection>
<use>core_setup</use>
</connection>
</news_setup>
<?php
$installer = $this;
$installer->startSetup();
$installer->run("
-- DROP TABLE IF EXISTS {$this->getTable('news/news')};
CREATE TABLE {$this->getTable('news/news')} (
`news_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`content` text NOT NULL DEFAULT '',
`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");
$installer->endSetup();
5 添加样例数据
INSERT INTO `news` (`title`, `content`, `created_at`, `updated_at`, `is_active`) VALUES ('title1', 'content1', '2011-11-29 08:00:00', '2011-11-29 08:00:00', 1);
INSERT INTO `news` (`title`, `content`, `created_at`, `updated_at`, `is_active`) VALUES ('title2', 'content2', '2011-11-29 08:10:00', '2011-11-29 08:10:00', 1);
6.添加Helper和Block
<blocks>
<news>
<class>Www_News_Block</class>
</news>
</blocks>
<helpers>
<news>
<class>Www_News_Helper</class>
</news>
</helpers>
7.记得添加 resource model and collection