SELECT with PDO and variable

Question

SELECT with PDO and variable

Navigation

#1 by (2 votes)
#2 by (2 votes)

1

How can I do a SELECT in MYSQL with PDO next to it below:

$buscarNoticiaTitulo = "noticias.titulo LIKE '%teste%'";
$sqlNoticias = $pdo->prepare('SELECT * FROM noticias WHERE :buscarNoticiaTitulo');
$sqlNoticias->execute(array("buscarNoticiaTitulo" => $buscarNoticiaTitulo));
$resultadoSqlNoticias = $sqlNoticias->fetchAll();

The above example does not give any error, but does not return anything. If I do without PDO it returns the news with the title "Test 123 Testing Test"

php mysql pdo select

asked by anonymous 25.02.2016 / 19:30

2 answers

Error reading and comparing numbers in an array Error while posting

score 2 · Answer 1

Do not use single quotation mark in query noticias.titulo LIKE '%teste% , pass wildcards in execute() and set query correctly as it gets outside of placeholder.

$buscarNoticiaTitulo = "valor";
$sqlNoticias = $pdo->prepare('SELECT * FROM noticias WHERE noticias.titulo LIKE :buscarNoticiaTitulo');
$sqlNoticias->execute(array("buscarNoticiaTitulo" => '%'. $buscarNoticiaTitulo .'%'));

score 2 · Answer 2

Well, I ended up getting it this way:

$buscarNoticiaTitulo = "noticias.titulo LIKE '%teste%'";
$sqlNoticias = $pdo->prepare('SELECT * FROM noticias WHERE '.$buscarNoticiaTitulo.'');
$sqlNoticias->execute();
$resultadoSqlNoticias = $sqlNoticias->fetchAll();

I do not know if it's the right way, but it works. Then I will calmly see this issue and if I know anything more correct put here!