phpyii框架学习笔记一：入门体验，初次要了解的那些事.

 　创建几张表格~  简单说明一下，　　tbl_post blog 表 tbl_comment 评论表　，　tbl_user 用户表 tbl_tag 标签表　　直接运行下面的sql 即可.

CREATE DATABASE /*!32312 IF NOT EXISTS*/`yii` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `yii`;

DROP TABLE IF EXISTS `tbl_comment`;

CREATE TABLE `tbl_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text,
  `status` tinyint(1) DEFAULT &＃39;0&＃39;,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `author` int(10) DEFAULT NULL,
  `email` char(255) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_lookup`;

CREATE TABLE `tbl_lookup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(20) DEFAULT NULL,
  `code` char(20) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_post`;

CREATE TABLE `tbl_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` char(20) DEFAULT NULL,
  `content` text,
  `tags` char(255) DEFAULT NULL,
  `status` tinyint(2) DEFAULT &＃39;0&＃39;,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `tbl_post` */

insert  into `tbl_post`(`id`,`title`,`content`,`tags`,`status`,`create_time`,`update_time`,`author_id`) values (1,&＃39;111&＃39;,&＃39;222222&＃39;,&＃39;3333&＃39;,1,&＃39;2012-08-08 00:00:00&＃39;,&＃39;2012-08-08 00:00:00&＃39;,2);

/*Table structure for table `tbl_tag` */

DROP TABLE IF EXISTS `tbl_tag`;

CREATE TABLE `tbl_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(20) DEFAULT NULL,
  `frequency` int(11) DEFAULT &＃39;1&＃39;,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_user`;

CREATE TABLE `tbl_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` char(20) DEFAULT NULL,
  `password` char(32) DEFAULT NULL,
  `email` char(100) DEFAULT NULL,
  `sex` int(11) DEFAULT &＃39;0&＃39;,
  `profile` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

insert  into `tbl_user`(`id`,`username`,`password`,`email`,`sex`,`profile`) values (1,&＃39;admin&＃39;,&＃39;e10adc3949ba59abbe56e057f20f883e&＃39;,NULL,0,NULL),(2,&＃39;demo&＃39;,&＃39;e10adc3949ba59abbe56e057f20f883e&＃39;,NULL,0,NULL);

2 修改yii 的配置文件. protected/config/main.php  

//约第五十行。
//  &＃39;db&＃39;=>array(
//   &＃39;connectionString&＃39; => &＃39;sqlite:&＃39;.dirname(__FILE__).&＃39;/../data/testdrive.db&＃39;,
//  ),
  // uncomment the following to use a MySQL database

  &＃39;db&＃39;=>array(
   &＃39;connectionString&＃39; => &＃39;mysql:host=192.168.1.33;dbname=yii&＃39;,
   &＃39;emulatePrepare&＃39; => true,
   &＃39;username&＃39; => &＃39;root&＃39;,
   &＃39;password&＃39; => &＃39;admin&＃39;,
   &＃39;charset&＃39; => &＃39;utf8&＃39;,  &＃39;prefix&＃39; => &＃39;tbl&＃39;
            &＃39;tablePrefix&＃39;=>&＃39;tbl_&＃39;
  ),
//约第21行，打开gii~
&＃39;modules&＃39;=>array(
  // uncomment the following to enable the Gii tool

  &＃39;gii&＃39;=>array(
   &＃39;class&＃39;=>&＃39;system.gii.GiiModule&＃39;,
   &＃39;password&＃39;=>&＃39;123456&＃39;,
   // If removed, Gii defaults to localhost only. Edit carefully to taste.
     &＃39;ipFilters&＃39;=>array(&＃39;127.0.0.1&＃39;,&＃39;192.168.1.7&＃39;),
  ),

 ),

         $user = User::model()->findByAttributes(array(&＃39;username&＃39; => $this->username));
        if ($user === null) {
                $this->errorCode = self::ERROR_USERNAME_INVALID;
        } else if ($user->password !== md5(trim($this->password))) {
                $this->errorCode = self::ERROR_PASSWORD_INVALID;
        } else {
                $this->setState(&＃39;id&＃39;, $user->id);
                $this->setState(&＃39;username&＃39;, $user->username);
                $this->errorCode = self::ERROR_NONE;
        }
        return !$this->errorCode;