[MySQL][PHP]Kodowanie znaków prze exportcie bazy MySQL do pliku Opcje

[krzesik]

Witam,
mam poniższą klasę do zrzutu bazy MySQL do pliku, wszystko ładnie działa, ale mam problem z polskimi ogonkami "ą", "ź", "ś" - wpisuje mi krzaki, proszę o podpowiedź

[PHP] pobierz, plaintext 
.....
  function createDump() {
        // Set line feed
        $lf = "\n";
 
        $resource = mysql_connect($this->getHost(), $this->getDBuser(), $this->getDBpassword());
        mysql_select_db($this->getDbname(), $resource);
        $result = mysql_query("SHOW TABLES");
        $tables = $this->result2Array(0, $result);
        foreach ($tables as $tblval) {
            $result = mysql_query("SHOW CREATE TABLE `$tblval`");
            $createtable[$tblval] = $this->result2Array(1, $result);
        }
        // Set header
        $output = "#". $lf;
        $output .= "# DUmp" . $lf;
        $output .= "# Version 2.6" . $lf;
        $output .= "# ". $lf;
        $output .= "# Host: " . $this->getHost() . $lf;
        $output .= "# Czas wygenerowania: " . date("M j, Y at H:i") . $lf;
        $output .= "# Wersja serwera: ". mysql_get_server_info() . $lf;
        $output .= "# Wersja php: " . phpversion() . $lf;
        $output .= "# Baza danych : `" . $this->getDBname() . "`" . $lf;
        $output .= "#";
 
        // Generate dumptext for the tables.
        foreach ($tables as $tblval)
         {
            If (($tblval!="bip_logowanie") and ($tblval!="bip_users"))
             {
            $output .= $lf . $lf . "# --$tabela------------------------------------------------------" . $lf . $lf;
            $output .= "#". $lf . "# Struktura tabeli dla `$tblval`" . $lf;
            $output .= "#" . $lf . $lf;
            // Generate DROP TABLE statement when client wants it to.
            if($this->isDroptables())
            {
                $output .= "DROP TABLE IF EXISTS `$tblval`;" . $lf;
            }
            $output .= $createtable[$tblval][0].";" . $lf;
            $output .= $lf;
            $output .= "#". $lf . "# Zrzut danych tabeli `$tblval`". $lf . "#" . $lf;
            $result = mysql_query("SELECT * FROM `$tblval`");
            $rows = $this->loadObjectList("", $result);
            foreach($rows as $row)
             {
 
                $insertdump = $lf;
                $insertdump .= "INSERT INTO `$tblval` VALUES (";
                $arr = $this->object2Array($row);
                foreach($arr as $key => $value)
                {
                    $value = addslashes($value);
                    //$value = str_replace("n", 'rn', $value);
                    //$value = str_replace("r", '', $value);
 
                    $insertdump .= "'$value',";
                }
                $output .= rtrim($insertdump,',') . ");";
            }
            }
        }
        mysql_close($resource);
        return $output;
    }
 
    // Private function object2Array.
    function object2Array($obj) {
        $array = null;
        if(is_object($obj)) {
            $array = array();
            foreach (get_object_vars($obj) as $key => $value) {
                if(is_object($value))
                    $array[$key] = $this->object2Array($value);
                else
                    $array[$key] = $value;
            }
        }
        return $array;
    }
 
    // Private function loadObjectList.
    function loadObjectList($key='', $resource) {
        $array = array();
        while ($row = mysql_fetch_object($resource)) {
            if ($key)
                $array[$row->$key] = $row;
            else
                $array[] = $row;
        }
        mysql_free_result($resource);
        return $array;
    }
 
    // Private function result2Array.
    function result2Array($numinarray = 0, $resource) {
        $array = array();
        while ($row = mysql_fetch_row($resource)) {
            $array[] = $row[$numinarray];
        }
        mysql_free_result($resource);
        return $array;
    }
}
.....
[PHP] pobierz, plaintext 

[wlodek_789]

1.

[PHP] pobierz, plaintext 
<?php
//1. polaczenie z baza danych
//polaczenie z baza danych + ustawienie kodowania na utf8
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "base";
$connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
 
//sprawdzenie polaczenia
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
 
//zmaiana znako na utf8
if (!mysqli_set_charset($connection, "utf8")) {
    printf("Error loading character set utf8: %s\n", mysqli_error($connection));
} else {
    printf("Kodowanie ustawione na: %s\n", mysqli_character_set_name($connection));
}
?>
[PHP] pobierz, plaintext 

2. obiektowo

[PHP] pobierz, plaintext 
$objDb = new PDO('mysql:dbname=base;host=localhost', 'root', '', array(
		PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
		PDO::ATTR_PERSISTENT => true
	));
[PHP] pobierz, plaintext 

i jeszcze jedno w bazie kodowanie ustawione na utf utf8_general_ci

pliki *.php na utf 8

[PHP] pobierz, plaintext 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
 
<body>
</body>
</html>
[PHP] pobierz, plaintext