phpstudy数据库创建步骤：
那要看你用的是什么数据库,如果要创建成功的提示的话更简单,只需要加上一个判断语句就好了......
首先回答你搭建一个完整动态网站的步骤：
①.、首先你得搭建PHP运行环境.建议使用PHP开发速成搭建工具包xampp.集成php+phpmyadm+mysql
你做好程序以后,把数据库导出成sql文件（这个文件里就已经有了一下创建数据表,添加数据记录等的一些sql语句了）
新建一个安装文件：
①.、连接数据库（安装的时候不是要填写一些数据库连接参数等吗）
就这么简单,思路是这样啊,具体这么实现,你自己慢慢研究
if(!is_writable('config.php')){
}
if(!is_writable(EMLOG_ROOT.'/content/cache')){
$config?=?"?php\n"
."//mysql?database?address\n"
."define('DB_HOST','$db_host');"
."\n//mysql?database?user\n"
."define('DB_USER','$db_user');"
."\n//database?password\n"
."define('DB_PASSWD','$db_pw');"
."\n//database?name\n"
."define('DB_NAME','$db_name');"
."\n//database?prefix\n"
."define('DB_PREFIX','$db_prefix');"
."\n//auth?key\n"
."\n//cookie?name\n"
."\n";
if?(!$fw){
fclose($fp);
//密码加密存储
$adminpw?=?$PHPASS-HashPassword($adminpw);
$type?=?'MYISAM';
$widgets?=?Option::getWidgetTitle();
$sider_wg?=?Option::getDefWidget();
$widget_title?=?serialize($widgets);
$widgets?=?serialize($sider_wg);
define('BLOG_URL',?getBlogUrl());
$sql?=?"
DROP?TABLE?IF?EXISTS?{$db_prefix}blog;
CREATE?TABLE?{$db_prefix}blog?(
gid?int(10)?unsigned?NOT?NULL?auto_increment,
content?longtext?NOT?NULL,
excerpt?longtext?NOT?NULL,
author?int(10)?NOT?NULL?default?'1',
sortid?int(10)?NOT?NULL?default?'-1',
views?int(10)?unsigned?NOT?NULL?default?'0',
comnum?int(10)?unsigned?NOT?NULL?default?'0',
attnum?int(10)?unsigned?NOT?NULL?default?'0',
top?enum('n','y')?NOT?NULL?default?'n',
sortop?enum('n','y')?NOT?NULL?default?'n',
hide?enum('n','y')?NOT?NULL?default?'n',
checked?enum('n','y')?NOT?NULL?default?'y',
allow_remark?enum('n','y')?NOT?NULL?default?'y',
PRIMARY?KEY?(gid),
KEY?date?(date),
KEY?author?(author),
KEY?sortid?(sortid),
KEY?type?(type),
KEY?views?(views),
KEY?comnum?(comnum),
KEY?hide?(hide)
)".$table_charset_sql."
DROP?TABLE?IF?EXISTS?{$db_prefix}attachment;
CREATE?TABLE?{$db_prefix}attachment?(
aid?int(10)?unsigned?NOT?NULL?auto_increment,
blogid?int(10)?unsigned?NOT?NULL?default?'0',
filesize?int(10)?NOT?NULL?default?'0',
width?int(10)?NOT?NULL?default?'0',
height?int(10)?NOT?NULL?default?'0',
thumfor?int(10)?NOT?NULL?default?0,
PRIMARY?KEY?(aid),
KEY?blogid?(blogid)
DROP?TABLE?IF?EXISTS?{$db_prefix}comment;
CREATE?TABLE?{$db_prefix}comment?(
cid?int(10)?unsigned?NOT?NULL?auto_increment,
gid?int(10)?unsigned?NOT?NULL?default?'0',
pid?int(10)?unsigned?NOT?NULL?default?'0',
comment?text?NOT?NULL,
PRIMARY?KEY?(cid),
KEY?gid?(gid),
DROP?TABLE?IF?EXISTS?{$db_prefix}options;
CREATE?TABLE?{$db_prefix}options?(
option_id?INT(?11?)?UNSIGNED?NOT?NULL?auto_increment,
option_value?LONGTEXT?NOT?NULL?,
PRIMARY?KEY?(option_id),
KEY?option_name?(option_name)
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('blogname','点滴记忆');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('bloginfo','使用emlog搭建的站点');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('site_title','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('site_description','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('site_key','emlog');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('log_title_style','0');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('blogurl','".BLOG_URL."');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('icp','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('footer_info','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('rss_output_num','0');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('rss_output_fulltext','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_lognum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_comnum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_twnum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('nonce_templet','default');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('admin_style','default');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('tpl_sidenum','1');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_code','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_needchinese','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isgravatar','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isthumbnail','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('att_type','rar,zip,gif,jpg,jpeg,png,txt,pdf,docx,doc,xls,xlsx');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_paging','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_pnum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_order','newer');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('login_code','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('reply_code','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('iscomment','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('ischkcomment','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('ischkreply','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isurlrewrite','0');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isalias','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isalias_html','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isgzipenable','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isxmlrpcenable','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('ismobile','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isexcerpt','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('istwitter','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('istreply','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('topimg','content/templates/default/images/top/default.jpg');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('custom_topimgs','a:0:{}');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('active_plugins','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widget_title','$widget_title');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('custom_widget','a:0:{}');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widgets1','$widgets');
创建数据库：create database 数据库名
创建数据表：
CREATE TABLE +users+ (
+id+ tinyint(10) auto_increment primary key NOT NULL,
+age+ int(10) NOT NULL
执行这两个sql语句就行
以上就是土嘎嘎小编为大家整理的数据库php后台表的搭建相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！