Body empty in response php from database because special character

Question

i can't resolve my problem with special character, in my case "à". When i open my php file in browser, if the special character is include in database on a table with varchar utf8_general_ci the response is empty, but if i delete this character the response is normal. Could you help my please. Thank you in advance

Here my php code

<?php

include('connec.php');

$sql = "SELECT * FROM articles";

$result = $link->query($sql);

$myarray = array();

if($result->num_rows > 0){
    while($row = $result->fetch_assoc()){
        $myarray[] = $row;
    }
    // Send back the complete records as a json
    echo json_encode($myarray);
}else{
    echo "error";
}
$link->close();

return;
?>

Answer 1

When your PHP file doesn't return anything there might be a simple error in it. There are two ways to check this:

1. Check the PHP error logs. These are text files containing all the errors generated by your code.

2. Switch on error reporting. This will output any error, except syntax errors! For those errors you need to check the logs. This is how you switch on error reporting:

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);