public function registerCaptain($username, $password, $firstName, $lastName, $zip, $street, $city, $state, $email, $phone, $mobile) { $formatted_firstName = ucwords(strtolower($firstName)); $formatted_lastName = ucwords(strtolower($lastName)); $captain = new Captain(); $salt = $captain->generate_salt(); $hash = $captain->hash_password($salt, $password); $db = DatabaseBook::getInstance(); $mysqli = $db->getConnection(); $query = "INSERT INTO ea_users(`first_name`, `last_name`, `zip_code`,`address`,`city`,`state`,`email`,`captain_pic`,`phone_number`,`mobile_number`,`id_roles`) VALUES ('{$formatted_firstName}', '{$formatted_lastName}', '{$zip}','{$street}','{$city}','{$state}','{$email}','assets/images/default/profile-default.png','{$phone}','{$mobile}',2)"; if (!$mysqli->query($query)) { return false; } else { $query = "INSERT INTO ea_user_settings(`id_users`,`username`,`password`,`salt`) VALUES (LAST_INSERT_ID(),'{$username}','{$hash}','{$salt}')"; if (!$mysqli->query($query)) { return false; } else { return true; } } return false; }