dongtan1009 2016-08-19 05:28
浏览 14

PHP登录和注册错误

The error shown is

"Fatal error: Uncaught Error: Call to a member function query() on string in D:\Users\kukor\Documents\XAMPP\htdocs\timetable\class.ManageUsers.php:22 Stack trace: #0 D:\Users\kukor\Documents\XAMPP\htdocs\timetable\login.php(19): ManageUsers->LoginUsers('kayzmark', 'ultimate') #1 {main} thrown in D:\Users\kukor\Documents\XAMPP\htdocs\timetable\class.ManageUsers.php on line 22"

<?php
class ManageUsers{
    public $link;

    function __construct(){
        $db_connection = new dbConnection();
        $this->link = $db_connection->connect();
        return $this->link;
    }

    function registerUsers($password, $ip_address, $date, $time, $username, $email, $uname){
        $query = $this->link->prepare("INSERT INTO users (password,ip_address,date,time,username, email, uname) VALUES(?,?,?,?,?,?,?)");
        $values = array ($password, $ip_address, $date, $time, $username, $email, $uname);
        $query->execute($values);
        $count = $query->rowCount();
        return $count;
    }

    function LoginUsers($username, $password){
        $query = $this->link->query("SELECT * FROM users WHERE username='$username' AND password='$password'");
        $rowCount = $query->rowCount();
        return $rowCount;
    }

    function GetUserInfo($username){
        $query = $this->link->query("SELECT * FROM users WHERE username = '$username'");
        $rowCount = $query->rowCount();
        if($rowCount ==1)
        {
            $result = $query->fetchAll();
            return $result;
        }
        else
        {
            return $rowCount;
        }
    }
}
?>
  • 写回答

2条回答 默认 最新

  • dongyang1518 2016-08-19 05:32
    关注

    You are probaly calling ->query() on a string instead of the object. Could you verify that the variable where you call query() on contains the right object and you are not overriding it by mistake?

    评论

报告相同问题?

悬赏问题

  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应