zf blog 数据库

来源：互联网发布：java linux 时间戳编辑：程序博客网时间：2024/06/10 18:50

CREATE TABLE `kehuanedu_db`.`core_pages` (

`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '页面唯一id',
`cid` INT( 10 ) NOT NULL COMMENT '分类id,与core_categories表的id对应',
`uid` INT( 10 ) NOT NULL COMMENT '用户id,与core_user表的id对应',
`title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '页面标题',
`body` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
`status` TINYINT( 4 ) NOT NULL DEFAULT '1' COMMENT '是否发布',
`createtime` INT( 11 ) NOT NULL COMMENT '创建页面的时间',
`updatetime` INT( 11 ) NOT NULL COMMENT '修改页面的时间',
`comment` TINYINT( 11 ) NOT NULL COMMENT '页面是否开启评论功能:0=否,1=是',
`star` TINYINT( 11 ) NOT NULL COMMENT '页面的星级,共分五级,默认0为无星级',
`top` TINYINT( 11 ) NOT NULL COMMENT '置顶：0=否,1=是',
`type` VARCHAR( 50 ) NOT NULL COMMENT '文章类型'

) ENGINE = INNODB

application.ini

resources.db.adapter="PDO_MYSQL"
resources.db.params.host="localhost"
resources.db.params.username="root"
resources.db.params.password=""
resources.db.params.dbname="kehuanedu_db"
resources.db.params.charset="utf8"
resources.db.isDefaultTableAdapter=TRUE
resources.db.params.driver_options.1002="SET NAMES UTF8;"

layout.phtml

<?php echo $this->docType();?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link href="/skins/default/css/layout.css" rel="stylesheet" type="text" />
<link href="/skins/default/css/style.css" rel="stylesheet" type="text" />
<?php echo $this->headTitle()?>
</head>
<body>
<div id="wrap">
<?php
echo $this->partial('header.phtml');
?>
<div id="main">
<div id="sidebar"></div>
<div id="content">
<?php echo $this->layout()->content ?>
</div>
</div>
<?php echo $this->partial('footer.phtml');?>
</div>
</body>
</html>

header.phtml

<div id="header">
<div id="logo"><img src="/skins/default/images/logo.png" /></div>
</div>

footer.html

<div id="footer">
2011 All rights reserved. kehuanedu.com copyright 可幻教育集团 | 联系我们 | 合作者
</div>

zf change application.class-name-prefix Kh_

zf create model page

Bootstrap.php

class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
protected function _initView()
{
$view=new Zend_View();
$view->doctype('XHTML1_STRICT');
$view->headTitle('可幻教育');

return $view;
}

}