douwo8140 2016-03-31 09:34
浏览 61
已采纳

致命错误:在布尔值上调用成员函数execute()

<?php
    session_start();
    $config = parse_ini_file('../database_config.ini'); 
    //Create Database connection
    $connection = mysqli_connect('localhost',$config['username'],$config['password'],$config['dbname']);

    if ($connection->connect_error) {
        die('Could not connect to db: ' . mysql_error());
    }


    $stmt = $connection->prepare("INSERT INTO report (reportID, userID, description, address, postalcode, latitude, longitude) 
    VALUES(0, 007, 'Major fire', 'Jurong Point', 640724, 1.640724, 103.640724)");

        $stmt->execute();
        echo "Error:
";
        print_r($stmt->error_list);
        $stmt->close();

        $connection->close();
?>

Error : Fatal error: Call to a member function execute() on boolean

Why does my prepare statement fail?

Structure of my report table enter image description here

  • 写回答

2条回答 默认 最新

  • dongwo5940 2016-03-31 09:46
    关注

    You need to do it in following manner:-

    <?php
        session_start();
        $config = parse_ini_file('../database_config.ini'); 
        //Create Database connection
        $connection = mysqli_connect('localhost',$config['username'],$config['password'],$config['dbname']);
    
        if (mysqli_connect_errno()) { // check the change of if condition
            printf("Connect failed: %s
    ", mysqli_connect_error());
            exit();
        }
        $stmt = mysqli_prepare($connection,"INSERT INTO report (reportID, userID, description, address, postalcode, latitude, longitude) VALUES(0, 007, 'Major fire', 'Jurong Point', 640724, 1.640724, 103.640724)"); // check the change in query code
    
        mysqli_stmt_execute($stmt); // check the change in execution code
        echo "Error:
    ";
        print_r(mysqli_error($connection)); // check the change in error getting code
        mysqli_stmt_close($stmt);// check the change in statement closing code
        mysqli_close($connection); // check the change in db connection closing code
    ?>
    

    For more knowledge refer link and it's example:- http://php.net/manual/en/mysqli.prepare.php

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 爬取豆瓣电影相关处理
  • ¥15 手机淘宝抓清除消息接口
  • ¥15 C#无selenium
  • ¥15 LD衰减计算的结果过大
  • ¥15 用机器学习方法帮助保险公司预测哪些是欺诈行为
  • ¥15 计算300m以内的LD衰减
  • ¥15 数据爬取,python
  • ¥15 怎么看 cst中一个面的功率分布图,请说明详细步骤。类似下图
  • ¥15 为什么我的pycharm无法用pyqt6的QtWebEngine
  • ¥15 FOR循环语句显示查询超过300S错误怎么办