/** * * @param \Todo\Models\Todo $todo * @return Todo[] */ public function add($user_id, $todo_item) { $query = "INSERT INTO todos (`user_id`,`todo_item`)" . "VALUES (?,?)"; $params = array($user_id, $todo_item); $this->db->query($query, $params); return $this->db->rows(); }
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(); }