PHP e mysql
Olá galera, minha tabela não esta salvando dados com acentuação, oque eu faço? já tentei:
ALTER DATABASE `banco` CHARSET = UTF8 COLLATE = utf8_general_ci;
Minha tabela está assim:
[CREATE](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/create-table.html) [TABLE](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/create-table.html) `banco`.`usuario` ( `nome` [VARCHAR](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/string-types.html)(50) [CHARACTER](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset.html) [SET](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset.html) armscii8[COLLATE](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset-collations.html) armscii8_general_ci [NOT](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_not) NULL , `senha` [VARCHAR](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/string-types.html)(50) [CHARACTER](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset.html) [SET](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset.html)armscii8 [COLLATE](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset-collations.html) armscii8_general_ci [NOT](http://localhost/phpmyadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_not) NULL ) ENGINE = MyISAM;
Fechar
Arquivo banco.php, está assim:
<?php
$servidor = "localhost";
$usuario = "root";
$senhaa = "";
$dbname = "banco";
//Criar a conexao
$conecta = mysqli_connect($servidor, $usuario, $senhaa, $dbname);
$conecta->query("SET NAME utf8");
$conecta->query('SET character_set_connection=utf8');
$conecta->query('SET character_set_client=utf8');
$conecta->query('SET character_set_results=utf8');
if(!$conecta){
die("Falha na conexao: " . mysqli_connect_error($conecta));
}else{
echo "Conexao realizada com sucesso";
}
?>
O arquivo que manda os dados para o banco de dados esta assim:
<?php
ini_set('default_charset','UTF-8');
include_once"banco.php";// Banco de dados
$a = "andreetest";
$b = "54545";
$sql_cad = "INSERT INTO usuario(nome, senha) VALUES ('$a','$b')";
$sql_db = mysqli_query($conecta,$sql_cad);
if($sql_db){
echo 'cadastrado';
}else{
echo ".<br>erro<br>".mysqli_errno($conecta);
}
?>
Se trocar o valor da variável "a" colocando o valor andré ele não manda para o banco de dados, simplesmente da o erro 1366.Discussão (1)
Carregando comentários...