Rules::update PHP Method

update() public method

public update ( $id, $postdata )
    public function update($id, $postdata)
    {
        if ($this->user->getClass() < User::CLASS_ADMIN) {
            throw new Exception(L::get("PERMISSION_DENIED"), 401);
        }
        $sth = $this->db->prepare("UPDATE rules SET title = ?, text = ? WHERE id = ?");
        $sth->bindParam(1, $postdata["title"], PDO::PARAM_STR);
        $sth->bindParam(2, $postdata["text"], PDO::PARAM_STR);
        $sth->bindParam(3, $id, PDO::PARAM_INT);
        $sth->execute();
    }

Usage Example

Example #1
0
     if ((int) $_GET["timeSinceLastCheck"] < 5100) {
         $user->updateLastAccess();
     }
     httpResponse($user->getStatus());
     break;
 case validateRoute('GET', 'rules'):
     $rules = new Rules($db);
     httpResponse($rules->query());
     break;
 case validateRoute('POST', 'rules'):
     $rules = new Rules($db, $user);
     httpResponse($rules->create($postdata));
     break;
 case validateRoute('PATCH', 'rules/\\d+'):
     $rules = new Rules($db, $user);
     httpResponse($rules->update($params[1], $postdata));
     break;
 case validateRoute('DELETE', 'rules/\\d+'):
     $rules = new Rules($db, $user);
     httpResponse($rules->delete($params[1]));
     break;
 case validateRoute('GET', 'faq'):
     $faq = new Faq($db, $user);
     httpResponse($faq->query());
     break;
 case validateRoute('POST', 'faq'):
     $faq = new Faq($db, $user);
     httpResponse($faq->create($postdata));
     break;
 case validateRoute('PATCH', 'faq/\\d+'):
     $faq = new Faq($db, $user);