Ejemplos de SetCreateTable en PHP

Lenguaje de programación: PHP

Método / Función: SetCreateTable

Ejemplos en hotexamples.com: 2

PHP SetCreateTable - 2 ejemplos encontrados. Estos son los ejemplos en PHP del mundo real mejor valorados de SetCreateTable extraídos de proyectos de código abierto. Puedes valorar ejemplos para ayudarnos a mejorar la calidad de los ejemplos.

Ejemplo n.º 1

Mostrar archivo

Archivo: DefaultTable.php Proyecto: novnan/meiju

//------- 建立数据表 -------
//公共表
$tablename = $dbtbpre . "ecms_" . $tbname . "_index";
$sqlindex = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\n  `id` int(10) unsigned NOT NULL auto_increment,\n  `classid` smallint(5) unsigned NOT NULL default '0',\n  `checked` tinyint(1) NOT NULL default '0',\n  `newstime` int(10) unsigned NOT NULL default '0',\n  `truetime` int(10) unsigned NOT NULL default '0',\n  `lastdotime` int(10) unsigned NOT NULL default '0',\n  `havehtml` tinyint(1) NOT NULL default '0',\n  PRIMARY KEY (`id`),\n  KEY `classid` (`classid`),\n  KEY `checked` (`checked`),\n  KEY `newstime` (`newstime`),\n  KEY `truetime` (`truetime`,`id`),\n  KEY `havehtml` (`classid`,`truetime`,`havehtml`,`checked`,`id`)\n  ) TYPE=MyISAM;", $ecms_config['db']['dbchar']));
//主表
$tablename = $dbtbpre . "ecms_" . $tbname;
$sql = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\n  `id` int(10) unsigned NOT NULL auto_increment,\n  `classid` smallint(5) unsigned NOT NULL default '0',\n  `ttid` smallint(5) unsigned NOT NULL default '0',\n  `onclick` int(10) unsigned NOT NULL default '0',\n  `plnum` mediumint(8) unsigned NOT NULL default '0',\n  `totaldown` mediumint(8) unsigned NOT NULL default '0',\n  `newspath` char(20) NOT NULL default '',\n  `filename` char(36) NOT NULL default '',\n  `userid` mediumint(8) unsigned NOT NULL default '0',\n  `username` char(20) NOT NULL default '',\n  `firsttitle` tinyint(1) NOT NULL default '0',\n  `isgood` tinyint(1) NOT NULL default '0',\n  `ispic` tinyint(1) NOT NULL default '0',\n  `istop` tinyint(1) NOT NULL default '0',\n  `isqf` tinyint(1) NOT NULL default '0',\n  `ismember` tinyint(1) NOT NULL default '0',\n  `isurl` tinyint(1) NOT NULL default '0',\n  `truetime` int(10) unsigned NOT NULL default '0',\n  `lastdotime` int(10) unsigned NOT NULL default '0',\n  `havehtml` tinyint(1) NOT NULL default '0',\n  `groupid` smallint(5) unsigned NOT NULL default '0',\n  `userfen` smallint(5) unsigned NOT NULL default '0',\n  `titlefont` char(14) NOT NULL default '',\n  `titleurl` char(200) NOT NULL default '',\n  `stb` tinyint(3) unsigned NOT NULL default '1',\n  `fstb` tinyint(3) unsigned NOT NULL default '1',\n  `restb` tinyint(3) unsigned NOT NULL default '1',\n  `keyboard` char(80) NOT NULL default '',\n  `title` char(100) NOT NULL default '',\n  `newstime` int(10) unsigned NOT NULL default '0',\n  `titlepic` char(120) NOT NULL default '',\n  PRIMARY KEY (`id`),\n  KEY `classid` (`classid`),\n  KEY `newstime` (`newstime`),\n  KEY `ttid` (`ttid`),\n  KEY `firsttitle` (`firsttitle`),\n  KEY `isgood` (`isgood`),\n  KEY `ispic` (`ispic`),\n  KEY `useridis` (`userid`,`ismember`)\n  ) TYPE=MyISAM;", $ecms_config['db']['dbchar']));
//副表
$tablename = $dbtbpre . "ecms_" . $tbname . "_data_1";
$sqldata = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\n  `id` int(10) unsigned NOT NULL default '0',\n  `classid` smallint(5) unsigned NOT NULL default '0',\n  `keyid` char(255) NOT NULL default '',\n  `dokey` tinyint(1) NOT NULL default '0',\n  `newstempid` smallint(5) unsigned NOT NULL default '0',\n  `closepl` tinyint(1) NOT NULL default '0',\n  `haveaddfen` tinyint(1) NOT NULL default '0',\n  `infotags` char(80) NOT NULL default '',\n  PRIMARY KEY (`id`),\n  KEY `classid` (`classid`)\n  ) TYPE=MyISAM;", $ecms_config['db']['dbchar']));
//采集节点附加表
$tablename = $dbtbpre . "ecms_infoclass_" . $tbname;
$infoclass = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\n  `classid` int(10) unsigned not null default '0',\n  `zz_title` text NOT NULL,\n  `z_title` varchar(255) NOT NULL default '',\n  `qz_title` varchar(255) NOT NULL default '',\n  `save_title` varchar(10) NOT NULL default '',\n  `zz_titlepic` text NOT NULL,\n  `z_titlepic` varchar(255) NOT NULL default '',\n  `qz_titlepic` varchar(255) NOT NULL default '',\n  `save_titlepic` varchar(10) NOT NULL default '',\n  `zz_newstime` text NOT NULL,\n  `z_newstime` varchar(255) NOT NULL default '',\n  `qz_newstime` varchar(255) NOT NULL default '',\n  `save_newstime` varchar(10) NOT NULL default '',\n  PRIMARY KEY (`classid`)\n  ) TYPE=MyISAM;", $ecms_config['db']['dbchar']));
//采集数据临时表
$tablename = $dbtbpre . "ecms_infotmp_" . $tbname;
$infotmp = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\n  `id` bigint(20) unsigned NOT NULL auto_increment,\n  `classid` int(10) unsigned NOT NULL default '0',\n  `oldurl` char(200) NOT NULL default '',\n  `checked` tinyint(1) NOT NULL default '0',\n  `tmptime` datetime NOT NULL default '0000-00-00 00:00:00',\n  `userid` mediumint(8) unsigned NOT NULL default '0',\n  `username` char(20) NOT NULL default '',\n  `truetime` int(10) unsigned NOT NULL default '0',\n  `keyboard` char(100) NOT NULL default '',\n  `title` char(100) NOT NULL default '',\n  `newstime` datetime NOT NULL default '0000-00-00 00:00:00',\n  `titlepic` char(120) NOT NULL default '',\n  PRIMARY KEY (`id`),\n  KEY `classid` (`classid`),\n  KEY `checked` (`checked`)\n  ) TYPE=MyISAM;", $ecms_config['db']['dbchar']));
//字段表数据
$sysfdata = ReadFiletext('../data/html/sysfhtml.txt');
$sys_selectf = 'fid,f,fname,fform,fhtml,fzs,isadd,isshow,iscj,cjhtml,myorder,ftype,flen,dotemp,tid,tbname,savetxt,fvalue,iskey,tobr,dohtml,qfhtml,isonly,linkfieldval,samedata,fformsize,tbdataf,ispage,adddofun,editdofun,qadddofun,qeditdofun,linkfieldtb,linkfieldshow,editorys,issmalltext';
$sysf_titler = explode('[!--sys.title--]', $sysfdata);
$sysf_titletr = explode('[!--sys.qf.exp--]', $sysf_titler[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'title','标题','text','" . addslashes($sysf_titletr[0]) . "','标题','0','1','1','" . addslashes($sysf_titletr[2]) . "','0','CHAR','100','1','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_titletr[1]) . "','0','','0','60','0','0','','','','','','','0','0');");
$sysf_specialr = explode('[!--sys.special.field--]', $sysfdata);
$sysf_specialtr = explode('[!--sys.qf.exp--]', $sysf_specialr[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'special.field','特殊属性','','" . addslashes($sysf_specialtr[0]) . "','特殊属性','0','1','0','" . addslashes($sysf_specialtr[2]) . "','0','','0','0','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_specialtr[1]) . "','0','','0','','0','0','','','','','','','0','0');");
$sysf_titlepicr = explode('[!--sys.titlepic--]', $sysfdata);
$sysf_titlepictr = explode('[!--sys.qf.exp--]', $sysf_titlepicr[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'titlepic','标题图片','img','" . addslashes($sysf_titlepictr[0]) . "','标题图片','0','1','1','" . addslashes($sysf_titlepictr[2]) . "','0','CHAR','120','1','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_titlepictr[1]) . "','0','','0','60','0','0','','','','','','','0','0');");
$sysf_newstimer = explode('[!--sys.newstime--]', $sysfdata);
$sysf_newstimetr = explode('[!--sys.qf.exp--]', $sysf_newstimer[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'newstime','发布时间','text','" . addslashes($sysf_newstimetr[0]) . "','发布时间','0','1','1','" . addslashes($sysf_newstimetr[2]) . "','0','INT','11','1','{$tid}','{$tbname}','0','','1','0','0','" . addslashes($sysf_newstimetr[1]) . "','0','','0','','0','0','','','','','','','0','0');");

Ejemplo n.º 2

Mostrar archivo

Archivo: DefaultTable.php Proyecto: BGCX261/zjh-dev-svn-to-git

if (!defined('InEmpireCMS')) {
    exit;
}
//建立数据表
$tablename = $dbtbpre . "ecms_" . $tbname;
$sql = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\r\n  `id` int(11) NOT NULL auto_increment,\r\n  `classid` smallint(6) NOT NULL default '0',\r\n  `onclick` int(11) NOT NULL default '0',\r\n  `newspath` char(20) NOT NULL default '',\r\n  `keyboard` char(160) NOT NULL default '',\r\n  `keyid` char(255) NOT NULL default '',\r\n  `userid` int(11) NOT NULL default '0',\r\n  `username` char(30) NOT NULL default '',\r\n  `ztid` char(255) NOT NULL default '',\r\n  `checked` tinyint(1) NOT NULL default '0',\r\n  `istop` tinyint(1) NOT NULL default '0',\r\n  `truetime` int(10) NOT NULL default '0',\r\n  `ismember` tinyint(1) NOT NULL default '0',\r\n  `dokey` tinyint(1) NOT NULL default '0',\r\n  `userfen` smallint(6) NOT NULL default '0',\r\n  `isgood` tinyint(1) NOT NULL default '0',\r\n  `titlefont` char(20) NOT NULL default '',\r\n  `titleurl` char(200) NOT NULL default '',\r\n  `filename` char(60) NOT NULL default '',\r\n  `groupid` smallint(6) NOT NULL default '0',\r\n  `newstempid` smallint(6) NOT NULL default '0',\r\n  `plnum` int(11) NOT NULL default '0',\r\n  `firsttitle` tinyint(1) NOT NULL default '0',\r\n  `isqf` tinyint(1) NOT NULL default '0',\r\n  `totaldown` int(11) NOT NULL default '0',\r\n  `title` char(200) NOT NULL default '',\r\n  `newstime` int(10) NOT NULL default '0',\r\n  `titlepic` char(200) NOT NULL default '',\r\n  `closepl` tinyint(1) NOT NULL default '0',\r\n  `havehtml` tinyint(1) NOT NULL default '0',\r\n  `lastdotime` int(10) NOT NULL default '0',\r\n  `haveaddfen` tinyint(1) NOT NULL default '0',\r\n  `infopfen` int(11) NOT NULL default '0',\r\n  `infopfennum` int(11) NOT NULL default '0',\r\n  `votenum` int(11) NOT NULL default '0',\r\n  `stb` char(4) NOT NULL default '1',\r\n  `copyids` char(255) NOT NULL default '',\r\n  `ttid` smallint(6) NOT NULL default '0',\r\n  `infotags` char(160) NOT NULL default '',\r\n  `ispic` tinyint(1) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`),\r\n  KEY `checked` (`checked`),\r\n  KEY `newstime` (`newstime`),\r\n  KEY `truetime` (`truetime`),\r\n  KEY `classid` (`classid`),\r\n  KEY `ttid` (`ttid`)\r\n  ) TYPE=MyISAM;", $phome_db_dbchar));
//副表
$tablename = $dbtbpre . "ecms_" . $tbname . "_data_1";
$sqldata = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\r\n  `id` int(11) NOT NULL default '0',\r\n  `classid` smallint(6) NOT NULL default '0',\r\n  PRIMARY KEY  (`id`),\r\n  KEY `classid` (`classid`)\r\n  ) TYPE=MyISAM;", $phome_db_dbchar));
//字段表数据
$sysfdata = ReadFiletext('../data/html/sysfhtml.txt');
$sys_selectf = 'fid,f,fname,fform,fhtml,fzs,isadd,isshow,iscj,cjhtml,myorder,ftype,flen,dotemp,tid,tbname,savetxt,fvalue,iskey,tobr,dohtml,qfhtml,isonly,linkfieldval,samedata,fformsize,tbdataf,ispage,adddofun,editdofun,qadddofun,qeditdofun,linkfieldtb,linkfieldshow,editorys,issmalltext';
$sysf_titler = explode('[!--sys.title--]', $sysfdata);
$sysf_titletr = explode('[!--sys.qf.exp--]', $sysf_titler[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'title','标题','text','" . addslashes($sysf_titletr[0]) . "','标题','0','1','1','" . addslashes($sysf_titletr[2]) . "','0','CHAR','200','1','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_titletr[1]) . "','0','','0','60','0','0','','','','','','','0','0');");
$sysf_specialr = explode('[!--sys.special.field--]', $sysfdata);
$sysf_specialtr = explode('[!--sys.qf.exp--]', $sysf_specialr[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'special.field','特殊属性','','" . addslashes($sysf_specialtr[0]) . "','特殊属性','0','1','0','" . addslashes($sysf_specialtr[2]) . "','0','','0','0','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_specialtr[1]) . "','0','','0','','0','0','','','','','','','0','0');");
$sysf_titlepicr = explode('[!--sys.titlepic--]', $sysfdata);
$sysf_titlepictr = explode('[!--sys.qf.exp--]', $sysf_titlepicr[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'titlepic','标题图片','img','" . addslashes($sysf_titlepictr[0]) . "','标题图片','0','1','1','" . addslashes($sysf_titlepictr[2]) . "','0','CHAR','200','1','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_titlepictr[1]) . "','0','','0','60','0','0','','','','','','','0','0');");
$sysf_newstimer = explode('[!--sys.newstime--]', $sysfdata);
$sysf_newstimetr = explode('[!--sys.qf.exp--]', $sysf_newstimer[1]);
$empire->query("insert into `{$dbtbpre}enewsf`({$sys_selectf}) values(NULL,'newstime','发布时间','text','" . addslashes($sysf_newstimetr[0]) . "','发布时间','0','1','1','" . addslashes($sysf_newstimetr[2]) . "','0','INT','10','1','{$tid}','{$tbname}','0','','0','0','0','" . addslashes($sysf_newstimetr[1]) . "','0','','0','','0','0','','','','','','','0','0');");
//采集节点附加表
$tablename = $dbtbpre . "ecms_infoclass_" . $tbname;
$infoclass = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\r\n  `classid` int not null default '0',\r\n  `zz_title` text NOT NULL,\r\n  `z_title` varchar(255) NOT NULL default '',\r\n  `qz_title` varchar(255) NOT NULL default '',\r\n  `save_title` varchar(10) NOT NULL default '',\r\n  `zz_titlepic` text NOT NULL,\r\n  `z_titlepic` varchar(255) NOT NULL default '',\r\n  `qz_titlepic` varchar(255) NOT NULL default '',\r\n  `save_titlepic` varchar(10) NOT NULL default '',\r\n  `zz_newstime` text NOT NULL,\r\n  `z_newstime` varchar(255) NOT NULL default '',\r\n  `qz_newstime` varchar(255) NOT NULL default '',\r\n  `save_newstime` varchar(10) NOT NULL default '',\r\n   KEY `classid` (`classid`)\r\n  ) TYPE=MyISAM;", $phome_db_dbchar));
//采集数据临时表
$tablename = $dbtbpre . "ecms_infotmp_" . $tbname;
$infotmp = $empire->query(SetCreateTable("CREATE TABLE `" . $tablename . "` (\r\n  `id` bigint(20) NOT NULL auto_increment,\r\n  `classid` int NOT NULL default '0',\r\n  `oldurl` varchar(255) NOT NULL default '',\r\n  `checked` tinyint(1) NOT NULL default '0',\r\n  `tmptime` datetime NOT NULL default '0000-00-00 00:00:00',\r\n  `title` varchar(200) NOT NULL default '',\r\n  `newstime` datetime NOT NULL default '0000-00-00 00:00:00',\r\n  `username` varchar(30) NOT NULL default '',\r\n  `userid` int(11) NOT NULL default '0',\r\n  `truetime` int(11) NOT NULL default '0',\r\n  `keyboard` varchar(255) NOT NULL default '',\r\n  `titlepic` varchar(200) NOT NULL default '',\r\n  PRIMARY KEY  (`id`),\r\n  KEY `classid` (`classid`)\r\n  ) TYPE=MyISAM;", $phome_db_dbchar));