简易php博客(1)_安装

来源：互联网发布：2016公测的网络端游编辑：程序博客网时间：2024/05/16 01:17

install.php

<?phpecho <<<HTML<html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>简易blog后台测试</title><link rel=stylesheet type="text/css" href="./css/css.css"><script type="text/javascript">    function checkinput(){var pwd = document.getElementById("mng_pwd").value;var pwd1 = document.getElementById("mng_pwd1").value;var disp = document.getElementById("tips");        if( pwd != pwd1){            disp.innerHTML = '<span style="color:red;font-size:12px;"> 输入密码不一致</span>';            return false;        }        disp.innerHTML = '<span class="care"> 密码一致</span>';        return true;    }function initPwdCompare() {var element = document.getElementById("mng_pwd1");element.addEventListener("input", function(){if (element.value) checkinput();}, false);}</script></head><body><div id="main"><p class="title">MySql install</p>HTML;if (!empty($_POST['sub'])){$host = $_POST['hostname'];$user = $_POST['user'];$pwd = $_POST['pwd'];$dbname = $_POST['dbname'];$tbname = $_POST['tbname'];$mngUsr = $_POST['mng_usr'];$mngPwd = $_POST['mng_pwd'];@mysql_connect($host,$user,$pwd) or die("mysql数据库连接失败");@mysql_query("drop database if exists $dbname")or die("删除数据库失败");@mysql_query("create database $dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci")or die("创建数据库失败");@mysql_query("use $dbname")or die("切换数据库失败");    @mysql_query("set names utf8")or die("设置编码失败");@mysql_query("create table manage(id int(5) auto_increment primary key,usr char(16),pwd char(16))")or die("创建数据表1失败");    @mysql_query("create table comment(id int(5) auto_increment primary key,newsid int(11),usr char(16),email char(16),content text, ctime DateTime)")or die("创建数据表2失败");    @mysql_query("create table $tbname(id int(5) auto_increment primary key,hits int(15),title varchar(30),time DateTime,contents text)")or die("创建数据表3失败");@mysql_query("insert into manage (usr,pwd)values('$mngUsr','$mngPwd')")or die("写入数据表1失败");    @mysql_query("insert into comment (newsid,usr,email,content,ctime)values(1,'test', '123123123@qq.com','评论测试测试评论', now())")or die("写入数据表2失败");    @mysql_query("insert into comment (newsid,usr,email,content,ctime)values(1,'test', '123123123@qq.com','评论测试123123', now())")or die("写入数据表2失败");    @mysql_query("insert into $tbname (hits,title,time,contents)values(0,'fisrt_test',now(),'abcdef1234567890中英文测试')")or die("写入数据表3失败");echo "<h1>安装成功</h1>";$config = "<?php\n"    ."define('DB_HOST','$host');\n"    ."define('DB_USR','$user');\n"    ."define('DB_PWD','$pwd');\n"    ."define('DB_DBNAME','$dbname');\n"    ."define('DB_TBNAME','$tbname');\n"    ."\n";    $fp = @fopen('config.php', 'w');    $fw = @fwrite($fp, $config);fclose($fp);if (!$fw){    echo '<p>写入配置失败<a href="javascript:history.back(-1);">«点击返回</a></p>';    }else{echo '<p>写入配置成功<a href="javascript:history.back(-1);">«点击返回</a>|<a href="index.php">进入blog</a></p>';}    exit;}echo <<<HTML<form action="install.php" method="post" ><table align="center">        <tr>            <td class="lbl">数据库地址:</td>            <td><input type="text" class="input" id="hostname" name="hostname" value="127.0.0.1:3306" >            <span id="hostnametips" class="care"> (数据库链接地址)</span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">数据库用户名:</td>            <td><input type="text" class="input" id="user" name="user" value="root" >            <span id="usertips" class="care"> (数据库用户名)</span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">数据库密码:</td>            <td><input type="text" class="input" id="pwd" name="pwd" value="root" >            <span id="pwdtips" class="care"> (数据库用户密码)</span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">数据库名称:</td>            <td><input type="text"class="input"  id="dbname" name="dbname" value="dbblogadmin" >            <span id="dbnametips" class="care"> (数据库名称)</span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">表名称:</td>            <td><input type="text" class="input" id="tbname" name="tbname" value="tbblog" >            <span id="tbnametips" class="care"> (数据库中创建表名)</span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">后台用户名:</td>            <td><input type="text"class="input" id="mng_usr"  name="mng_usr" value="admin" >            <span id="mng_usrtips" class="care"> </span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">后台密码:</td>            <td><input type="password"  class="input" id="mng_pwd" name="mng_pwd" value="" onblur="return checkinput()" />            <span id="mng_pwdtips" class="care"> </span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td class="lbl">再次确认密码:</td>            <td><input type="password" class="input" id="mng_pwd1" name="mng_pwd1" value=""  /><script type="text/javascript">   initPwdCompare();  </script>            <span id="tips" class="care"> </span></td>        </tr>        <tr><td colspan="2"> </td> </tr>        <tr>            <td colspan="2" align="center">                <input type="submit" class="but_out" name="sub" value="install" onclick="return checkinput()"  onmouseover="this.className='but_over'" onmouseout="this.className='but_out'">            </td>        </tr></table></form>HTML;include("foot.php"); ?>

config.php

<?phpdefine('DB_HOST','127.0.0.1:3306');define('DB_USR','root');define('DB_PWD','root');define('DB_DBNAME','dbblogadmin');define('DB_TBNAME','tbblog');

connect.php

<?phpdefine('TEST_ROOT', dirname(__FILE__));require_once TEST_ROOT.'/config.php';@mysql_connect(DB_HOST,DB_USR,DB_PWD) or die("mysql数据库连接失败");@mysql_select_db(DB_DBNAME)or die("db连接失败");@mysql_query("set names 'gbk'")or die("设置失败");?>

css

@charset "utf-8";/* CSS Document */a{text-decoration:none;padding:5px;}a:link,a:visited{    text-decoration:none;  /*超链接无下划线*/}a:hover{    text-decoration:none;  /*鼠标放上去有下划线*/}body {background-color:#F7F7F7;font-family: Arial;font-size: 12px;line-height:150%;}#main {background-color:#FFFFFF;font-size: 12px;color: #666666;width:750px;margin:30px auto 0px;padding:10px;list-style:none;border:#DFDFDF 1px solid; border-radius: 4px;}.title{text-align:center;font-size:28px;color:#666666;border-bottom: #CCCCCC 1px solid; margin:50px 0px 30px 0px;padding:20px 0px;}.input {border: 1px solid #CCCCCC;font-family: Arial;font-size: 18px;height:28px;background-color:#F7F7F7;color: #666666;margin:0px 0px 0px 25px;}.submit{cursor: pointer;font-size: 12px;padding: 4px 10px;}.lbl{color:#333333;font-size: 18px; width: 130px; text-align: right; height: 30px;}.care{color:#666666;font-size: 10px;}.foot{text-align:center;}#main li{ margin:20px 0px;}.button{font-size:12px; width:500px; height:23px; border:none;}.but_out{background-color:#066; color:#fff; border:none; width:100px; height:30px; cursor:pointer;}.but_over{background-color:#f60; color:#fff; border:none; width:100px; height:30px; cursor:pointer;}.login{height: 100%; width: 100%; border-style: none;}#editor {resize:vertical; overflow:auto; border:1px solid silver; border-radius:5px; min-height:200px; box-shadow: inset 0 0 10px silver; padding:1em;}

效果：

0 0