Colleagues.
I have a table that within the Days field brings: Second & Tuesday
But when querying within PHP, it does not return anything, even if the query is correct:
$sql = mysqli_query($con,"SELECT * FROM semana WHERE Dias = 'Segundas & Terças'");
When we play directly inside Mysql, it returns the result, but within PHP it does not. I believe the problem is in & I've never been particularly troubled. Would anyone know how to solve it?
You can do this as follows:
$Dias = "Segundas & Terças";
$sql = mysqli_query($con,"SELECT * FROM semana WHERE Dias = '".$Dias."'");
Passing the variable before.
Fox, to avoid many interventions in your code, I recommend that you use the like function:
$sql = mysqli_query($con,"SELECT * FROM semana WHERE Dias LIKE 'Segundas%Terças'");
There are two ROUTE ways to resolve this.
1) Escaping (\) or special character.
$sql = mysqli_query($con,"SELECT * FROM semana WHERE Dias = 'Segundas \& Terças'");
2) Using the mysqli_real_escape_string :
$dias = mysqli_real_escape_string("Segundas & Terças");
$sql = mysqli_query($con,"SELECT * FROM semana WHERE Dias = '{$dias}'");