一般PHP系统的网站,安装时往数据库里建表怎么操作? 比如我已经有了123.sql文件现在想弄一个安装页面,点提交就将123.sql导入到指定的表中代码怎么写? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?phpif(...){//判断提交 //连接数据库... $path="./123.sql";//123.sql相对该php文件地址 mysql_query("source $path");} 找一个安装程序的开源项目,安装一下不就知道了。dedecms的,一看就明了大概如下sql-dftables.txtDROP TABLE IF EXISTS `#@__addonarticle`;CREATE TABLE `#@__addonarticle` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `redirecturl` varchar(255) NOT NULL default '', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`)) TYPE=MyISAM;DROP TABLE IF EXISTS `#@__addonimages`;CREATE TABLE `#@__addonimages` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `pagestyle` smallint(6) NOT NULL default '1', `maxwidth` smallint(6) NOT NULL default '600', `imgurls` text, `row` smallint(6) NOT NULL default '0', `col` smallint(6) NOT NULL default '0', `isrm` smallint(6) NOT NULL default '0', `ddmaxwidth` smallint(6) NOT NULL default '200', `pagepicnum` smallint(6) NOT NULL default '12', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `redirecturl` varchar(255) NOT NULL default '', `body` mediumtext, PRIMARY KEY (`aid`), KEY `imagesMain` (`typeid`)) TYPE=MyISAM;DROP TABLE IF EXISTS `#@__addoninfos`;CREATE TABLE `#@__addoninfos` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `channel` smallint(6) NOT NULL default '0', `arcrank` smallint(6) NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL default '0', `click` int(10) unsigned NOT NULL default '0', `title` varchar(60) NOT NULL default '', `litpic` varchar(60) NOT NULL default '', `userip` varchar(15) NOT NULL default ' ', `senddate` int(11) NOT NULL default '0', `flag` set('c','h','p','f','s','j','a','b') default NULL, `lastpost` int(10) unsigned NOT NULL default '0', `scores` mediumint(8) NOT NULL default '0', `goodpost` mediumint(8) unsigned NOT NULL default '0', `badpost` mediumint(8) unsigned NOT NULL default '0', `nativeplace` smallint(5) unsigned NOT NULL default '0', `infotype` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `endtime` int(11) NOT NULL default '0', `tel` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `address` varchar(100) NOT NULL default '', `linkman` varchar(50) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`,`nativeplace`,`infotype`), KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`)) TYPE=MyISAM;。 $query = ''; $fp = fopen(dirname(__FILE__).'/sql-dftables.txt','r'); while(!feof($fp)) { $line = rtrim(fgets($fp,1024)); if(ereg(";$",$line)) { $query .= $line."\n"; $query = str_replace('#@__',$dbprefix,$query); if($mysqlVersion < 4.1) { $rs = mysql_query($query,$conn); } else { if(eregi('CREATE',$query)) { $rs = mysql_query(eregi_replace('TYPE=MyISAM',$sql4tmp,$query),$conn); } else { $rs = mysql_query($query,$conn); } } $query=''; } else if(!ereg("^(//|--)",$line)) { $query .= $line; } } fclose($fp); php 代码被加密eval(gzinflate(str_rot13(base64_decode pdo的使用,请高手看看. smarty 如何把零给显示出来 问一个xml的问题 response问题 php将数据库查询出来的记录显示在表格里面问题 超链接传递参数的问题 PHP如何自动生成HTML文件? Zend软件大派送 关于指定类型的文件的上传 选号算法开发!休闲娱乐 php怎么判断当前时间在某个时间范围内?
if(...){//判断提交 //连接数据库... $path="./123.sql";//123.sql相对该php文件地址
mysql_query("source $path");
}
dedecms的,一看就明了大概如下
sql-dftables.txt
DROP TABLE IF EXISTS `#@__addonarticle`;
CREATE TABLE `#@__addonarticle` (
`aid` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`body` mediumtext,
`redirecturl` varchar(255) NOT NULL default '',
`templet` varchar(30) NOT NULL default '',
`userip` char(15) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `typeid` (`typeid`)
) TYPE=MyISAM;DROP TABLE IF EXISTS `#@__addonimages`;
CREATE TABLE `#@__addonimages` (
`aid` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`pagestyle` smallint(6) NOT NULL default '1',
`maxwidth` smallint(6) NOT NULL default '600',
`imgurls` text,
`row` smallint(6) NOT NULL default '0',
`col` smallint(6) NOT NULL default '0',
`isrm` smallint(6) NOT NULL default '0',
`ddmaxwidth` smallint(6) NOT NULL default '200',
`pagepicnum` smallint(6) NOT NULL default '12',
`templet` varchar(30) NOT NULL default '',
`userip` char(15) NOT NULL default '',
`redirecturl` varchar(255) NOT NULL default '',
`body` mediumtext,
PRIMARY KEY (`aid`),
KEY `imagesMain` (`typeid`)
) TYPE=MyISAM;DROP TABLE IF EXISTS `#@__addoninfos`;
CREATE TABLE `#@__addoninfos` (
`aid` int(11) NOT NULL default '0',
`typeid` int(11) NOT NULL default '0',
`channel` smallint(6) NOT NULL default '0',
`arcrank` smallint(6) NOT NULL default '0',
`mid` mediumint(8) unsigned NOT NULL default '0',
`click` int(10) unsigned NOT NULL default '0',
`title` varchar(60) NOT NULL default '',
`litpic` varchar(60) NOT NULL default '',
`userip` varchar(15) NOT NULL default ' ',
`senddate` int(11) NOT NULL default '0',
`flag` set('c','h','p','f','s','j','a','b') default NULL,
`lastpost` int(10) unsigned NOT NULL default '0',
`scores` mediumint(8) NOT NULL default '0',
`goodpost` mediumint(8) unsigned NOT NULL default '0',
`badpost` mediumint(8) unsigned NOT NULL default '0',
`nativeplace` smallint(5) unsigned NOT NULL default '0',
`infotype` smallint(5) unsigned NOT NULL default '0',
`body` mediumtext,
`endtime` int(11) NOT NULL default '0',
`tel` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`address` varchar(100) NOT NULL default '',
`linkman` varchar(50) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `typeid` (`typeid`,`nativeplace`,`infotype`),
KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`)
) TYPE=MyISAM;
。
$query = '';
$fp = fopen(dirname(__FILE__).'/sql-dftables.txt','r');
while(!feof($fp))
{
$line = rtrim(fgets($fp,1024));
if(ereg(";$",$line))
{
$query .= $line."\n";
$query = str_replace('#@__',$dbprefix,$query);
if($mysqlVersion < 4.1)
{
$rs = mysql_query($query,$conn);
}
else
{
if(eregi('CREATE',$query))
{
$rs = mysql_query(eregi_replace('TYPE=MyISAM',$sql4tmp,$query),$conn);
}
else
{
$rs = mysql_query($query,$conn);
}
}
$query='';
}
else if(!ereg("^(//|--)",$line))
{
$query .= $line;
}
}
fclose($fp);