php編寫簡單的文章發布程式_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 "資料刪除失敗！";      }    }  }?>

article_add.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><meta name="author" content="Www.XiaZaiBa.Com" /><title>無標題 1</title></head><body><form name="form1" action="<?php echo site_url('article/article_add')?>" method="post">標題：<input name="title" type="text" value="" /><br />內容：<input name="content" type="text" value="" /><br />添加人：<input name="add_man" type="text" value="" /><br />添加時間：系統自動記錄<br />狀態：<input name="tag" type="radio" value="1" />顯示 <input name="tag" type="radio" value="0" />隱藏<br /><input type="submit" name="Submit" value="提交" /></form></body></html>

article_mod.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><meta name="author" content="Www.XiaZaiBa.Com" /><title>無標題 1</title></head><body><form name="form1" action="<?php echo site_url('article/article_mod')?>" method="post">標題：<input name="title" type="text" value="<?php echo $title;?>" /><br />內容：<input name="content" type="text" value="<?php echo $content?>" /><br />添加人：<input name="add_man" type="text" value="<?php echo $add_man;?>" /><br />添加時間：系統自動記錄<br />狀態：<input name="tag" type="radio" value="1" <?php if($tag==1)echo 'checked';?> />顯示 <input name="tag" type="radio" value="0" <?php if($tag==0)echo 'checked';?> />隱藏<br /><input type="submit" name="Submit" value="提交" /><input type="hidden" value="<?php echo $id;?>" name="id" /></form></body></html>

以上所述就是本文的全部內容了希望大家能夠喜歡。