/** * Function that adds the User object to the User table in the database. * * @param \GameMania\Model\User $userObject * @return boolean * @throws \Exception */ public function addUser($userObject) { //Establish database connection $dbConn = new DbConn(); $db = $dbConn->getConnection(); //Check if the username already exists if ($this->exists('usr_username', 'User', $userObject->getUsername())) { throw new \Exception("The username is already taken."); } else { //Prepare insert statement for the database. $stmt = $db->prepare("insert into User (usr_username, usr_email, usr_password) VALUES (?, ?, ?)"); $result = $stmt->execute(array($userObject->getUsername(), $userObject->getEmail(), $userObject->getPassword())); //If the execution succeeds, return true if ($result) { return true; } else { throw new \Exception("Doh! The User could not be added. Please " . "look over the submission, correct any errors, and " . "try again."); } } }
/** * Function that takes in a Game object and inserts the data into the database. * * @param \GameMania\Model\Game $gameObject * @return boolean * @throws \Exception */ public function addGame($gameObject) { //Establishing a database connection. $dbConn = new DbConn(); $db = $dbConn->getConnection(); //Check to see if title exists if ($this->exists('gme_title', 'Game', $gameObject->getTitle())) { throw new \Exception("The game title already exists."); } else { //Preparing the insert statement. $stmt = $db->prepare("insert into Game " . "(gme_title, gme_developer, gme_console, gme_price, gme_rating, gme_comments) " . "VALUES " . "(?,?,?,?,?,?) "); $result = $stmt->execute(array($gameObject->getTitle(), $gameObject->getDeveloper(), $gameObject->getConsole(), $gameObject->getPrice(), $gameObject->getRating(), $gameObject->getComments())); //Result Logic if ($result) { return true; //Successfully added the Game. } else { throw new \Exception("Doh! Something went wrong! We couldn't add " . "the new product. Please look over the product, " . "correct any errors, and try again."); } } }