简易php博客(1)_安装

最新推荐文章于 2021-03-23 08:17:05 发布

shareinfo2018

最新推荐文章于 2021-03-23 08:17:05 发布

阅读量919

点赞数

分类专栏： web

本文链接：https://blog.csdn.net/chenyefei/article/details/51685738

版权

web 专栏收录该内容

26 篇文章 1 订阅

订阅专栏

install.php

<?php
echo <<<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="" οnblur="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" οnclick="return checkinput()"  οnmοuseοver="this.className='but_over'" οnmοuseοut="this.className='but_out'">
            </td>
        </tr>
	</table>
</form>
HTML;
include("foot.php"); 

?>

config.php

<?php
define('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

<?php
define('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;}

效果：

shareinfo2018

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
简易php博客(1)_安装

install.php<?phpecho <<<HTML简易blog后台测试 function checkinput(){ var pwd = document.getElementById("mng_pwd").value; var pwd1 = document.getElementById("mng_pwd1").value; var disp = d
复制链接

扫一扫