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;">
搜索