diff --git a/setup/index.php b/setup/index.php --- a/setup/index.php +++ b/setup/index.php @@ -1,52 +1,52 @@ - 'mysql:host=localhost;', - 'config' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'), - 'username' => 'root', - 'password' => '', -); - -require_once '../config/config.php'; - -use bfw\database\Database; - -$db = Database::getInstance($cfg); - -$dropSQLStatements = array( - "DROP USER 'bfw'@'localhost'", - "DROP DATABASE IF EXISTS bfw;", -); - -$createSQLStatements = array( - "CREATE DATABASE bfw CHARACTER SET utf8 COLLATE utf8_unicode_ci;", - "CREATE USER 'bfw'@'localhost' IDENTIFIED BY 'bfw';", - "GRANT ALL PRIVILEGES ON bfw.* TO 'bfw'@'localhost' WITH GRANT OPTION;", -); - -foreach ($dropSQLStatements as $statement) { - $status = $db->execute($statement); - echo sprintf("%s\n", $statement); -} - -foreach ($createSQLStatements as $statement) { - $status = $db->execute($statement); - echo sprintf("%s\n", $statement); -} - -$handle = fopen(BFW_PATH . '/sql/init.sql', 'r'); - -$sql = "USE bfw;\n\n"; -while (!feof($handle)) { - $sql .= fgets($handle); -} - -fclose($handle); - -if ($db->execute($sql) == 0) { - echo sprintf("%s", $sql); - - header('Location: /'); -} + 'mysql:host=localhost;', + 'config' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'), + 'username' => 'root', + 'password' => '', +); + +require_once '../config/config.php'; + +use bfw\database\Database; + +$db = Database::getInstance($cfg); + +$dropSQLStatements = array( + "DROP USER 'bfw'@'localhost'", + "DROP DATABASE IF EXISTS bfw;", +); + +$createSQLStatements = array( + "CREATE DATABASE bfw CHARACTER SET utf8 COLLATE utf8_unicode_ci;", + "CREATE USER 'bfw'@'localhost' IDENTIFIED BY 'bfw';", + "GRANT ALL PRIVILEGES ON bfw.* TO 'bfw'@'localhost' WITH GRANT OPTION;", +); + +foreach ($dropSQLStatements as $statement) { + $status = $db->execute($statement); + echo sprintf("%s\n", $statement); +} + +foreach ($createSQLStatements as $statement) { + $status = $db->execute($statement); + echo sprintf("%s\n", $statement); +} + +$handle = fopen(BFW_PATH . '/sql/init.sql', 'r'); + +$sql = "USE bfw;\n\n"; +while (!feof($handle)) { + $sql .= fgets($handle); +} + +fclose($handle); + +if ($db->execute($sql) == 0) { + echo sprintf("%s", $sql); + + header('Location: /'); +}