How to use LIKE in bindValue?

Your SQL would be:

$sql = 'SELECT * FROM nfe WHERE (cliente LIKE :cliente OR cliente IS NULL)';

I could realize there is an error.

Examples :

Let start with the informed term:

$stmt->bindValue(':cliente', $variavel."%", PDO::PARAM_STR);

or

$stmt->bindValue(':cliente', "$variavel%", PDO::PARAM_STR);

End with informed endorsement:

$stmt->bindValue(':cliente', "%".$variavel, PDO::PARAM_STR);

or

$stmt->bindValue(':cliente', "%$variavel", PDO::PARAM_STR);

In any part of the informed term:

$stmt->bindValue(':cliente', "%".$variavel."%", PDO::PARAM_STR);

or

$stmt->bindValue(':cliente', "%$variavel%", PDO::PARAM_STR);

References:

• SQL Like
• bindValue