doucepei5298 2016-01-31 20:10
浏览 34

PHP和mysqli - 致命错误:在非对象上调用成员函数bind_param()[重复]

This question already has an answer here:

I know this probably has a very easy fix,but I have been searching around for hours,looking for a solution,only to have nothing.Please don't mark this as a duplicate simply because of the title.bind_param calling to a non-object is usually a syntax error,not an easy fix error.

Code for connect.php:

<?php
    $db = new mysqli('127.0.0.1', 'root', '', 'mon');
    if($db->connect_errno) {
        echo "<p id='gotem'>Something has gone wrong.Tell J to fix it.</p>";
    }
?>

Code for user_add.php:

<?php
require_once 'connect.php';
    if(!empty($_POST)) {
            if(isset($_POST['username'], $_POST['password'])) {
                $username = $_POST['username'];
                $password = $_POST['password'];

                if(!empty($username) && !empty($password)) {
                    $insert = $db->prepare("INSERT INTO 'user' ('name', 'pass') VALUES (?, ?)");
                    $insert->bind_param('ss', $username, $password);
                    if (!$insert->execute()) {
                         echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
                     }                
                }
            }
        }
$_SESSION['uid'] = $_POST['username'];
$_SESSION['pss'] = $_POST['password'];
if(!mysqli_query($db_con, $db_query)) {
    die('Error:'.mysqli_error($db_con));
}
header("Location: index.php");
?>
</div>
  • 写回答

1条回答 默认 最新

  • douju3911 2016-01-31 20:13
    关注

    Avoid the apostrophes in INSERT statement:

                    $insert = $db->prepare("INSERT INTO user (name, pass) VALUES (?, ?)");
    

    The apostrophes should surround strings, not names of tables or columns.

    评论

报告相同问题?

悬赏问题

  • ¥15 微信会员卡接入微信支付商户号收款
  • ¥15 如何获取烟草零售终端数据
  • ¥15 数学建模招标中位数问题
  • ¥15 phython路径名过长报错 不知道什么问题
  • ¥15 深度学习中模型转换该怎么实现
  • ¥15 HLs设计手写数字识别程序编译通不过
  • ¥15 Stata外部命令安装问题求帮助!
  • ¥15 从键盘随机输入A-H中的一串字符串,用七段数码管方法进行绘制。提交代码及运行截图。
  • ¥15 TYPCE母转母,插入认方向
  • ¥15 如何用python向钉钉机器人发送可以放大的图片?