public static function AddNewInvitation($host_email, $guest_email) { $token = sha1(uniqid() . $guest_email); $sqlCommand = "INSERT INTO invitations (host_email,guest_email,token,created_datetime, expired_datetime)" . "VALUES (?,?,?,NOW(), DATE_ADD(NOW(), INTERVAL 30 DAY))"; $paramTypeSpec = "sss"; $mysqli = DA_Helper::mysqli_connect(); if ($mysqli->connect_errno) { $msg = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; throw new Exception($msg, $stmt->errno); } if (!($stmt = $mysqli->prepare($sqlCommand))) { $msg = "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error; throw new Exception($msg, $stmt->errno); } if (!$stmt->bind_param($paramTypeSpec, $host_email, $guest_email, $token)) { $msg = "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error; throw new Exception($msg, $stmt->errno); } if (!$stmt->execute()) { $msg = "Execute failed: (" . $stmt->errno . ") " . $stmt->error; throw new Exception($msg, $stmt->errno); } $stmt->close(); $insertedID = $mysqli->insert_id; $retrievedInvitation = da_invitation::GetInvitationByID($insertedID); return $retrievedInvitation; }