PHP查询Where和Like

Question

I try to use a system with jQuery autocomplete to provide a listview Here is my PHP code, except I can not find the problem, I have no error in the console but I can not seem to get the data that are in the db. It finds me no correspondence.

Conditions "where" are all right and checked (I even try the SQL query directly into phpMyAdmin, and it works, but not through the php file)

<?php
try
{
$bdd = new PDO('mysql:host=localhost;dbname=schoolby_fr', '*****', '*****');
}
catch (Exception $e)
{
    die('Erreur : ' . $e->getMessage());
}
$term = "Malrau";
$pays = "France";
$dept = "Vosges";
$tipe = "Lycée";

$requete = $bdd->prepare('SELECT * FROM school WHERE s_pays="'.$pays.'" AND s_dept="'.$dept.'" AND s_type="'.$tipe.'" AND s_ecole LIKE :term');
$requete->execute(array('term' => '%'.$term.'%'));

$array = array(); 

while($donnee = $requete->fetch())
{
array_push($array, $donnee['s_ecole']); 
}

echo json_encode($array);

?>

EDIT 22/09/2014

I wanted to show you what I get if I voluntarily recalling the condition $pays and $tipe but leaving $term and $dept. Because it does not work with all conditions.

Answer 1

if you simplify your prepare statement by taking out the variables and hard coding the values maybe you can identify if it's the variables