sql;"> 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 ;

PHP;"> 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 "
"; //加载url辅助函数 $this->load->helper('url'); $addr=site_url('article/article_list'); echo "查看文章"; $addr=site_url('article/article_page'); echo "查看分页"; } function article_list(){ echo "这里是文章列表"; //加载数据库模型 //$this->load->model('article_model'); //$this->article_model->index(); //读取所有的文章 $this->load->database(); echo "
"; $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 "
"; echo "第二条记录的标题：".$info[1]['id']; echo "
"; echo "表article中共有这么些记录：".$this->db->count_all('article'); echo "
"; 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']='

'; $config['full_tag_close']='

'; //第二步加载类库 $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']='

'; $config['full_tag_close']='

'; //第二步加载类库 $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 "
"; 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 "修改19"; } 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'); 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 "
"; 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 "数据删除失败！"; } } } ?>

PHP;">

标题：
内容：
添加人：
添加时间：系统自动记录
状态：显示 隐藏

PHP;">

标题：
内容：
添加人：
添加时间：系统自动记录
状态：dio" value="1" />显示 dio" value="0" />隐藏