Guys a tip: I did not know that JSON only worked with UTF8. So I had to put the mysqli_set_charset ($ connection, “utf8”) function;
I’m citing this because the following happened. I had a database on one server and everything worked perfectly; I had to switch the bank to another server. The app (Kodular + PHP) has crashed. The return (JSON) value of Select-SQL has stopped working and now shows an error; I switched the connection to the old server and went back to work. I realized it was something in the bank. I checked the return of the response code (200), response type (application / JSON) and response content (EMPTY -I found it strange because before it returned “[” “]” two square brackets). I researched and found the solution with the mysqli_set_charset function.
3 Likes