PDO does not execute query

Question

I have a form that does a search via PDO, only when I run, it does not return me anything.

$PDO = db_connect();

$busca = $_POST['usuario'];
$vbusca = "%".$busca."%";

$sql = 'SELECT nome, tipo, cor FROM livro AS t WHERE ';

var_dump($sql);
$stmt = $PDO->prepare($sql);
$stmt->execute([$vbusca]);
$total = $stmt->rowCount();

I gave one var_dump in the variable $stmt and is returning me the following:

string(57) "SELECT name, type, color FROM book AS t WHERE" Object(Pdostatement)#2 (1) { ["queryString"]=> string(57) "SELECT name, type, color FROM book AS t WHERE" }

Answer 1

You need to define the field that will receive the search post, right after the clause WHERE. I will take a search for the name of the book. See your full code, where I removed your field vbusca, not needed and adding the variable $busca who receives the $_POST directly in the new variable $params. So you can understand based on your code in the content of your question.

$PDO = db_connect();

$busca = $_POST['usuario'];
$params = array("%$busca%");

// Busca pelo nome do livro
$sql = 'SELECT nome, tipo, cor FROM livro WHERE nome LIKE ?';

var_dump($sql);


$stmt = $PDO->prepare($sql);
$stmt->execute($params);

$total = $stmt->rowCount();