php 增删改查.docx

1、php 增删改查php 增删改查CREATE TABLE IF NOT EXISTS o_code ( o_id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT /id, o_english varchar(50) NOT NULL COMMENT /单词, o_symbol varchar(50) DEFAULT NULL COMMENT /音标, o_info varchar(250) DEFAULT NULL COMMENT /说明, o_time datetime NOT NULL COMMENT /发布时间, o_out char(1

2、) NOT NULL COMMENT /回收站, o_type smallint(6) NOT NULL COMMENT /分类, PRIMARY KEY (o_id) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=/代码单词表 AUTO_INCREMENT=1 ;INSERT INTO o_code (o_id, o_english, o_symbol, o_info, o_time, o_out, o_type) VALUES(1, input, npt, 输入, 2016-01-06 17:49:13, 0, 3),(2, form, f:rm,

3、表单, 2016-01-06 17:55:15, 0, 3),(3, button, btn, 按钮, 2016-01-06 17:56:12, 0, 3),(4, section, skn, 定义文档中的节, 2016-01-06 18:02:36, 0, 3),(5, header, hd, 定义文档的页眉, 2016-01-06 19:50:02, 0, 3),(6, caption, kpn, 定义表格标题, 2016-01-06 19:51:35, 0, 3),(7, address, dres, 地址, 2016-01-06 19:53:00, 0, 3),(8, article,

4、 :rtkl, 内容, 2016-01-06 19:53:56, 0, 3),(9, footer, ft, 底部, 2016-01-06 19:54:50, 0, 3),(10, table, tebl, 表格, 2016-01-06 19:56:03, 0, 3);mysql.func.phpclose.inc.phpcommon.inc.phptype.func.phpindex.php代码单词body font-family: Helvetica Neue, Helvetica, Arial, Microsoft Yahei UI, Microsoft YaHei, SimHei, 5

5、B8B4F53, simsun, sans-serif;.english color: #333.english:link color: #333; text-decoration: none;.english:visited color: #333; text-decoration: none;.english:hover color: #333; text-decoration: none;.english:active color: #333; text-decoration: none; 搜索 最新 最旧 A-Z Z-A 分类 ?php for($i=1;$icount($_type_

6、arr);$i+) echo $_type_arr$i$_info_type$i; ? ?php echo $_type_arr0$_info_type0; ? 单词 音标 说明 ?php $_search = trim($_GETsearch); $_sort = $_GETsort; $_type = $_GETtype; $_page=$_GETpage;/获取当前的页数 $_page_show =3;/最大显示3页 $_page_size =10;/显示每页的条数 if($_page = null | $_page target=_blank class=english ?php$_s

7、ql_count = SELECT count( o_id ) FROM o_code WHERE o_out=0 ; /获取参数$_con = ;if($_search !=null) $_sql_count.= AND o_english LIKE %$_search%; $_con = search=$_search&;else if($_sort !=null) $_con = sort=$_sort&;else if($_type !=null) $_sql_count.= AND o_type = $_type; $_con = type=$_type&;/分页$_answers

8、= mysql_fetch_array(_query($_sql_count);$_allcount= $_answers0;$_page_count = ceil($_allcount/$_page_size);if($_page = $_page_count) $_page = $_page_count;$_pre_page = ($_page = 1)? 1 : $_page - 1;$_next_page= ($_page = $_page_count)? $_page_count : $_page + 1 ;$_pagenav .= 共.$_allcount.条;$_pagenav

9、.= « ;$_page_show_start = (ceil($_page/$_page_show)-1)*$_page_show;$_page_show_str = ;if($_page_show$_page_count) $_page_show = $_page_count;for($j=1;$j=$_page_show;$j+) $_page_show_now = $_page_show_start+$j; if($_page=$_page_show_now) $_page_show_str .= $_page_show_now; else $_page_show_str

10、.= $_page_show_now; $_pagenav.=$_page_show_str;$_pagenav .= »$_pagenav .= 末页;echo $_pagenav;? 效果图：admin.php?php define(IN_TG,true); require dirname(_FILE_)./includes/common.inc.php; require ROOT_PATH.includes/type.func.php; $_type_arr = _type(); $_info_type = _info_type(); $_page=$_GETpage; $_search = trim($_GETsearch); if($_page = null | $_page管理body font-family: Helvetica Neue, Helvetica, Arial, Microsoft Yahei UI, Microsoft YaHei, SimHei, 5B8B4F53, simsun, sans-serif; input type=text class=form-control name=search value= 搜索 新增 单词/t