PHP网站安装程序的原理及代码
发布时间：2023-02-16 12:46:35 所属栏目：PHP 来源：互联网
导读：具体代码： 文件：由于只是展示原理，尽量让其简单化故用小Demo形式演示 install.html为表单填写文件 doAction.PHP 为处理表单文件 dbconfig.PHP 数据库配置文件 index.PHP执行成功跳转页面 install.html !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transi
|
}else{ MysqL_query("create database if not exists `$dbname`"); MysqL_select_db($dbname,$link); //建表语句 $sql[]="CREATE TABLE IF NOT EXISTS `".$flag."access` ( `role_id` smallint(6) unsigned NOT NULL, `node_id` smallint(6) unsigned NOT NULL, `level` tinyint(1) NOT NULL, `module` varchar(50) DEFAULT NULL, KEY `groupId` (`role_id`), KEY `nodeId` (`node_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $sql[]="CREATE TABLE IF NOT EXISTS `".$flag."node` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `title` varchar(50) DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `remark` varchar(255) DEFAULT NULL, `sort` smallint(6) unsigned DEFAULT NULL, `pid` smallint(6) unsigned NOT NULL, `level` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `level` (`level`), KEY `pid` (`pid`), KEY `status` (`status`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $sql[]="CREATE TABLE IF NOT EXISTS `".$flag."role` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `pid` smallint(6) DEFAULT NULL, `status` tinyint(1) unsigned DEFAULT NULL, KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $sql[]="CREATE TABLE IF NOT EXISTS `".$flag."role_user` ( `role_id` mediumint(9) unsigned DEFAULT NULL, `user_id` char(32) DEFAULT NULL, KEY `group_id` (`role_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; foreach ($sql as $value) {//由于MysqL_query不支持一次性执行多条语句，所以用for循环遍历 MysqL_query($value); } echo "<script>window.location='index.PHP';</script>"; rename("install.html","install.lock"); } }else{ echo "您没有权限操作。"; } ?> dbconfig.PHP <?PHP $host="localhost"; $user="root"; $pass=""; $dbname="demo"; $flag="lcw_"; （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
