当String中有句点（。）时，如何在PHP / MySQL中查询

Question

How do I query from a MySQL database when I have a period (.) in string using PHP.

$variable = "[e-mail]";
$variable = mysqli_real_escape_string($conn, $variable);
$query = "Select * from table WHERE email = '$variable' ";

Apparently this works when I ran it in PhpMyAdmin SQl tab. But when I run it In my code it does not work. Other strings that don't have a period using the same code are working perfectly. What could be the issue

for those who are asking for my original code here it is

//I get the emails from the url  

    $notit = mysqli_real_escape_string($conn, $_GET['username']);

//I pass my variable in the query

    $sql = "SELECT * ";
    $sql.=" FROM ordrs ";
    $sql.=" WHERE client_email = '$notit' ";
    $query=mysqli_query($conn, $sql) or die("try again");

Answer 1

I figured where the issue was the query was fine the error was coming from json_encode which I din't expect . I hope this question helps others in the future who are facing the problem questioned. Thanks for the help

thanks for the help. Cheers