再次用CodeIgniter实现简易blog

　　天变冷了，人也变得懒了不少，由于工作的需要，最近一直在学习CodeIgniter（CI）框架的使用，没有系统的从PHP基本语法学起，在网上靠百度谷歌，东拼西凑的实现了一些简单的功能。所以，老PHPer可以绕道了。

PHP实现简易blog

　　参考该篇博客所实现的功能，重新用CI实现了一下。

　　主要实现文章的添加、查看、删除、搜索。这里面最难实现的是文章分页，看似简单的功能，却费了一些功夫。

再次用CodeIgniter实现简易blog-LMLPHP

当然，离一个完整的系统还有很多功能没开发，这里只是简单引用了bootstrap的样式。

MVC模型

CI遵循于MVC模型，如果接触过其它基于MVC模型的web框架的话，理解起来还是比较简单的。

再次用CodeIgniter实现简易blog-LMLPHP

web的开发主要就是在这三个目录下进行。

控制器（controllers目录）是模型、视图以及其他任何处理 HTTP 请求所必须的资源之间的中介，并生成网页。
模型（models目录）代表你的数据结构。通常来说，模型类将包含帮助你对数据库进行增删改查的方法。
视图（views目录）是要展现给用户的信息。一个视图通常就是一个网页，但是在 CodeIgniter 中，一个视图也可以是一部分页面（例如页头、页尾），它也可以是一个 RSS 页面，或其他任何类型的页面。

注：本文中的CI运行基于WAMPServer 环境。

创建模型

打开phpMyAdmin创建表。

再次用CodeIgniter实现简易blog-LMLPHP

这里主要基于该表设计，表名为“myblog”。

在.../application/config/database.php 添加数据库连接。

mysql默认密码为空，数据库名为“test”。“myblog”表在“test”库下创建。

下面实现数据模型层代码，主要是以CI的规则来操作数据库。

.../application/models/News_model.php

<?php

class News_model extends CI_Model {

    public function __construct()

    {

        $this->load->database();

    }

    //获取所有blog

    public function blogs($w,$num,$offset)

    {

        if($w == 1)

        {

            $query = $this->db->get('myblog',$num,$offset);

            return $query->result_array();

        }elseif(strpos($w,"title like"))

        {

            $query = $this->db->query("select * from myblog where $w order by id desc limit 5;");

            return $query->result_array();

        }else{

            $query = $this->db->get('myblog',$num,$offset);

            return $query->result_array();

        }

    }

    //查看一篇blog

    public function up_blogs($id = FALSE)

    {

        if ($id === FALSE)

        {

            $query = $this->db->get('myblog');

            return $query->result_array();

        }

        //更新点击数

        $this->db->query("update myblog set hits=hits+1 where id='$id';");

        $query = $this->db->get_where('myblog', array('id' => $id));

        return $query->row_array();

    }

    //添加一篇blog

    public function add_blogs()

    {

        $this->load->helper('url');

        //$slug = url_title($this->input->post('title'), 'dash', TRUE);

        $d = date("Y-m-d");

        $data = array(

            'title' => $this->input->post('title'),

            'dates' => $d,

            'contents' => $this->input->post('text')

        );

        return $this->db->insert('myblog', $data);

    }

    //删除一篇blog

    public function del_blogs($id = FALSE){

        $this->load->helper('url');

        if ($id === FALSE)

        {

            $query = $this->db->get('myblog');

            return $query->result_array();

        }

        $array = array(

            'id' => $id

        );

        return $this->db->delete("myblog",$array);

    }

}

创建控制

控制层一直起着承前启后的作用，前是前端页面，后是后端数据库。

.../application/controllers/News.php

<?php

class News extends CI_Controller {

    public function __construct()

    {

        parent::__construct();

        $this->load->model('news_model');

        $this->load->helper('url_helper');

    }

    public function index()

    {

        $this->load->library('calendar'); //加载日历类

        parse_str($_SERVER['QUERY_STRING'], $_GET);

        $this->load->library('pagination');//加载分页类

        $this->load->model('news_model');//加载books模型

        $res = $this->db->get('myblog');//进行一次查询

        $config['base_url'] = base_url().'index.php/news/index';//设置分页的url路径

        $config['total_rows'] = $res->num_rows();//得到数据库中的记录的总条数

        $config['per_page'] = '3';//每页记录数

        $config['prev_link'] = 'Previous ';

        $config['next_link'] = ' Next';

        $this->pagination->initialize($config);//分页的初始化

        if (!empty($_GET['key'])) {

            $key = $_GET['key'];

            $w = " title like '%$key%'";

        }else{

            $w=1;

        }

        $data['blogs'] = $this->news_model->blogs($w,$config['per_page'],$this->uri->segment(3));//得到数据库记录

        $this->load->view('templates/header');

        $this->load->view('news/index', $data);

        $this->load->view('templates/footer');

    }

    public function view($id = NULL)

    {

        $this->load->library('calendar');

        $data['blogs_item'] = $this->news_model->up_blogs($id);

        if (empty($data['blogs_item']))

        {

            show_404();

        }

        $data['title'] = $data['blogs_item']['title'];

        $this->load->view('templates/header');

        $this->load->view('./news/view', $data);

        $this->load->view('templates/footer');

    }

    public function del($id = NULL)

    {

        $this->news_model->del_blogs($id);

        //通过js跳回原页面

        echo'

            <script language="javascript">

                alert("create success!");

                window.location.href="http://localhost/CI_blog/index.php/news/";

            </script> ';

    }

    public function create()

    {

        $this->load->library('calendar'); //加载日历类

        $this->load->helper('form');

        $this->load->library('form_validation');

        $data['title'] = 'Create a news item';

        $this->form_validation->set_rules('title', 'Title', 'required');

        $this->form_validation->set_rules('text', 'Text', 'required');

        if ($this->form_validation->run() === FALSE)

        {

            $this->load->view('templates/header', $data);

            $this->load->view('news/create');

            $this->load->view('templates/footer');

        }

        else

        {

            $this->news_model->add_blogs();

            //跳回blog添加页面

            echo'

            <script language="javascript">

                alert("create success!");

                window.location.href="http://localhost/CI_blog/index.php/news/create";

            </script> ';

        }

    }

}

创建视图

为了让页面好看，使用了bootstrap。

定义页头：

.../application/views/templates/header.php

<!DOCTYPE html>

<html lang="zh-CN">

  <head>

    <meta charset="utf-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->

    <meta name="description" content="">

    <meta name="author" content="">

    <link rel="icon" href="../../favicon.ico">

    <title>Blog Template for Bootstrap</title>

    <!-- Bootstrap core CSS -->

    <link href="//cdn.bootcss.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">

    <link href="//v3.bootcss.com/examples/blog/blog.css" rel="stylesheet">

    <script src="//v3.bootcss.com/assets/js/ie-emulation-modes-warning.js"></script>

  </head>

定义页尾：

.../application/views/templates/footer.php

 <footer class="blog-footer">

      <p>Blog template built for <a href="http://getbootstrap.com">Bootstrap</a> by <a href="https://twitter.com/mdo">@mdo</a>.</p>

      <p>

        <a href="#">Back to top</a>

      </p>

    </footer>

    <!-- Bootstrap core JavaScript

    ================================================== -->

    <!-- Placed at the end of the document so the pages load faster -->

    <script src="//cdn.bootcss.com/jquery/1.11.3/jquery.min.js"></script>

    <script src="//cdn.bootcss.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>

    <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->

    <script src="//v3.bootcss.com/assets/js/ie10-viewport-bug-workaround.js"></script>

  </body>

</html>

不过，这里使用的bootstrap并非引用的本地。而是使用的CDN加速点。

blog首页

.../application/views/news/index.php

<body>

    <div class="blog-masthead">

      <div class="container">

        <nav class="blog-nav">

          <a class="blog-nav-item active" href="#">Blog</a>

          <a class="blog-nav-item" href="//localhost/CI_blog/index.php/news/create">Create</a>

          <a class="blog-nav-item" href="#">Press</a>

          <a class="blog-nav-item" href="#">New hires</a>

          <a class="blog-nav-item" href="//localhost/CI_blog/index.php/login">Login</a>

      <form class="navbar-form navbar-right" method="get">

            <div class="form-group">

              <input type="text" name="key" placeholder="sreach" class="form-control">

            </div>

            <button type="submit" class="btn btn-success">Srecch</button>

          </form>

        </nav>

      </div>

    </div>

    <div class="container">

      <div class="row">

        <div class="col-sm-8 blog-main">

          <div class="blog-post">

        <br>

          <?php foreach ($blogs as $blogs_item): ?>

        <h2 class="blog-post-title"><?php echo $blogs_item['title']; ?></h2>

        <p class="blog-post-meta">

          <?php echo $blogs_item['dates']; ?>

          Reading:<?php echo $blogs_item['hits']; ?></a>

        </p>

        <div class="main">

          <?php echo iconv_substr($blogs_item['contents'],0,100); ?>...

        </div>

        <p><a href="<?php echo site_url('news/view/'.$blogs_item['id']); ?>">View article</a></p>

        <p><a href="<?php echo site_url('news/del/'.$blogs_item['id']); ?>">Delete</a></p>

        <?php endforeach; ?>

        <!--翻页链接-->

        <br><br><?php echo $this->pagination->create_links();?>

          </div><!-- /.blog-post -->

        </div><!-- /.blog-main -->

        <div class="col-sm-3 col-sm-offset-1 blog-sidebar">

          <div class="sidebar-module sidebar-module-inset">

            <h4>About</h4>

            <p>Etiam porta <em>sem malesuada magna</em> mollis euismod. Cras mattis consectetur purus sit amet fermentum. Aenean lacinia bibendum nulla sed consectetur.</p>

          </div>

      <div class="sidebar-module sidebar-module-inset">

            <?php echo $this->calendar->generate(); ?>

          </div>

          <div class="sidebar-module">

            <h4>Archives</h4>

            <ol class="list-unstyled">

              <li><a href="#">March 2014</a></li>

              <li><a href="#">February 2014</a></li>

              <li><a href="#">January 2014</a></li>

              <li><a href="#">December 2013</a></li>

              <li><a href="#">November 2013</a></li>

              <li><a href="#">October 2013</a></li>

              <li><a href="#">September 2013</a></li>

              <li><a href="#">August 2013</a></li>

              <li><a href="#">July 2013</a></li>

              <li><a href="#">June 2013</a></li>

              <li><a href="#">May 2013</a></li>

              <li><a href="#">April 2013</a></li>

            </ol>

          </div>

          <div class="sidebar-module">

            <h4>Elsewhere</h4>

            <ol class="list-unstyled">

              <li><a href="#">GitHub</a></li>

              <li><a href="#">Twitter</a></li>

              <li><a href="#">Facebook</a></li>

            </ol>

          </div>

        </div><!-- /.blog-sidebar -->

      </div><!-- /.row -->

    </div><!-- /.container -->

blog添加页面

.../application/views/news/create.php

<!-- ckeditor编辑器源码文件 -->

  <script src="//cdn.ckeditor.com/4.5.5/standard/ckeditor.js"></script>

<body>

    <div class="blog-masthead">

      <div class="container">

        <nav class="blog-nav">

          <a class="blog-nav-item" href="//localhost/CI_blog/index.php/news">Blog</a>

          <a class="blog-nav-item active" href="#">Create</a>

          <a class="blog-nav-item" href="#">Press</a>

          <a class="blog-nav-item" href="#">New hires</a>

          <a class="blog-nav-item" href="#">About</a>

        </nav>

      </div>

    </div>

    <div class="container">

      <div class="blog-header">

        <h2 class="blog-title"><?php echo $title; ?></h2>

        <p class="lead blog-description">Please add an article.</p>

      </div>

      <div class="row">

        <div class="col-sm-8 blog-main">

          <div class="blog-post">

      <?php echo validation_errors(); ?>

      <?php echo form_open('news/create'); ?>

        <label for="title">Title</label><br/>

        <input type="input" name="title" /><br/>

        <label for="text">Contents</label><br/>

        <textarea rows="10" cols="80" name="text"></textarea><br/>

        <script type="text/javascript">CKEDITOR.replace('text');</script>

        <input type="submit" name="submit" value="Create news item" />

      </form>

          </div><!-- /.blog-post -->

        </div><!-- /.blog-main -->

        <div class="col-sm-3 col-sm-offset-1 blog-sidebar">

          <div class="sidebar-module sidebar-module-inset">

            <h4>About</h4>

            <p>Etiam porta <em>sem malesuada magna</em> mollis euismod. Cras mattis consectetur purus sit amet fermentum. Aenean lacinia bibendum nulla sed consectetur.</p>

          </div>

      <div class="sidebar-module sidebar-module-inset">

            <?php echo $this->calendar->generate(); ?>

          </div>

          <div class="sidebar-module">

            <h4>Archives</h4>

            <ol class="list-unstyled">

              <li><a href="#">March 2014</a></li>

              <li><a href="#">February 2014</a></li>

              <li><a href="#">January 2014</a></li>

              <li><a href="#">December 2013</a></li>

              <li><a href="#">November 2013</a></li>

              <li><a href="#">October 2013</a></li>

              <li><a href="#">September 2013</a></li>

              <li><a href="#">August 2013</a></li>

              <li><a href="#">July 2013</a></li>

              <li><a href="#">June 2013</a></li>

              <li><a href="#">May 2013</a></li>

              <li><a href="#">April 2013</a></li>

            </ol>

          </div>

          <div class="sidebar-module">

            <h4>Elsewhere</h4>

            <ol class="list-unstyled">

              <li><a href="#">GitHub</a></li>

              <li><a href="#">Twitter</a></li>

              <li><a href="#">Facebook</a></li>

            </ol>

          </div>

        </div><!-- /.blog-sidebar -->

      </div><!-- /.row -->

    </div><!-- /.container -->

这里使用了ckeditor 编辑器的使用我们可以创建带格式的文章。同样引的CDN。

最后，还要在routes.php文件中添加以下配置。

.../application/config/routes.php

$route['news/create'] = 'news/create';

$route['news/view'] = 'news/view/$1';

$route['news/del'] = 'news/del/$1';

$route['news/news'] = 'news';

$route['news'] = 'news';

$route['default_controller'] = 'pages/view';

好了，主要代码就这些了。感兴趣去github上看完整代码吧！

https://github.com/defnngj/ci_blog

PS：这只是为了练习而已，所以，各个功能很乱，并无打算写一个完整的系统。