Hello,
I got the error as in my title and I cant find the problem?
Here is the code of my class:
[code=php] public function GetPostcode($type, $postcode=NULL, $huisnr=NULL)
{
switch($type)
{
case “4XY”:
$sql = “SELECT wijkcode, rd_x, rd_y, lat, lon FROM `postcode`.`4XY`”;
break;
case “5XY”:
$sql = “SELECT wijkcode, letter, rd_x, rd_y, lat, lon FROM `postcode`.`5XY`”;
break;
case “6XY”:
$sql = “SELECT wijkcode, lettercombinatie, rd_x, rd_y, lat, lon FROM `postcode`.`6XY`”;
break;
case “HuisnummerXY”:
$sql = “SELECT nummeraanduidingid, wijkcode, lettercombinatie, huisnr, huisnr_toevoeging, rd_x, rd_y, lat, lon FROM `postcode`.`huisnummerXY`”;
break;
}
if(!empty($postcode))
{
switch($type)
{
case “4XY”:
$sql .= ” WHERE wijkcode=:postcode”;
break;
case “5XY”:
$sql .= ” WHERE wijkcode=:postcode AND letter=:lettercomb”;
break;
case “6XY”:
$sql .= ” WHERE wijkcode=:postcode AND lettercombinatie=:lettercomb”;
break;
case “HuisnummerXY”:
$sql .= ” WHERE wijkcode=:postcode AND lettercombinatie=:lettercomb AND huisnr=:huisnr”;
break;
}
}
try
{
$stmt = $this->db->prepare($sql);
if(!empty($postcode))
{
$stmt->bindParam(“:postcode”, substr($postcode, 0, 4), PDO::PARAM_INT);
switch($type)
{
case “4XY”:
break;
case “5XY”:
$stmt->bindParam(“:lettercomb”, substr($postcode, 4, 1), PDO::PARAM_STR);
break;
case “6XY”:
$stmt->bindParam(“:lettercomb”, substr($postcode, 4, 2), PDO::PARAM_STR);
break;
case “HuisnummerXY”:
$stmt->bindParam(“:lettercomb”, substr($postcode, 4, 2), PDO::PARAM_STR);
$stmt->bindParam(“:huisnr”, trim($huisnr), PDO::PARAM_INT);
break;
}
}
$stmt->execute();
$this->postcodelijst = $stmt->fetchAll(PDO::FETCH_OBJ);
$stmt->closeCursor();
return $this->postcodelijst;
}
catch (Exception $e)
{
die ($e->getMessage());
}
}
Maybe a fresh look will help me out.
Thanks for any help!?