Of course my queries are no longer accepted by my DB. This is for both the site in php and direct with an INSERT in phpmyadmin. See if you can give me a light:
CREATE TABLE 'despesas' (
'id' int(11) NOT NULL,
'desc' varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
'venc' varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
'valor' varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
'recibo' varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
And this is my query in php:
$query = "INSERT INTO despesas (desc, venc, valor, recibo) values('$desc', '$venc', '$val', '" . $rec . "')";
$salva = mysqli_query(BDConexao(), $query);
If I try to insert direct into phpmyadmin it will not either:
INSERT INTO despesas (desc, venc, valor, recibo) values('AWS Amazon', '05/02/2017', '25,00', 'Chrysanthemum.jpg')
Then I ask you, is something wrong with my database?