dongshi8038 2015-11-18 07:58
浏览 149

PHP PDO语句不起作用

I'm having a problem with my PDO statement. I have an in active pipe tail -f /var/log/apache2/error.log watching for errors and nothing is coming in, I even piped my mysql.log file no errors there either.

  • if i echo $_POST['sfl'] it will print an integer ie.(4)
  • If I change the :sfl param to just a regular integer ie. "SELECT * FROM station WHERE SFL = '4'" it will query and pull the data fine.

I've removed error checks from the code for clarity

$sql = "SELECT * FROM station WHERE SFL = :sfl";
$stmt = $db->prepare($sql);
$stmt->bindParam(':sfl', $_POST['sfl']);
$stmt->execute();
while($result = $stmt->fetch(PDO::FETCH_ASSOC)){
    print_r($result);   
}

Question: Why isn't php binding my $_POST['sfl'] variable to my statement?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 matlab数字图像处理频率域滤波
    • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
    • ¥15 ELGamal和paillier计算效率谁快?
    • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
    • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
    • ¥15 Arcgis相交分析无法绘制一个或多个图形
    • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
    • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
    • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误