connect() public method

Connect to the database.
public connect ( string $host, string $database, string $username, string $password, boolean $utf8 = true )
$host string
$database string
$username string
$password string
$utf8 boolean
Kimai_Database_Mysql Class Documentation
Exemplo n.º 1
0
        write_config_file($database, $hostname, $username, $password, $db_layer, $db_type, $prefix, $lang, $salt, $timezone);
        break;
        /**
         * Create the database.
         */
    /**
     * Create the database.
     */
    case "make_database":
        $databaseName = $_REQUEST['database'];
        $hostname = $_REQUEST['hostname'];
        $username = $_REQUEST['username'];
        $password = $_REQUEST['password'];
        $server_type = $_REQUEST['db_type'];
        $db_layer = $_REQUEST['db_layer'];
        $db_error = false;
        $result = false;
        $database = new Kimai_Database_Mysql($result);
        $database->connect($hostname, null, $username, $password, true, $server_type);
        $conn = $database->getConnectionHandler();
        $query = "CREATE DATABASE `" . $databaseName . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci";
        $result = $conn->Query($query);
        if ($result !== false) {
            echo "1";
            // <-- hat geklappt
        } else {
            echo "0";
            // <-- schief gegangen
        }
        break;
}
Exemplo n.º 2
0
    if (isset($_COOKIE['kimai_db']) && $_COOKIE['kimai_db'] == true) {
        $dbnr = $_COOKIE['kimai_db'] - 1;
        $kga['server_database'] = $server_ext_database[$dbnr];
        if ($server_ext_username[$dbnr] != '') {
            $kga['server_username'] = $server_ext_username[$dbnr];
        }
        if ($server_ext_password[$dbnr] != '') {
            $kga['server_password'] = $server_ext_password[$dbnr];
        }
        if ($server_ext_prefix[$dbnr] != '') {
            $kga['server_prefix'] = $server_ext_prefix[$dbnr];
        }
    }
}
$database = new Kimai_Database_Mysql($kga);
$database->connect($kga['server_hostname'], $kga['server_database'], $kga['server_username'], $kga['server_password'], $kga['utf8'], $kga['server_type']);
if (!$database->isConnected()) {
    die('Kimai could not connect to database. Check your autoconf.php.');
}
Kimai_Registry::setDatabase($database);
global $translations;
$translations = new Translations($kga);
if ($kga['language'] != 'en') {
    $translations->load($kga['language']);
}
$vars = $database->configuration_get_data();
if (!empty($vars)) {
    $kga['currency_name'] = $vars['currency_name'];
    $kga['currency_sign'] = $vars['currency_sign'];
    $kga['show_sensible_data'] = $vars['show_sensible_data'];
    $kga['show_update_warn'] = $vars['show_update_warn'];