Select row whare column value contains ampersand(&) in mysql php pdo

Asked Apr 07 '22 at 07:10

Active Apr 07 '22 at 07:10

Viewed 8 times

Mysql query:

$StoreName = "Jack & Jill";
$sql  = "SELECT * FROM table WHERE storename = :store";
$stmt = $DBConnect->prepare($sql);
$stmt->bindValue(":store", $StoreName);
$stmt->execute();

Here the query is not selecting any value. How to modify the code to select row with column value 'Jack & Jill'?

asked Apr 07 '22 at 07:10

user_59910105

Most likely you maimed your data before insert with some irrelevant function such as htmlspecialchars – Your Common Sense Apr 07 '22 at 07:15

Select row whare column value contains ampersand(&) in mysql php pdo

0 Answers0