<?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' => []]);
<?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; }