Выбор самых близких значений в MySQL ⇐ Php

[Anonymous]

Я имею в виду этот урок: http://www.techfounder.net/2009/02/02/s ... -in-mysql/

мой запрос и код для выполнения поиска (это не возвращает никакого результата). Мне нужно получить 100 шкафов значения для почтового индекса, предоставленного пользователем, который собирается $ postcode = $ data ['postcode']; < /p>


Показанная ошибка: фатальная ошибка: uncaught exception 'pdoexception' с
message 'sqlstate [hy093]: номер неверного параметра : Количество связанных
переменных не соответствует количеству токенов в < /p>
< /blockquote>

$return = $_POST;
//$return='{"sub":{"1":"","2":""},"postcode":"56000","slider1":"100","action":"test"}';

$return["json"] = json_encode($return);
// echo json_encode($return);
$data = json_decode($return["json"], true);
//var_dump($data);

include($_SERVER['DOCUMENT_ROOT']."/config.php");

$key =array_keys($data['sub']);
//print_r($key);
$pricing2 = $data['slider1'];
$pricing = $pricing2 * 1.15;
$postcode = $data['postcode'];

$bindings = array();
$bindings[] = array(":pricing", $pricing, PDO::PARAM_STR);
$bindings[] = array(":distance", $postcode, PDO::PARAM_STR);

$key_placeholders = array();
foreach($key as $k => $v) {
$placeholder = ":subid".$k;
$bindings[] = array($placeholder, $v, PDO::PARAM_INT);
$key_placeholders[] = $placeholder;
}

$sql = "SELECT Name,PostUUID,pricing,Poscode,subname,Reputation,ReviewPlus,ReviewNeg,week_morning,week_afternoon,week_evening,weekend_morning,week_afternoon,week_evening,weekend_morning,weekend_afternoon,week_evening,weekend_morning,weekend_afternoon,weekend_evening,date,Phone,Sex,UUID,catname FROM posts,subjects "
. "WHERE posts.subid IN (". implode(",",$key_placeholders).") "
. "AND posts.pricing prepare($sql);
foreach($bindings as $b) {
$statement->bindValue($b[0],$b[1],$b[2]);
}
$statement->execute();
$json = array();
while( $row = $statement->fetch()) {
array_push($json, array("name" => $row['Name'], "id" => $row['PostUUID'],"rate" => $row['pricing'],"postcode" => $row['distance'],"subject" => $row['subname'],"reputation" => $row['Reputation'],"plus" => $row['ReviewPlus'],"neg" => $row['ReviewNeg'],"weekM" => $row['week_morning'],"weekA" => $row['week_afternoon'],"weekE" => $row['week_evening'],"endM" => $row['weekend_morning'],"endA" => $row['weekend_afternoon'],"endE" => $row['weekend_evening'],"postDate" => $row['date'],"contact" => $row['Phone'],"gender" => $row['Sex'],"tid" => $row['UUID'],"levelName" => $row['catname']));
}
header('Content-Type: application/json');
echo json_encode($json);


Подробнее здесь: https://stackoverflow.com/questions/309 ... s-in-mysql