Php programming simple article releasing_php skills

Source: Internet
Author: User
This article will share with you the use of php to write simple article publishing programs, suitable for php Cainiao learning reference, hope to help you learn php. --

--Table structure '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 (); // load my own class library $ this-> load-> library ('myclass'); $ this-> load-> database (); $ this-> load-> helper ('URL'); $ this-> tips = array ('required' => '[% s] is required! ', 'Is _ unique' =>' this [% s] already exists. please enter another name! ', 'Min _ lenght' => '[% s] the minimum length is [% s]', 'max _ length' => '[% s] the maximum length is [% s]');} function index () {echo "here is the homepage of the article"; echo"
"; // Load the url helper function $ this-> load-> helper ('URL'); $ addr = site_url ('Article/article_list '); echo" view articles "; $ addr = site_url ('Article/article_page '); echo "view pagination";} function article_list () {echo "here is the article list "; // load the database model // $ this-> load-> model ('article _ Model'); // $ this-> article_model-> index (); // read all articles $ 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 (); // of course, you can use result () $ this-> myclass-> p ($ info); echo "the title of the first record :". $ info [0] ['title']; echo"
"; Echo" the title of the second record: ". $ info [1] ['id']; echo"
"; Echo" there are some records in the article table: ". $ this-> db-> count_all ('article'); echo"
"; Echo" a total of these records are queried this time :". $ query-> num_rows ();} function article_page ($ page = 1) {///$ config = array (); // The first step is to query the total number of records $ this-> load-> database (); $ config ['total _ rows '] = $ this-> db-> select (' * ')-> from ('article')-> count_all_results (); // number of records per page $ config ['per _ page'] = 5; // basic url $ this-> load-> helper ('URL '); $ config ['base _ url'] = site_url ('Article/article_page '); // number of displayed links $ config ['Num _ links'] = 100; // display the current page number in the address bar $ config ['use _ page_numbers '] = true; // define the homepage $ config ['first _ link'] = 'homepage '; // define the last page $ config ['last _ link'] = 'Last page'; // Previous Page $ config ['prev _ link'] = 'previous page '; // next Page $ config ['next _ link'] = 'next page '; // wrap the page $ config ['full _ tag_open'] ='

'; $ Config ['full _ tag_close'] ='

'; // The second step loads the class library $ 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 (); // The total number of records retrieved in step 1 // $ this-> load-> database (); // $ config ['total _ rows '] = $ total_rows; // number of records per page $ config ['per _ page'] = $ per_page; // basic url $ this-> load-> helper ('URL '); /// $ config ['base _ url'] = site_url ($ base_url); // number of displayed links $ config ['Num _ links '] = 100; // display the current page number in the address bar $ config ['use _ page_numbers '] = true; // define the homepage $ config ['first _ link'] = 'homepage '; // define the last page $ config ['last _ link'] = 'Last page'; // Previous Page $ config ['prev _ link'] = 'previous page '; // next Page $ config ['next _ link'] = 'next page '; // wrap the page $ config ['full _ tag_open'] ='

'; $ Config ['full _ tag_close'] ='

'; // The second step loads the class library $ 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 '); // start to set verification rules. // set_message can pass a one-dimensional array $ chinesetips = $ this-> tips; $ this-> form_validation-> set_message ($ chinesetips);/* $ this-> form_validation-> set_mes Sage ('required', '[% s] is required! '); $ This-> form_validation-> set_message ('is _ unique',' this [% s] already exists. please enter another name! '); $ This-> form_validation-> set_message ('min _ length',' [% s] minimum length is [% s] '); $ this-> form_validation-> set_message ('max _ length', '[% s] maximum length is [% s]'); */$ this-> form_validation-> set_rules ('title', 'title', 'trim | required | is_unique [article. title] | min_length [6] | max_length [12] '); $ this-> form_validation-> set_rules ('content', 'content', 'required '); $ this-> form_validation-> set_rules ('tag', 'status', 'required'); if ($ this-> M_validation-> run () = true) {echo "form verification successful! "; Print_r ($ this-> input-> post (); $ data = $ this-> input-> post (); unset ($ data ['submit ']); $ data ['add _ time'] = date ('Y-m-d H: I: s '); $ data ['View'] = '0'; $ st = $ this-> db-> insert ('article', $ data); if ($ st) {echo "data inserted successfully! "; Echo" New id: ". $ this-> db-> insert_id ();} // echo get_magic_quotes_gpc ();} else {echo" form verification failed! "; 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 "modify 19";} function article_mod_viewer ($ id) {if ($ id = "") {echo "no parameter passed"; exit ;} $ this-> load-> helper ('URL'); // query from the database $ 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 '); // start setting verification rules // set_message can be used to pass a one-dimensional array $ chinesetips = $ this-> tips; $ this-> form_validation-> set_message ($ chinesetips ); $ this-> form_validation-> set_rules ('title', 'title','t Rim | required | min_length [6] | max_length [12] | callback_abc '); $ this-> form_validation-> set_rules ('content', 'content', 'required '); $ this-> form_validation-> set_rules ('tag', 'status', 'required'); if ($ this-> form_validation-> run () = true) {echo "form verification successful! "; 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 ['View'] = '0 '; // p ($ data); $ st = $ this-> db-> where ('id', $ id)-> update ('article', $ data ); if ($ st) {echo "data modification succeeded";} else {echo "data modification failed";} else {echo "form verification failed! "; Echo"
"; Echo validation_errors () ;}} function article_del ($ id ='') {if ($ id = "") {// exit ('upload ID');} $ id = array (17,18, 19); $ this-> db-> where_in ('id', $ id) -> delete ('article'); $ st = $ this-> db-> affected_rows (); echo $ st; if ($ st) {echo "data deleted successfully! ";} Else {echo" an error occurred while deleting the data! ";}}?>

Article_add.php

 
 No title 1

Article_mod.php

 
 No title 1

The above is all the content of this article. I hope you will like it.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.