neiyou_user_web/public/install.php

<?php
/**
 *ProxyPanel安装程序
 *
 * 安装完成后建议删除此文件
 *
 * @author Heron
 */

// error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
// ini_set('display_errors', '1');
// 定义目录分隔符
define('DS', DIRECTORY_SEPARATOR);

// 定义根目录
define('ROOT_PATH', __DIR__.DS.'..'.DS);

// 定义应用目录
define('APP_PATH', ROOT_PATH.'app'.DS);

// 安装包目录
define('INSTALL_PATH', ROOT_PATH.'sql'.DS);

// 判断文件或目录是否有写的权限
function is_really_writable($file) {
	if(DIRECTORY_SEPARATOR == '/' and @ ini_get("safe_mode") == false){
		return is_writable($file);
	}

	if(!is_file($file) or ($fp = @fopen($file, "r+")) === false){
		return false;
	}

	fclose($fp);

	return true;
}

// 写配置文件
function write_ini_file($assoc_arr, $path, $has_sections = false) {
	$content = "";
	if($has_sections){
		foreach($assoc_arr as $key => $elem){
			$content .= "[".$key."]\n";
			foreach($elem as $key2 => $elem2){
				if(is_array($elem2)){
					for($i = 0; $i < count($elem2); $i++){
						$content .= $key2."[] = \"".$elem2[$i]."\"\n";
					}
				}elseif($elem2 == ""){
					$content .= $key2." = \n";
				}else{
					$content .= $key2." = \"".$elem2."\"\n";
				}
			}
		}
	}else{
		foreach($assoc_arr as $key => $elem){
			if(is_array($elem)){
				for($i = 0; $i < count($elem); $i++){
					$content .= $key."[] = \"".$elem[$i]."\"\n";
				}
			}elseif($elem == ""){
				$content .= $key." = \n";
			}else{
				$content .= $key." = \"".$elem."\"\n";
			}
		}
	}

	if(!$handle = fopen($path, 'w')){
		return false;
	}

	if(!fwrite($handle, $content)){
		return false;
	}

	fclose($handle);

	return true;
}

$sitename = "OtakuCloud";

// 检测目录是否存在
$checkDirs = [
	'vendor',
];

// 错误信息
$errInfo = '';

// 数据库配置文件
$ConfigFile = ROOT_PATH.'.env';

// 数据库标准配置文件
$exampleConfigFile = ROOT_PATH.'.env.example';

// 锁定的文件
$lockFile = ROOT_PATH.'.env';
if(is_file($lockFile)){
	$errInfo = "当前已经安装{$sitename}，如果需要重新安装，请手动移除.env文件";
}elseif(version_compare(PHP_VERSION, '7.1.3', '<')){
	$errInfo = "当前PHP版本(".PHP_VERSION.")过低，请使用PHP7.1.3及以上版本";
}elseif(!is_file($exampleConfigFile)){
	$errInfo = "缺失标准配置文件.env.example";
}elseif(!extension_loaded("PDO")){
	$errInfo = "当前PHP环境未启用PDO组件，无法进行安装";
}elseif(!is_really_writable(ROOT_PATH)){
	$open_basedir = ini_get('open_basedir');
	if($open_basedir){
		$dirArr = explode(PATH_SEPARATOR, $open_basedir);
		if($dirArr && in_array(__DIR__, $dirArr)){
			$errInfo = '当前服务器因配置了open_basedir，导致无法读取应用根目录';
		}
	}

	if(!$errInfo){
		$errInfo = '权限不足，无法写入配置文件.env';
	}
}else{
	$dirArr = [];
	foreach($checkDirs as $k => $v){
		if(!is_dir(ROOT_PATH.$v)){
			$errInfo = '请先在'.$sitename.'根目录下执行 php composer.phar install 安装依赖';
			break;
		}
	}
}

// 当前是POST请求
if(isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD'] == 'POST'){
	if($errInfo){
		echo $errInfo;
		exit;
	}

	$err = '';
	$APP_KEY = md5(time().mt_rand(1, 1000000));
	$DB_HOST = isset($_POST['mysqlHost'])? $_POST['mysqlHost'] : '127.0.0.1';
	$DB_PORT = isset($_POST['mysqlHostport'])? $_POST['mysqlHostport'] : 3306;
	$hostArr = explode(':', $DB_HOST);
	if(count($hostArr) > 1){
		$DB_HOST = $hostArr[0];
		$DB_PORT = $hostArr[1];
	}
	$DB_USERNAME = isset($_POST['mysqlUsername'])? $_POST['mysqlUsername'] : 'root';
	$DB_PASSWORD = isset($_POST['mysqlPassword'])? $_POST['mysqlPassword'] : '';
	$DB_DATABASE = isset($_POST['mysqlDatabase'])? $_POST['mysqlDatabase'] : 'proxypanel';
	//    $adminUsername = isset($_POST['adminUsername']) ? $_POST['adminUsername'] : 'admin';
	//    $adminPassword = isset($_POST['adminPassword']) ? $_POST['adminPassword'] : 'admin';
	//    $adminPasswordConfirmation = isset($_POST['adminPasswordConfirmation']) ? $_POST['adminPasswordConfirmation'] : 'admin';
	//    $adminEmail = isset($_POST['adminEmail']) ? $_POST['adminEmail'] : 'admin@admin.com';
	//    if ($adminPassword !== $adminPasswordConfirmation) {
	//        echo "两次输入的密码不一致";
	//        exit;
	//    } else if (!preg_match("/^\w+$/", $adminUsername)) {
	//        echo "用户名只能输入字母、数字、下划线";
	//        exit;
	//    } else if (!preg_match("/^[\S]+$/", $adminPassword)) {
	//        echo "密码不能包含空格";
	//        exit;
	//    } else if (strlen($adminUsername) < 3 || strlen($adminUsername) > 12) {
	//        echo "用户名请输入3~12位字符";
	//        exit;
	//    } else if (strlen($adminPassword) < 6 || strlen($adminPassword) > 16 || stripos($adminPassword, ' ') !== false) {
	//        echo "密码请输入6~16位字符,不能包含空格";
	//        exit;
	//    }
	try{
		// 检测能否读取安装文件
		$sql = @file_get_contents(INSTALL_PATH.'db.sql');
		if(!$sql){
			throw new Exception("无法读取所需的sql/db.sql，请检查是否有读权限");
		}

		$pdo = new PDO("mysql:host={$DB_HOST};port={$DB_PORT}", $DB_USERNAME, $DB_PASSWORD, [
			PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
			PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
		]);

		// 检测是否支持innodb存储引擎
		$pdoStatement = $pdo->query("SHOW VARIABLES LIKE 'innodb_version'");
		$result = $pdoStatement->fetch();
		if(!$result){
			throw new Exception("当前数据库不支持innodb存储引擎，请开启后再重新尝试安装");
		}

		$pdo->query("CREATE DATABASE IF NOT EXISTS `{$DB_DATABASE}` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;");
		$pdo->query("USE `{$DB_DATABASE}`");
		$pdo->exec($sql);

		$config = @file_get_contents($exampleConfigFile);
		if(!$config){
			throw new Exception("无法写入读取配置.env.example文件，请检查是否有读权限");
		}

		$callback = function($matches) use ($APP_KEY, $DB_HOST, $DB_PORT, $DB_USERNAME, $DB_PASSWORD, $DB_DATABASE) {
			$field = $matches[1];
			$replace = ${"{$field}"};
			return "{$matches[1]}={$replace}".PHP_EOL;
		};

		$config = preg_replace_callback("/(APP_KEY|DB_HOST|DB_DATABASE|DB_USERNAME|DB_PASSWORD|DB_PORT)=(.*)(\s+)/",
			$callback, $config);

		// 检测能否成功写入数据库配置
		$result = @file_put_contents($ConfigFile, $config);
		if(!$result){
			throw new Exception("无法写入数据库信息到.env文件，请检查是否有写权限");
		}

		echo "success";
	}catch(PDOException $e){
		$err = $e->getMessage();
	}catch(Exception $e){
		$err = $e->getMessage();
	}

	echo $err;
	exit;
}
?>
<!doctype html>
<html>
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<title>安装<?php
		echo $sitename; ?></title>
	<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1">
	<meta name="renderer" content="webkit">

	<style type="text/css">
		body {
			background: #5c97bd;
			margin: 0;
			padding: 0;
			line-height: 1.5;
		}

		body, input, button {
			font-family: 'Open Sans', sans-serif;
			font-size: 16px;
			color: #fff;
		}

		.container {
			max-width: 515px;
			margin: 0 auto;
			padding: 20px;
			text-align: center;
		}

		a {
			color: #fff7d0;
			text-decoration: none;
		}

		a:hover {
			text-decoration: underline;
		}

		h1 {
			margin-top: 0;
			margin-bottom: 10px;
		}

		h2 {
			font-size: 28px;
			font-weight: normal;
			color: #fff;
			margin-bottom: 0;
		}

		form {
			margin-top: 40px;
		}

		.form-group {
			margin-bottom: 20px;
		}

		.form-group .form-field:first-child input {
			border-top-left-radius: 4px;
			border-top-right-radius: 4px;
		}

		.form-group .form-field:last-child input {
			border-bottom-left-radius: 4px;
			border-bottom-right-radius: 4px;
		}

		.form-field input {
			background: #6ba3c8;
			margin: 0 0 1px;
			border: 2px solid transparent;
			transition: background 0.2s, border-color 0.2s, color 0.2s;
			width: 100%;
			padding: 15px 15px 15px 180px;
			box-sizing: border-box;
		}

		.form-field input:focus {
			border-color: #e8f6ff;
			outline: none;
		}

		.form-field label {
			float: left;
			width: 160px;
			text-align: right;
			margin-right: -160px;
			position: relative;
			margin-top: 18px;
			font-size: 14px;
			pointer-events: none;
			opacity: 0.7;
		}

		button, .btn {
			background: #fff;
			color: #6ba3ca;
			border: 0;
			font-weight: bold;
			border-radius: 4px;
			cursor: pointer;
			padding: 15px 30px;
			-webkit-appearance: none;
		}

		button[disabled] {
			opacity: 0.5;
		}

		#error, .error, #success, .success {
			background: #d66c6c;
			color: #fff;
			padding: 15px 20px;
			border-radius: 4px;
			margin-bottom: 20px;
		}

		#success {
			background: #3C5675;
		}

		#error a, .error a {
			color: white;
			text-decoration: underline;
		}
	</style>
</head>

<body>
<div class="container">
	<h2>安装 <?php
		echo $sitename; ?></h2>
	<div>
		<form method="post">
			<?php
			if($errInfo): ?>
				<div class="error">
					<?php
					echo $errInfo; ?>
				</div>
			<?php
			endif; ?>
			<div id="error" style="display:none"></div>
			<div id="success" style="display:none"></div>

			<div class="form-group">
				<div class="form-field">
					<label>MySQL 数据库地址</label>
					<input type="text" name="mysqlHost" value="127.0.0.1" required="">
				</div>

				<div class="form-field">
					<label>MySQL 数据库名</label>
					<input type="text" name="mysqlDatabase" value="proxypanel" required="">
				</div>

				<div class="form-field">
					<label>MySQL 用户名</label>
					<input type="text" name="mysqlUsername" value="proxypanel" required="">
				</div>

				<div class="form-field">
					<label>MySQL 密码</label>
					<input type="password" name="mysqlPassword">
				</div>

				<div class="form-field">
					<label>MySQL 端口号</label>
					<input type="number" name="mysqlHostport" value="3306">
				</div>
			</div>

			<!--            <div class="form-group">-->
			<!--                <div class="form-field">-->
			<!--                    <label>管理者用户名</label>-->
			<!--                    <input name="adminUsername" value="admin" required=""/>-->
			<!--                </div>-->
			<!---->
			<!--                <div class="form-field">-->
			<!--                    <label>管理者Email</label>-->
			<!--                    <input name="adminEmail" value="admin@admin.com" required="">-->
			<!--                </div>-->
			<!---->
			<!--                <div class="form-field">-->
			<!--                    <label>管理者密码</label>-->
			<!--                    <input type="password" name="adminPassword" required="">-->
			<!--                </div>-->
			<!---->
			<!--                <div class="form-field">-->
			<!--                    <label>重复密码</label>-->
			<!--                    <input type="password" name="adminPasswordConfirmation" required="">-->
			<!--                </div>-->
			<!--            </div>-->

			<div class="form-buttons">
				<button type="submit" <?php
				echo $errInfo? 'disabled' : '' ?>>点击安装
				</button>
			</div>
		</form>

		<!-- jQuery -->
		<script src="//cdn.staticfile.org/jquery/2.1.4/jquery.min.js" type="text/javascript"></script>

		<script type="text/javascript">
			$(function () {

				$('form').on('submit', function (e) {
					e.preventDefault();

					var $button = $(this).find('button')
						.text('安装中...')
						.prop('disabled', true);

					$.post('', $(this).serialize())
						.done(function (ret) {
							if (ret === 'success') {
								$('#error').hide();
								$("#success").text("<?php echo $sitename; ?>安装成功，请使用默认用户名test@test.com、密码123456登录，并尽快修改密码并重置订阅地址。").show();
								$('<a class="btn" href="./">进入ProxyPanel</a>').insertAfter($button);
								$button.remove();
								localStorage.setItem("fastep", "installed");
							} else {
								$('#error').show().text(ret);
								$button.prop('disabled', false).text('点击安装');
								$("html,body").animate({
									scrollTop: 0
								}, 500);
							}
						})
						.fail(function (data) {
							$('#error').show().text('发生错误:\n\n' + data.responseText);
							$button.prop('disabled', false).text('点击安装');
							$("html,body").animate({
								scrollTop: 0
							}, 500);
						});

					return false;
				});
			});
		</script>
	</div>
</div>
</body>
</html>