} } function email_cropped($email) { $parts = explode('@', $email); return implode('', explode('.', $parts[0])) . '@' . $parts[1]; } function ebay_register($name, $email, $email_c) { global $db; $q = $db->prepare('INSERT INTO ebay_register(name,email,email_c,time) VALUES(?,?,?,NOW())'); return $q->execute(array($name, $email, $email_c)); } if (isset($_POST)) { if (isset($_POST['name']) && isset($_POST['email']) && filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) { $name = $_POST['name']; $email = $_POST['email']; $email_c = email_cropped($email); if (already_registered($email_c)) { echo "You have been already registered. Please be patient, you'll receive the coupon soon"; } else { if (ebay_register($name, $email, $email_c)) { echo "Congrats! You'll recieve the mail coupon soon"; } else { echo 'Some unexpected error occurred. Try again later'; } } } else { echo 'Invalid Email '; } }
global $db; $sql = 'SELECT id from `users` WHERE token = :token'; $q = $db->prepare($sql); $q->execute(array(':token' => $data['token'])); $result = $q->fetch(); $userID = $result['id']; $sql = 'INSERT INTO `registrations` (eventID, userID, teamname, team) VALUES(:eventID, :userID, :teamname, :team)'; $q = $db->prepare($sql); $q->execute(array(':eventID' => $data['eventID'], ':userID' => $userID, ':teamname' => $data['teamname'], ':team' => $data['team'])); } if (isset($_POST)) { if ($_POST['form'] == 'register') { $error = ''; $data = array(); if (valid($_POST)) { if (already_registered($_POST)) { $error = 'Already Registered'; } else { register($_POST); } } else { $error = 'Please Fill The Form'; } if ($error != '') { $data['success'] = false; $data['error'] = $error; } else { $data['success'] = true; $data['message'] = 'success'; } echo json_encode($data);