예제 #1
0
파일: setup1.php 프로젝트: ttym7993/Linger
<?php

c_lib()->load('sql', 'char');
$sql = new \CLib\Sql(cfg()->get('sql', 'write'), cfg()->get('sql', 'read'));
$status = $sql->status();
$next = true;
if (include_once __DIR__ . "/check_system.php") {
    ?>
	<h2>第一步,配置数据库</h2>

	<?php 
    if ($status) {
        echo "<p class='well well-sm text-success'>" . (cfg()->get('sql', 'read') !== NULL ? "[Read]" : "") . "数据库已连接,请继续下一步。</p>";
    } else {
        $next = false;
        $err = $sql->ex_message();
        $err = \CLib\Char::Convert(\CLib\Char::GetCoding($err), "UTF-8", $err);
        echo "<p class='well text-danger'>" . (cfg()->get('sql', 'read') !== NULL ? "[Read]" : "") . "数据库连接失败,请检查配置文件,手动修改对应属性,请优先保证写数据库正常!<br />错误信息:{$err}</p>";
    }
    if (cfg()->get('sql', 'read') !== NULL) {
        if (!$sql->open_write()) {
            $next = false;
            $err = $sql->ex_message();
            $err = \CLib\Char::Convert(\CLib\Char::GetCoding($err), "UTF-8", $err);
            echo "<p class='well text-danger'>[Write]写数据库异常,请保证写数据库能正常连接!<br>错误信息:{$err}</p>";
        } else {
            echo "<p class='well well-sm text-success'>[Write]数据库已连接,请继续下一步。</p>";
        }
    }
    if ($next) {
        $session->set('install', ['number' => '2', 'list' => []]);
예제 #2
0
<?php

c_lib()->load('sql');
$sql = new \CLib\Sql(cfg()->get('sql', 'write'), cfg()->get('sql', 'read'));
$write = $sql->getWriter();
if (!is_object($write)) {
    die("数据库连接失败");
}
$database_name = cfg()->get('sql', 'write', 'database_name');
//header("Content-Type: text/plain; charset=utf-8");
//创建表操作
$sql_file = file_get_contents(__DIR__ . "/table.sql");
$list = preg_split("/-- [-]+/", $sql_file);
foreach ($list as $v) {
    $v = trim($v);
    if (!isset($v[0]) || $v[0] == '-') {
        continue;
    }
    $write->pdo->exec($v);
    error_check($write->pdo);
}
error_check($write->pdo);
//创建存储过程操作
$sql_file = file_get_contents(__DIR__ . "/procedure.sql");
$sql_file = str_replace("`{database_name}`", "`{$database_name}`", $sql_file);
$list = preg_split("/-- [-]+/", $sql_file);
foreach ($list as $v) {
    $v = trim($v);
    if (!isset($v[0]) || $v[0] == '-') {
        continue;
    }