概念混乱啊,PHP是一种编程语言,不是文件.
表是数据库中的对象,通常应该通过数据库管理系统来建立表,然后通过编程语言做出的程序访问表中的数据,而不是动态建立表格.
首先你把这个sql语句赋给一个字符串变量：
$sql="CREATE TABLE IF NOT EXISTS +{$installer-getTable('catalog_category_description')}+ (
+description+ text NOT NULL,
+meta_description+ text NOT NULL,
PRIMARY KEY (+category_id+,+language_id+),
KEY +i_language_id+ (+language_id+),
CONSTRAINT +fk_category_id+ FOREIGN KEY (+category_id+) REFERENCES +{$installer-getTable('catalog_category')}+ (+id+) ON DELETE CASCADE,
CONSTRAINT +fk_language_id+ FOREIGN KEY (+language_id+) REFERENCES +{$installer-getTable('locale_language')}+ (+id+) ON DELETE CASCADE
然后连接mysql数据库,执行这个语句：
mysql_connect("localhost","root","");
mysql_select_db("dbname");
mysql_query($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');
php$server = "localhost";
$username = "root";
$password = "";
$database = "myabc";
$ranks = array(
①.="newbie",
①.0="low god",
①.1="medium god",
$couldNotConnectMysql="Could not connect Mysql!";
$conn=mysql_connect($server,$username,$password) or die ($couldNotConnectMysql);
if (mysql_select_db($database,$conn))
{//数据库存在,做相应操作}else{//数据库不存在,创建一个,并做相应操作
创建数据库：create database 数据库名
创建数据表：
CREATE TABLE +users+ (
+id+ tinyint(10) auto_increment primary key NOT NULL,
+age+ int(10) NOT NULL
执行这两个sql语句就行
建立数据表,得是你在cmd窗口或者phpmyadmin、navicat for mysql这类终端软件里进行操作.建立数据表的指令是create table xxx ();
连接数据库使用php封装好的一个函数mysql_connect();
例如：
这样的语句来连接,因为连接数据库会生成连接标识资源,你把这个资源赋给一个新变量
这样你拿着新变量去玩别的也好下手.
用框架做久了这个东西都容易忘,我也是凭记忆写的,你试试看这个能不能过关.
以上就是土嘎嘎小编为大家整理的php在数据库创建一个表相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！