Wrong encoding in Mysql when I enter via AJAX

Question

I’m having trouble finding a solution to my problem. Briefly:

I send data to a table, using a php file that does querry, and an ajax call that sends all the values I need to the php file. When it is inserted in the table the accents of the words are all crazy. If I add entries to the table using phpmyadmin this error does not happen. How can I resolve?

• Call AJAX:

  pageurl = 'http://estradasegura.pt/exames/testesDB.php';
                      //para consultar mais opcoes possiveis numa chamada ajax
                      //http://api.jquery.com/jQuery.ajax/
                      $.ajax({
  
                          //url da pagina
                          url: pageurl,
                          //parametros a passar
                          data: dadosajax,
                          //tipo: POST ou GET
                          type: 'POST',
                          //cache
                          cache: false,
  

• PHP file connecting to Mysql:

  ini_set('display_errors', true); error_reporting(E_ALL);
  
  $dbname = 'nomedabasededados';
  $username = 'meuusername';
  $password = 'ahahahaha';
  $servername = 'localhost';
  
  $pergunta = $_POST['pergunta']; 
  $resA = $_POST['resA'];   
  $resB = $_POST['resB'];
  $resC = $_POST['resC'];  
  $resD = $_POST['resD'];  
  $resE = $_POST['resE'];  
  $acertaram = intval($_POST['acertaram']); 
  $falharam = intval($_POST['falharam']);
  $dificuldade = intval($_POST['dificuldade']); 
  $resposta = intval($_POST['resposta']);  
  $imgSrc = $_POST['imgSrc'];
  
  
  $conn = new mysqli($servername, $username, $password, $dbname);
  
  if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
  } 
  
  
  $sql = " INSERT INTO perguntas ( pergunta, resA, resB, resC, resD, resE, acertaram, falharam, dificuldade, resposta, imgSrc )  VALUES ( ";
  
  $sql .= "'$pergunta', '$resA', '$resB', '$resC', '$resD', '$resE', '$acertaram', '$falharam', '$dificuldade', '$resposta', '$imgSrc' )" ;
  
   $result = mysqli_query($conn, $sql);
  
  $conn->close();
  
  
  
  ?>
  

Answer 1

Solution 1

Solvency 2

Ps: I use Sublime Text 3.
Preferences -> Settings - Syntax Specifics -> //in JSON does so:
"show_encoding": true

Solution 3 - Notepad++

Answer 2

You could use utf8_encode in the data you need for characters in the post variable assignment.

http://php.net/manual/en/function.utf8-encode.php.

You can also try to modify the charset in your html

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 

And in your php

header( 'Content-Type: text/html; charset=utf-8' );

Answer 3

Solution found:

The solution I found that worked for my case is as follows::

$pergunta = iconv("UTF-8", "ISO-8859-1", $_POST['pergunta']);

With this change the strings are saved in the database without any type of error of the characters. For those who want to know more about iconv() can visit this link.