PHP xtc_db_connect_installerの例

コード例 #1

ファイル: install_database.php プロジェクト: shophelfer/shophelfer.com-shop

<?php

require 'includes/application.php';
require_once DIR_FS_CATALOG . '/includes/database_tables.php';
require_once DIR_FS_INC . 'xtc_db_connect.inc.php';
require_once DIR_FS_INC . 'xtc_db_query.inc.php';
// include needed functions
require_once DIR_FS_INC . 'xtc_redirect.inc.php';
require_once DIR_FS_INC . 'xtc_href_link.inc.php';
include 'language/' . $lang . '.php';
$inst_db = trim(stripslashes($_GET['inst_db']));
$config = trim(stripslashes($_GET['config']));
if (isset($inst_db) && $inst_db == 1) {
    $db_link = xtc_db_connect_installer($_SESSION['db']['DB_SERVER'], $_SESSION['db']['DB_SERVER_USERNAME'], $_SESSION['db']['DB_SERVER_PASSWORD'], $_SESSION['db']['DB_DATABASE']);
    $sql = 'ALTER DATABASE `' . $_SESSION['db']['DB_DATABASE'] . '` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;';
    xtc_db_query($sql);
    $sql = 'SET NAMES utf8 COLLATE utf8_general_ci;';
    xtc_db_query($sql);
    $db_error = false;
    $sql_file = DIR_FS_CATALOG . DIR_SHOPHELFER_INSTALLER . '/' . SHOPHELFER_SQL;
    xtc_db_install($_SESSION['db']['DB_DATABASE'], $sql_file);
}
if (isset($config) && $config == 1) {
    //create  includes/configure.php
    include 'includes/templates/configure.php';
    $fp = fopen(DIR_FS_CATALOG . 'includes/configure.php', 'w');
    fputs($fp, $file_contents);
    fclose($fp);
    //create  admin/includes/configure.php
    include 'includes/templates/configure_admin.php';
    $fp = fopen(DIR_FS_CATALOG . 'admin/includes/configure.php', 'w');

コード例 #2

ファイル: install_database_step.php プロジェクト: shophelfer/shophelfer.com-shop

$dir_ws_www_root = implode('/', $dir_ws_www_root);
unset($_SESSION['db']);
unset($_SESSION['configure']);
$_SESSION['db'] = array();
$_SESSION['configure'] = array();
if (isset($_GET['process']) && $_GET['process'] == 'true') {
    //connect to database
    $db = array();
    $db['DB_SERVER'] = trim(stripslashes($_POST['DB_SERVER']));
    $db['DB_SERVER_USERNAME'] = trim(stripslashes($_POST['DB_SERVER_USERNAME']));
    $db['DB_SERVER_PASSWORD'] = trim(stripslashes($_POST['DB_SERVER_PASSWORD']));
    $db['DB_DATABASE'] = trim(stripslashes($_POST['DB_DATABASE']));
    $db_error = false;
    $db_warning = '';
    if (isset($db['DB_SERVER']) && !empty($db['DB_SERVER']) && isset($db['DB_SERVER_USERNAME']) && !empty($db['DB_SERVER_USERNAME']) && isset($db['DB_SERVER_PASSWORD']) && !empty($db['DB_SERVER_PASSWORD']) && isset($db['DB_DATABASE']) && !empty($db['DB_DATABASE'])) {
        $conn = xtc_db_connect_installer($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD'], $db['DB_DATABASE']);
        if ($conn) {
            $sql = 'ALTER DATABASE ' . $db['DB_DATABASE'] . ' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;';
            @mysqli_query($sql);
            $sql = 'SET NAMES utf8 COLLATE utf8_general_ci;';
            @mysqli_query($sql);
            $_SESSION['db']['DB_SERVER'] = $db['DB_SERVER'];
            $_SESSION['db']['DB_SERVER_USERNAME'] = $db['DB_SERVER_USERNAME'];
            $_SESSION['db']['DB_SERVER_PASSWORD'] = $db['DB_SERVER_PASSWORD'];
            $_SESSION['db']['DB_DATABASE'] = $db['DB_DATABASE'];
        } else {
            $db_error = true;
            $db_warning = '<strong>' . TEXT_DB_DATA_NOT_CORRECT . '</strong>';
        }
    } else {
        $db_error = true;