PHP Decode

?>  <?php
                    // Database Configuration
                    $dbHost = 'localhost';
                    $dbUsername = 'u608374782_AledanyKIWI';
                    $dbPassword = 'Aa123123123@@';
                    $dbName = 'u608374782_AledanyKIWI';

                    // Create a database connection
                    $connection = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

                    // Check if the connection is successful
                    if ($connection->connect_error) {
                        die("Connection failed: " . $connection->connect_error);
                    }

                    // Verify reCAPTCHA
$recaptchaSecretKey = '6LeEelQoAAAAAMley_-At5-AOed2_G12YcZuThZG';
$recaptchaResponse = $_POST['g-recaptcha-response'];

$recaptchaUrl = "https://www.google.com/recaptcha/api/siteverify";
$recaptchaData = array(
    'secret' => $recaptchaSecretKey,
    'response' => $recaptchaResponse,
);

$recaptchaOptions = array(
    'http' => array(
        'method' => 'POST',
        'content' => http_build_query($recaptchaData),
    ),
);

$recaptchaContext = stream_context_create($recaptchaOptions);
$recaptchaResult = file_get_contents($recaptchaUrl, false, $recaptchaContext);
$recaptchaData = json_decode($recaptchaResult, true);

if (!$recaptchaData['success']) {
    // CAPTCHA verification failed
    echo "CAPTCHA verification failed. Please try again.";
} else {
    // CAPTCHA verification successful, proceed with signup logic
    // ... your existing signup logic ...
}

                    // Initialize variables to store form data and errors
                    $username = $email = $password = $referralCode = '';
                    $usernameErr = $emailErr = $passwordErr = $referralCodeErr = '';

                    // Handle form submission
                    if ($_SERVER["REQUEST_METHOD"] == "POST") {
                        // Retrieve and sanitize form data
                        $username = $_POST['username'];
                        $email = $_POST['email'];
                        $password = $_POST['password'];
                        $referralCode = $_POST['referralCode'];

                        // Perform validation (you can add more validation rules as needed)
                        if (empty($username)) {
                            $usernameErr = 'Username is required';
                        }

                        if (empty($email)) {
                            $emailErr = 'Email is required';
                        } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
                            $emailErr = 'Invalid email format';
                        }

                        if (empty($password)) {
                            $passwordErr = 'Password is required';
                        }

                        // Validate the referral code
                        if (empty($referralCode)) {
                            $referralCodeErr = 'Referral code is required';
                        } else {
                            $sql = "SELECT id FROM referral_codes WHERE code = '$referralCode' LIMIT 1";
                            $result = $connection->query($sql);
                            if ($result->num_rows === 0) {
                                $referralCodeErr = 'Invalid referral code';
                            }
                        }

                        // If there are no errors, insert the data into the database
                        if (empty($usernameErr) && empty($emailErr) && empty($passwordErr) && empty($referralCodeErr)) {
                            $hashedPassword = password_hash($password, PASSWORD_DEFAULT); // Hash the password for security

                            // Insert user data into the database
                            $sql = "INSERT INTO users (username, email, password) VALUES ('$username', '$email', '$hashedPassword')";

                            if ($connection->query($sql) === TRUE) {
                                // Insertion successful
                                // Create a new wallet entry for the user with an initial balance of 0
                                $userId = $connection->insert_id;
                                $sql = "INSERT INTO wallet (user_id) VALUES ('$userId')";
                                if ($connection->query($sql) !== TRUE) {
                                    echo "Error creating wallet for the user: " . $connection->error;
                                    // You can handle the error here as needed
                                }

                                // Redirect the user to signin.php after successful signup
                                header("Location: signin.php");
                                exit;
                            } else {
                                // Insertion failed
                                echo "Error: " . $sql . "<br>" . $connection->error;
                            }
                        }
                    }

                    // Close the database connection
                    $connection->close();
                    ?><?