Put double quotes in a mysql string with PHP

Question

I have this code in PHP:

$_pagi_sql='SELECT * FROM programas WHERE MATCH(titulo, texto,pais) AGAINST ('"$criterio"' IN BOOLEAN MODE) AND operador=34 And validez >= NOW()';

I want to put exactly this string in the variable $_pagi_sql:

SELECT * FROM programas WHERE MATCH(titulo, texto,pais) AGAINST ('"STH"' IN BOOLEAN MODE) AND operador=34 And validez >= NOW()

However the double quotes are not properly stored in the variable $_pagi_sql

How can it be done?

Escape the double quotes i.e. AGAINST ('\"STH\"' IN B... – Aug 08 '13 at 21:59 — , Aug 08 '13 at 21:59

score 0 · Accepted Answer · edited Sep 14 '16 at 20:05

0

You can enter double quotes by adding slashes before your single quotes.

$_pagi_sql='SELECT * FROM programas WHERE MATCH(titulo, texto,pais) AGAINST (\'"$criterio"\' IN BOOLEAN MODE) AND operador=34 And validez >= NOW()';

edited Sep 14 '16 at 20:05

Eric Leschinski

146,994
96
417
335

answered Aug 08 '13 at 21:59

castis

8,154
4
41
63

Hashem Qolami · Answer 2 · 2013-08-08T22:26:04.843

0

Replace the single quotes from right handle side with double quotes:

$_pagi_sql="SELECT * FROM programas WHERE MATCH(titulo, texto,pais) AGAINST ('\"$criterio\"' IN BOOLEAN MODE) AND operador=34 And validez >= NOW()";

Or, get rid of the quotes, use heredoc:

$_pagi_sql = <<<SQL
SELECT * FROM programas WHERE MATCH(titulo, texto,pais) AGAINST ('"$criterio"' IN BOOLEAN MODE) AND operador=34 And validez >= NOW()
SQL;

edited Aug 08 '13 at 22:26

answered Aug 08 '13 at 22:00

Hashem Qolami

97,268
26
150
164

1

This won't produce the double quotes around the variable that the OP has in the desired output. – Bad Wolf Aug 08 '13 at 22:01

Put double quotes in a mysql string with PHP

2 Answers2

Linked