php 增删改查.docx
- 文档编号:10428397
- 上传时间:2023-02-11
- 格式:DOCX
- 页数:28
- 大小:64.70KB
php 增删改查.docx
《php 增删改查.docx》由会员分享,可在线阅读,更多相关《php 增删改查.docx(28页珍藏版)》请在冰豆网上搜索。
php增删改查
php增删改查
CREATETABLEIFNOTEXISTS`o_code`(
`o_id`int(10)unsignedNOTNULLAUTO_INCREMENTCOMMENT'//id',
`o_english`varchar(50)NOTNULLCOMMENT'//单词',
`o_symbol`varchar(50)DEFAULTNULLCOMMENT'//音标',
`o_info`varchar(250)DEFAULTNULLCOMMENT'//说明',
`o_time`datetimeNOTNULLCOMMENT'//发布时间',
`o_out`char
(1)NOTNULLCOMMENT'//回收站',
`o_type`smallint(6)NOTNULLCOMMENT'//分类',
PRIMARYKEY(`o_id`)
)ENGINE=MyISAMDEFAULTCHARSET=utf8COMMENT='//代码单词表'AUTO_INCREMENT=1;
INSERTINTO`o_code`(`o_id`,`o_english`,`o_symbol`,`o_info`,`o_time`,`o_out`,`o_type`)VALUES
(1,'input','[ˈɪnˌpʊt]','输入','2016-01-0617:
49:
13','0',3),
(2,'form','[fɔ:
rm]','表单','2016-01-0617:
55:
15','0',3),
(3,'button','[ˈbʌtn]','按钮','2016-01-0617:
56:
12','0',3),
(4,'section','[ˈsɛkʃən]','定义文档中的节','2016-01-0618:
02:
36','0',3),
(5,'header','[ˈhɛdɚ]','定义文档的页眉','2016-01-0619:
50:
02','0',3),
(6,'caption','[ˈkæpʃən]','定义表格标题','2016-01-0619:
51:
35','0',3),
(7,'address','[ˈædres]','地址','2016-01-0619:
53:
00','0',3),
(8,'article','[ˈɑ:
rtɪkl]','内容','2016-01-0619:
53:
56','0',3),
(9,'footer','[ˈfʊtɚ]','底部','2016-01-0619:
54:
50','0',3),
(10,'table','[ˈtebəl]','表格','2016-01-0619:
56:
03','0',3);
mysql.func.php
php
//防止恶意调用
if(!
defined('IN_TG')){
exit('AccessDefined!
');
}
//_connect()连接MYSQL数据库
function_connect(){
//global表示全局变量的意思,意图是将此变量在函数外部也能访问
global$_conn;
if(!
$_conn=@mysql_connect(DB_HOST,DB_USER,DB_PWD)){
exit('数据库连接失败');
}
}
//_select_db选择一款数据库
function_select_db(){
if(!
mysql_select_db(DB_NAME)){
exit('找不到指定的数据库');
}
}
//设置字符集
function_set_names(){
if(!
mysql_query('SETNAMESUTF8')){
exit('字符集错误');
}
}
//获取一条数据
function_query($_sql){
if(!
$_result=mysql_query($_sql)){
exit('SQL执行失败');
}
return$_result;
}
//获取一批数据
function_fetch_array($_sql){
returnmysql_fetch_array(_query($_sql),MYSQL_ASSOC);
}
//关闭数据库
function_close(){
if(!
mysql_close()){
exit('关闭异常');
}
}
?
>
close.inc.php
php
//防止恶意调用
if(!
defined('IN_TG')){
exit('AccessDefined!
');
}
_close();
?
>
common.inc.php
php
//防止恶意调用
if(!
defined('IN_TG')){
exit('AccessDefined!
');
}
//设置字符集编码
header('Content-Type:
text/html;charset=utf-8');
//转换硬路径常量
define('ROOT_PATH',substr(dirname(__FILE__),0,-8));
//引入函数库
requireROOT_PATH.'includes/mysql.func.php';
//数据库连接
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PWD','123456');
define('DB_NAME','osweb');
//初始化数据库
_connect();//连接MYSQL数据库
_select_db();//选择指定的数据库
_set_names();//设置字符集
?
>
type.func.php
php
//防止恶意调用
if(!
defined('IN_TG')){
exit('AccessDefined!
');
}
//存放代码分类
function_type(){
$_type=array('[Z]','[B]','[H]','[D]','[J]','[Q]','[P]','[X]','[S]','[I]','[C]','[M]');
return$_type;
}
//存放代码分类说明
function_info_type(){
$_type=array('其他','bootstrap','html5','dede','javascript','jquery','php','html4','style','id','class','mysql');
return$_type;
}
?
>
index.php
php
define('IN_TG',true);
requiredirname(__FILE__).'/includes/common.inc.php';
requireROOT_PATH.'includes/type.func.php';
$_type_arr=_type();
$_info_type=_info_type();
?
>
DOCTYPEhtml>
body{font-family:
"HelveticaNeue",Helvetica,Arial,"MicrosoftYaheiUI","MicrosoftYaHei",SimHei,"\5B8B\4F53",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;}
10px;">
sort=1">最新 sort=2">最旧 sort=3">A-Z sort=4">Z-A 分类 php for($i=1;$i echo" type=".($i+1)."\">$_type_arr[$i]$_info_type[$i] } ? > phpecho" type=1\">$_type_arr[0]$_info_type[0] >
单词 音标 说明
php
$_search=trim($_GET['search']);
$_sort=$_GET['sort'];
$_type=$_GET['type'];
$_page=$_GET['page'];//获取当前的页数
$_page_show=3;//最大显示3页
$_page_size=10;//显示每页的条数
if($_page==null||$_page<=0){
$_page=1;
}
$_page_begin=($_page-1)*$_page_size;
$_sql_list="SELECT*FROMo_codeWHEREo_out='0'";
if($_search!
=null){
$_sql_list.="ANDo_englishLIKE'%$_search%'orderbyo_timeDESCLIMIT$_page_begin,$_page_size";
}elseif($_sort!
=null){
switch($_sort){
case1:
$_sql_list.="orderbyo_timeDESCLIMIT$_page_begin,$_page_size";
break;
case2:
$_sql_list.="orderbyo_timeASCLIMIT$_page_begin,$_page_size";
break;
case3:
$_sql_list.="orderbyo_englishASC,o_timeDESCLIMIT$_page_begin,$_page_size";
break;
case4:
$_sql_list.="orderbyo_englishDESC,o_timeDESCLIMIT$_page_begin,$_page_size";
break;
default:
$_sql_list.="orderbyo_timeDESCLIMIT$_page_begin,$_page_size";
}
}elseif($_type!
=null){
$_sql_list.="ANDo_type='$_type'orderbyo_englishASCLIMIT$_page_begin,$_page_size";
}else{
$_sql_list.="orderbyo_timeDESCLIMIT$_page_begin,$_page_size";
}
$_result=_query($_sql_list);
while(!
!
$row=mysql_fetch_array($_result)){
?
>
>"target="_blank"class="english">
phpecho$row[o_english]?
>
phpecho$row[o_symbol]?
>
phpecho$_type_arr[$row[o_type]-1];?
>
phpecho$row[o_info]?
>
php
}
?
>
php
$_sql_count="SELECTcount(o_id)FROMo_codeWHEREo_out='0'";
//获取参数
$_con='';
if($_search!
=null){
$_sql_count.="ANDo_englishLIKE'%$_search%'";
$_con="search=$_search&";
}elseif($_sort!
=null){
$_con="sort=$_sort&";
}elseif($_type!
=null){
$_sql_count.="ANDo_type='$_type'";
$_con="type=$_type&";
}
//分页
$_answers=mysql_fetch_array(_query($_sql_count));
$_allcount=$_answers[0];
$_page_count=ceil($_allcount/$_page_size);
if($_page<=1||$_page=='')$_page=1;
if($_page>=$_page_count)$_page=$_page_count;
$_pre_page=($_page==1)?
1:
$_page-1;
$_next_page=($_page==$_page_count)?
$_page_count:
$_page+1;
$_pagenav.="
".$_con."page=1'>共".$_allcount."条
$_pagenav.="
".$_con."page=$_pre_page'>«
$_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.=" ".$_con."page=$_page_show_now'>$_page_show_now"; }else{ $_page_show_str.=" ".$_con."page=$_page_show_now'>$_page_show_now
}
}
$_pagenav.=$_page_show_str;
$_pagenav.="
".$_con."page=$_next_page'>»
$_pagenav.="
".$_con."page=$_page_count'>末页
echo$_pagenav;
?
>
php
requireROOT_PATH.'includes/close.inc.php';
?
>