doulang9521 2013-06-12 21:24
浏览 46
已采纳

调用成员函数bind_param() - 出了什么问题?

Please, someone save me from this burning pit of death. I'm literally pulling my hair out here.

Error: Call to a member function bind_param() on a non-object in path on line 8

Thanks

<?php

    include 'admin/db_connect.php';

    $result;

    $stmt = $mysqli->prepare("SELECT `latitude`,`longitude` FROM ? WHERE `route` = ?");
    $stmt->bind_param('ss', $company, $route);

    $company = $_GET['company'];
    $company .= "_routes";
    $route = $_GET['route'];

    $stmt->execute();
    $statement->bind_result($result);

    printf($result);

?>

db_connect.php:

define("HOST", "");
define("USER", "");
define("PASSWORD", "");
define("DATABASE", "");

$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
  • 写回答

1条回答 默认 最新

  • douyi1963 2013-06-12 21:31
    关注

    You encountered an error, thats why false is returned, which is not an object, which leads to this error.

    Have a look at whats in $mysqli->error right after "prepare"

    Is your connection up?

    it is not possible to have the table name dynamic in prepared statements.

    It is only intended for parameters, i guess thats your error. prepared statement is for the column values not for table name.

    you have to build your query without prepared statements.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥50 汇编语言除法溢出问题
  • ¥65 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波