php编写简单的文章发布程序

--

-- 表的结构 `yi_article`

--

CREATE TABLE IF NOT EXISTS `yi_article` ( `id` int(11) unsigned NOT NULL auto_increment, `title` varchar(256) NOT NULL, `content` mediumtext NOT NULL, `add_man` varchar(20) NOT NULL, `add_time` datetime NOT NULL, `views` int(11) NOT NULL, `tag` tinyint(4) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

article.php

<?php  class Article extends CI_Controller{    public $tips;    function __construct(){      parent::__construct();      //加载我自己的类库      $this->load->library('myclass');      $this->load->database();      $this->load->helper('url');      $this->tips=array(        'required'=>' [%s] 是必须填写的！',        'is_unique'=>'此 [%s] 已经存在，请输入其它名称！',        'min_lenght'=>' [%s] 最小长度为 [%s]',        'max_length'=>'[%s] 最大长度为 [%s]'      );    }    function index(){      echo "这里是文章的首页";      echo "<br />";      //加载url辅助函数      $this->load->helper('url');      $addr=site_url('article/article_list');      echo "<a href='$addr'>查看文章</a>";      $addr=site_url('article/article_page');      echo "<a href='$addr'>查看分页</a>";    }    function article_list(){      echo "这里是文章列表";      //加载数据库模型      //$this->load->model('article_model');      //$this->article_model->index();      //读取所有的文章      $this->load->database();      echo "<br />";      $query=$this->db->where("id >",5)->select('id,title')->from('article')->order_by('id','desc')->limit(4)->get();      $info=$query->result_array();//当然你可以用result()      $this->myclass->p($info);      echo "第一条记录的标题：".$info[0]['title'];      echo "<br />";      echo "第二条记录的标题：".$info[1]['id'];      echo "<br />";      echo "表article中共有这么些记录：".$this->db->count_all('article');      echo "<br />";      echo "本次共查询出这么些条记录：".$query->num_rows();    }    function article_page($page=1){      ///////////////////////////////////      $config=array();      //第一步查询出总记录数      $this->load->database();      $config['total_rows']=$this->db->select('*')->from('article')->count_all_results();      //每页记录数      $config['per_page']=5;      //基础url      $this->load->helper('url');      $config['base_url']=site_url('article/article_page');      //显示的链接数      $config['num_links']=100;      //在地址栏显示当前页码      $config['use_page_numbers']=true;      //定义首页      $config['first_link']='首页';      //定义末页      $config['last_link']='尾页';      //上一页      $config['prev_link']='上一页';      //下一页      $config['next_link']='下一页';      //把分页包起来      $config['full_tag_open']='<p>';      $config['full_tag_close']='</p>';      //第二步加载类库      $this->load->library('pagination');      $this->pagination->initialize($config);      echo $this->pagination->create_links();      /////////////////////////////////////      $page=$page?intval($page):1;      $start=($page-1)*$config['per_page'];      $query=$this->db->select('*')->from('article')->limit($config['per_page'],$start);      $info=$query->get()->result_array();      $this->myclass->p($info);      echo $this->pagination->create_links();      //echo base_url('abc/def');    }    protected function _page($total_rows,$per_page,$base_url){      ///////////////////////////////////      $config=array();      //第一步查询出总记录数      //$this->load->database();////      $config['total_rows']=$total_rows;      //每页记录数      $config['per_page']=$per_page;      //基础url      $this->load->helper('url');////      $config['base_url']=site_url($base_url);      //显示的链接数      $config['num_links']=100;      //在地址栏显示当前页码      $config['use_page_numbers']=true;      //定义首页      $config['first_link']='首页';      //定义末页      $config['last_link']='尾页';      //上一页      $config['prev_link']='上一页';      //下一页      $config['next_link']='下一页';      //把分页包起来      $config['full_tag_open']='<p>';      $config['full_tag_close']='</p>';      //第二步加载类库      $this->load->library('pagination');      $this->pagination->initialize($config);      return $this->pagination->create_links();      /////////////////////////////////////    }    function page($page=1){      $config['per_page']=5;      $page=$page?intval($page):1;      $start=($page-1)*$config['per_page'];      $query=$this->db->select('*')->from('article')->limit($config['per_page'],$start);      $info=$query->get()->result_array();      return $info;    }    function article_add(){      $this->load->library('form_validation');      //开始设置验证规则      //set_message可以传一个一维数组      $chinesetips=$this->tips;      $this->form_validation->set_message($chinesetips);      /*      $this->form_validation->set_message('required', ' [%s] 是必须填写的！');      $this->form_validation->set_message('is_unique', '此 [%s] 已经存在，请输入其它名称！');      $this->form_validation->set_message('min_length', ' [%s] 最小长度为 [%s]');      $this->form_validation->set_message('max_length', ' [%s] 最大长度为 [%s]');      */      $this->form_validation->set_rules('title','标题','trim|required|is_unique[article.title]|min_length[6]|max_length[12]');        $this->form_validation->set_rules('content','内容','required');      $this->form_validation->set_rules('tag','状态','required');      if($this->form_validation->run()==true){        echo "表单验证成功！";        print_r($this->input->post());        $data=$this->input->post();        unset($data['Submit']);        $data['add_time']=date('Y-m-d H:i:s');        $data['views']='0';        $st=$this->db->insert('article',$data);        if($st){          echo "数据插入成功！";          echo "新的id为：".$this->db->insert_id();        }        //echo get_magic_quotes_gpc();      }else{        echo "表单验证失败！";        echo "<br />";        echo validation_errors();      }    }    function article_add_viewer(){      $this->load->helper('url');      $this->load->view('article_add');    }    function article_links(){      $addr=site_url('article/article_mod_viewer/19');      echo "<a href='$addr'>修改19</a>";    }    function article_mod_viewer($id){      if($id==""){        echo "没有传递参数";        exit;      }      $this->load->helper('url');      //从数据库中查出来      $query=$this->db->select()->from('article')->where('id',$id)->get();      $info=$query->row_array();      print_r($info);      $this->load->view('article_mod',$info);    }    function abc($val){      $this->form_validation->set_message('abc','不行');      //p($val);      return true;    }    function article_mod(){      $this->load->library('form_validation');      //开始设置验证规则      //set_message可以传一个一维数组      $chinesetips=$this->tips;      $this->form_validation->set_message($chinesetips);      $this->form_validation->set_rules('title','标题','trim|required|min_length[6]|max_length[12]|callback_abc');        $this->form_validation->set_rules('content','内容','required');      $this->form_validation->set_rules('tag','状态','required');      if($this->form_validation->run()==true){        echo "表单验证成功！";        print_r($this->input->post());        $data=$this->input->post();        $id=$data['id'];        unset($data['id']);        unset($data['Submit']);        $data['add_time']=date('Y-m-d H:i:s');        $data['views']='0';        //p($data);        $st=$this->db->where('id',$id)->update('article',$data);        if($st){          echo "数据修改成功";        }else{          echo "数据修改失败";        }      }else{        echo "表单验证失败！";        echo "<br />";        echo validation_errors();      }    }    function article_del($id=''){      if($id==""){        //exit('请传id');      }      $id=array(17,18,19);      $this->db->where_in('id',$id)->delete('article');      $st=$this->db->affected_rows();      echo $st;      if($st){        echo "数据删除成功！";      }else{        echo "数据删除失败！";      }    }  }?>