how can i setting utf-8 from csv file to phpmyadmin

Question

I got some problems that my result not right (i think it's not UTF-8).

This is input(CSV file)

This is output (in phpmyadmin)

Please Help!

$file_data = $this->upload->data();
        $file_path =  'upload/file_csv/'.$file_data['file_name'];
        if ($this->csvimport->get_array($file_path)) {
            $csv_array = $this->csvimport->get_array($file_path);

                foreach ($csv_array as $row) {
                    $insert_data = array(                           
                        'firstname'=>$row['tea_name'],
                        'lastname'=>$row['tea_surename'],
                        'teacher_id'=>$row['teacher_id'],
                    );
                        $tea_id = $insert_data['teacher_id'];
                        $fname = $insert_data['firstname'];
                        $lname = $insert_data['lastname'];

                        for($i=0;$i<sizeof($insert_data);$i++){
                            $sql = "select * from teacher where teacher_id = '$tea_id' ";                           
                            $result = $this->db->query($sql)->num_rows();
                        }

                        if($result>0){                              
                            $sql="UPDATE `dvp`.`teacher` SET `firstname` = '$fname', `lastname` = '$lname' WHERE `teacher`.`teacher_id` = '$tea_id'";
                            $this->db->query($sql);
                        }else{
                            $sql="INSERT INTO `dvp`.`teacher` (`teacher_id`, `firstname`, `lastname`) VALUES ('$tea_id', '$fname', '$lname')";
                            $this->db->query($sql);
                        }


                }

Answer 1

Please, can you try this out?

$fromAlienLang = mb_detect_encoding($item['name'], 'auto');


mb_convert_encoding($item['name'], "UTF-8", $fromAlienLang);