public function deleteTodoItem($todo_id, $user_id) { $query = "DELETE FROM todos WHERE id=? AND user_id=?"; $params = array($todo_id, $user_id); $this->db->query($query, $params); $result = $this->db->row() > 0; if (!$result) { return FALSE; } return true; }
public function save(\Todo\Models\User $user) { $query = "INSERT INTO users (`username`,`password`)" . "VALUES (?,?)"; $params = array($user->getUsername(), $user->getPassword()); if ($user->getId()) { $query = "UPDATE users SET username=? AND password=? WHERE user_id=?"; $params[] = $user->getId(); } $this->db->query($query, $params); return $this->db->rows(); }