bindParam错误

Question

我使用bindParam，就像在流动的例子中一样，但是它给了我错误

错误是无法得到任何响应

$con = new PDO('odbc:Driver={SQL Server};Server='.$db_ip.';Database='.$db_name,$db_user,$db_pass);

$m_id=585948;
$sql="select n_id from users where m_id = :member ";
$sth = $con->prepare($sql);
$sth->bindParam(':member', $m_id);
$sth->execute();

while ($row = $sth->fetch(PDO::FETCH_ASSOC)){
echo $row['n_id'];
}

Answer 1

试一试：

$sth = $con->prepare($sql);
$sth->execute(array(
    ':member', $m_id
));