connect_error) {
throw new Exception("Error: " . $connection->connect_error);
}
} catch (Exception $e) {
exit($e->getMessage());
}
$mail = new PHPMailer(true);
$mail->SMTPDebug = SMTP::DEBUG_SERVER;
// Check if the form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['signup'])) {
// Initialize variables with default values
$BusinessName = $Username = $Password = $Email = $Phone = $Location = $activationCode = $ConfirmPassword = "";
// Check if the keys exist in the $_POST array before accessing them
if (isset($_POST["BusinessName"])) {
$BusinessName = mysqli_real_escape_string($connection, htmlspecialchars($_POST["BusinessName"]));
}
if (isset($_POST["Username"])) {
$Username = mysqli_real_escape_string($connection, htmlspecialchars($_POST["Username"]));
}
if (isset($_POST["Password"])) {
$Password = mysqli_real_escape_string($connection, htmlspecialchars($_POST["Password"]));
}
if (isset($_POST["Email"])) {
$Email = mysqli_real_escape_string($connection, htmlspecialchars($_POST["Email"]));
}
if (isset($_POST["Phone"])) {
$Phone = mysqli_real_escape_string($connection, htmlspecialchars($_POST["Phone"]));
}
if (isset($_POST["Location"])) {
$Location = mysqli_real_escape_string($connection, htmlspecialchars($_POST["Location"]));
}
if (isset($_POST["activation_code"])) {
$activationCode = mysqli_real_escape_string($connection, htmlspecialchars($_POST["activation_code"]));
}
if (isset($_POST["ConfirmPassword"])) {
$ConfirmPassword = mysqli_real_escape_string($connection, htmlspecialchars($_POST["ConfirmPassword"]));
}
if (isset($_SESSION['id_business']) && !empty($_SESSION['id_business'])) {
header("Location: reg-success.html");
}
// Call the function to handle form submission
handleFormSubmission($BusinessName, $Username, $Password, $Email, $Phone, $Location, $ConfirmPassword, $connection, $mail);
}
// Function to handle form submission and insert data in the database
function handleFormSubmission($BusinessName, $Username, $Password, $Email, $Phone, $Location, $ConfirmPassword, $connection, $mail)
{
// Validate form data
if (empty($BusinessName) || empty($Username) || empty($Password) || empty($Email) || empty($Phone) || empty($Location) || empty($ConfirmPassword)) {
// Handle validation errors
}
if (strlen($Password) > 20 || strlen($Password) < 5) {
// Handle password length error
}
if (!filter_var($Email, FILTER_VALIDATE_EMAIL)) {
// Handle email validation error
}
if (preg_match('/^[a-zA-Z0-9]+$/', $Username) == 0) {
// Handle username validation error
}
// Check if Username already exists
$stmt = $connection->prepare('SELECT id_business, Password FROM sales_pilot.business_records WHERE Username = ?');
$stmt->bind_param('s', $Username);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
echo 'Username already exists, please choose another!';
} else {
// Insert new user record
$passwordHash = password_hash($Password, PASSWORD_DEFAULT);
$activationCode = uniqid();
$insertStmt = $connection->prepare('INSERT INTO sales_pilot.business_records (BusinessName, Username, Password, Email, Phone, Location, activation_code, ConfirmPassword) VALUES (?, ?, ?, ?, ?, ?, ?, ?)');
$insertStmt->bind_param('ssssssss', $BusinessName, $Username, $passwordHash, $Email, $Phone, $Location, $activationCode, $ConfirmPassword);
if ($insertStmt->execute()) {
// Send activation email
try {
$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->Port = 465;
$mail->SMTPAuth = true;
$mail->Username = 'olphemie@gmail.com'; // Replace with your Gmail email
$mail->Password = 'itak uyjg empc blnp'; // Replace with your app password
$mail->SMTPSecure = PHPMailer::ENCRYPTION_SMTPS;
$mail->setFrom('olphemie@gmail.com', 'SalesPilot');
$mail->addAddress($Email);
$mail->Subject = 'Activate Your Account';
$mail->Body = 'Hello,
Click the link below to activate your account:
Activate Account';
if ($mail->send()) {
header("Location: reg-success.html"); // Redirect after sending activation email
exit(); // Add exit to stop the script execution
} else {
echo 'Error sending activation email: ' . $mail->ErrorInfo;
}
} catch (Exception $e) {
echo 'Mailer Error: ' . $e->getMessage();
}
} else {
echo 'Error inserting user record into the database: ' . $connection->error;
}
}
$stmt->close();
}
// Close the database connection
$connection->close();
?>
Sales Pilot - Registration