public function retrieveCaptainFromBook($captain_id)
{
$db = DatabaseBook::getInstance();
$mysqli = $db->getConnection();
$query = "SELECT * FROM ea_users WHERE id = {$captain_id}";
$result = $mysqli->query($query);
$counter = 0;
$captList = array();
while ($news_row = $result->fetch_array()) {
$captain = new Captain();
$captain->setFirstName($news_row['first_name']);
$captain->setLastName($news_row['last_name']);
$captain->setEmail($news_row['email']);
$captain->setStreet($news_row['address']);
$captain->setCity($news_row['city']);
$captain->setState($news_row['state']);
$captain->setZip($news_row['zip_code']);
$captain->setCaptainId($news_row['id']);
$captList[$counter] = $captain;
$counter++;
}
return $captList;
}
