I followed this tutorial link to show graphics, I went well with the database and then to change to use with my database worked perfect in the same way, until one of the fields had the term "sugar" and the data file. php does not show anything when loading it once it finds a value with a tilde or special character, try changing the database and table comparison to uft8 and putting the following lines of code in the project.
mysqli_set_charset($mysqli,"utf8");
json_encode($data, JSON_UNESCAPED_UNICODE);
But despite these changes, it still does not work ...
I get the data by doing web scrapping