Android Question MySql+PHP invisible characters

[ilan]

hi

i am using in one of my apps queries that i send to a PHP file and return a JSON string.
the problem is that the string that is returned contains 2 chars at the start that are creating an error.

if i put the copied string to the online JSON Parser tool i get an error:

going to the first char and pressing 2 times then the "Delete" button fixes that issue. the thing is that nothing is really deleted so those chars are not letters or numbers. how can i fix that issue?

what i do now is this:

Dim jsonStr As String = j.GetString
        Dim parser As JSONParser
        parser.Initialize(jsonStr.SubString2(jsonStr.IndexOf("["),jsonStr.Length))

this works but i wonder why is that happening?

PHP:

    case "getbyemail":
        $table = $_GET["mytable"];
        $email = $_GET["email"];
 
        $q = mysqli_query($con, "SELECT * FROM $table WHERE email = '$email'");
        $rows = array();
        while($r = mysqli_fetch_assoc($q))
        {
            $rows[] = $r;
        }
        echo json_encode($rows);
        mysqli_free_result($q);
        break;

thanx

 

[DonManfred]

i am using in one of my apps queries that i send to a PHP file and return a JSON string.

Make sure the php file is UTF8 encoded. WITH NO BOM!
Post a hexdump of the result you get from PHP-File.
Alternatively upload the php-Script.

 

[ilan]

Make sure the php file is UTF8 encoded. WITH NO BOM!
Post a hexdump of the result you get from PHP-File.

sorry, but i dont understand what this is.
where do i set the UTF8 to the php file?

EDIT: (script deleted)

 

[DonManfred]

where do i set the UTF8 to the php file?

Open the file in notepad++ and check the ENCODING

 

[DonManfred]

sorry, but i dont understand what this is.

Byte order mark - Wikipedia

en.wikipedia.org

 

[ilan]

Open the file in notepad++ and check the ENCODING

View attachment 121561

wow thanx, it was UTF-8-BOM

i will save it to UTF-8

thank you very much @DonManfred