PHP keep_right_conn Beispiele

Beispiel #1

Datei: lib_installer.php Projekt: run100/ecshop

/**
 * 创建指定名字的数据库
 *
 * @access  public
 * @param   string      $db_host        主机
 * @param   string      $db_port        端口号
 * @param   string      $db_user        用户名
 * @param   string      $db_pass        密码
 * @param   string      $db_name        数据库名
 * @return  boolean     成功返回true，失败返回false
 */
function create_database($db_host, $db_port, $db_user, $db_pass, $db_name)
{
    global $err, $_LANG;
    $conn = @mysqli_connect($db_host, $db_user, $db_pass, '', $db_port);
    if ($conn === false) {
        $err->add($_LANG['connect_failed']);
        return false;
    }
    $mysql_version = mysqli_get_server_info($conn);
    keep_right_conn($conn, $mysql_version);
    if (mysqli_select_db($conn, $db_name) === false) {
        $sql = version_compare($mysql_version, '4.1', '>=') ? "CREATE DATABASE {$db_name} DEFAULT CHARACTER SET " . EC_DB_CHARSET : "CREATE DATABASE {$db_name}";
        if (mysqli_query($conn, $sql) === false) {
            $err->add($_LANG['cannt_create_database']);
            return false;
        }
    }
    @mysqli_close($conn);
    return true;
}

Beispiel #2

Datei: lib_auto_installer.php Projekt: noikiy/mdwp

/**
 * 创建指定名字的数据库
 *
 * @access  public
 * @param   string      $db_host        主机
 * @param   string      $db_port        端口号
 * @param   string      $db_user        用户名
 * @param   string      $db_pass        密码
 * @param   string      $db_name        数据库名
 * @return  boolean     成功返回true，失败返回false
 */
function create_database($db_host, $db_port, $db_user, $db_pass, $db_name)
{
    global $err, $_LANG;
    $db_host = construct_db_host($db_host, $db_port);
    $conn = @mysql_connect($db_host, $db_user, $db_pass);

    if ($conn === false)
    {
        $err->add($_LANG['connect_failed']);

        return false;
    }

    $mysql_version = mysql_get_server_info($conn);
    keep_right_conn($conn, $mysql_version);
    if (mysql_select_db($db_name, $conn) === false)
    {
        $sql = $mysql_version >= '4.1' ? "CREATE DATABASE $db_name DEFAULT CHARACTER SET " . EC_DB_CHARSET : "CREATE DATABASE $db_name";
        if (mysql_query($sql, $conn) === false)
        {
            $err->add($_LANG['cannt_create_database']);
            return false;
        }
    }
    @mysql_close($conn);

    return true;
}

Beispiel #3

Datei: lib_installer.php Projekt: hobbysh/seevia-opensource

/**
 * 创建指定名字的数据库
 *
 * @access  public
 * @param   string      $db_host        主机
 * @param   string      $db_port        端口号
 * @param   string      $db_user        用户名
 * @param   string      $db_pass        密码
 * @param   string      $db_name        数据库名
 * @return  boolean     成功返回true，失败返回false
 */
function create_data($db_host, $db_port, $db_user, $db_pass, $db_name)
{
    $db_host = construct_db_host($db_host, $db_port);
    $conn = @mysql_connect($db_host, $db_user, $db_pass);
    if ($conn === false) {
        return false;
    }
    $mysql_version = mysql_get_server_info($conn);
    keep_right_conn($conn, $mysql_version);
    if (mysql_select_db($db_name, $conn) === false) {
        $sql = $mysql_version >= '4.1' ? "CREATE DATABASE {$db_name} DEFAULT CHARACTER SET " . EC_DB_CHARSET : "CREATE DATABASE {$db_name}";
        if (mysql_query($sql, $conn) === false) {
            return false;
        }
    } else {
        $sql2 = "DROP DATABASE {$db_name}";
        if (mysql_query($sql2, $conn) === false) {
            return false;
        }
        $sql = $mysql_version >= '4.1' ? "CREATE DATABASE {$db_name} DEFAULT CHARACTER SET " . EC_DB_CHARSET : "CREATE DATABASE {$db_name}";
        if (mysql_query($sql, $conn) === false) {
            return false;
        }
    }
    @mysql_close($conn);
    return true;
}