duanlinjian5819
duanlinjian5819
2014-07-03 12:17

连接到另一个MySQL表OOP PHP

已采纳

I followed on online tutorial to create an OOP login/registration system for my website. I am trying to reuse the code to connect to the same database but a different table. The code below is the method to update the users table.

public function update($fields = array(), $id = null) {

        if(!$id && $this->isLoggedIn()) {
            $id = $this->data()->id;    
        }

        if(!$this->_db->update('users', $id, $fields)) {
            throw new Exception('There was a problem updating.');
        }
    }

What I want to be able to do is update any table using the same code.

I have tried changing 'users' to $table and then using declaring $table = 'destinations' in the relevant pages but get the errors " Undefined variable: table" and "Uncaught exception 'Exception' with message 'There was a problem updating.' "

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • doufenyu7610 doufenyu7610 7年前

    I don't know how you use your method on subpages, but you should try below:

    public function update($fields = array(), $id = null, $table = 'users') {
    
        if(!$id && $this->isLoggedIn()) {
            $id = $this->data()->id;    
        }
    
        if(!$this->_db->update($table, $id, $fields)) {
            throw new Exception('There was a problem updating.');
        }
    }
    

    And method call:

    $yourObject->update($fields, $id, 'table_to_update_name');
    
    点赞 评论 复制链接分享

相关推荐