OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	05/09/2025 11:18:49 AM	rwxr-xr-x
📄 composer.json	102 bytes	07/10/2024 05:19:52 AM	rw-r--r--
📄 composer.lock	35.39 KB	07/10/2024 05:19:52 AM	rw-r--r--
📁 image	-	07/10/2024 05:19:52 AM	rwxr-xr-x
📄 index.php	7.06 KB	07/10/2024 05:19:52 AM	rw-r--r--
📁 vendor	-	07/10/2024 05:20:07 AM	rwxr-xr-x

Editing: index.php

<?php
require 'vendor/autoload.php';

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

// PHPMailer instance
$mail = new PHPMailer(true);

// Database credentials
$servername = "139.59.38.164";
$dbname = "cream";
$username = "root";
$password = "newstart";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

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

// Query to select specific emails
$sql = "SELECT email FROM user WHERE email IN ('bhuvanesh@knobly.com', 'himanshu@knobly.com', 'kr.arvind027@gmail.com', 'himanshupandey1708@gmail.com', 'shrinathjoshi81@gmail.com')";
$result = $conn->query($sql);

$recipientEmails = [];
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $recipientEmails[] = $row["email"];
    }
} else {
    echo "No matching emails found";
    $conn->close();
    exit();
}

$conn->close();

// Email parameters
$senderEmail = 'support@knobly.com';
$subject = 'Knobly Cream';
$bodyText = '
<!DOCTYPE html>
<html>
<head>
    <style>
        @keyframes fadeIn {
            from { opacity: 0; }
            to { opacity: 1; }
        }
        body {
            font-family: Arial, sans-serif;
            color: #333;
            background-color: #f4f4f4;
            padding: 0;
            margin: 0;
        }
        .container {
            width: 100%;
            max-width: 600px;
            margin: 0 auto;
            padding: 20px;
            background-color: #fff;
            border: 1px solid #ddd;
            border-radius: 10px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
            animation: fadeIn 2s ease-in-out;
        }
        .header {
            text-align: center;
            padding: 20px 0;
        }
        .header img {
            max-width: 150px;
        }
        .header h1 {
            color: #ff6600;
            margin: 10px 0;
        }
        .content {
            margin-top: 20px;
            line-height: 1.6;
        }
        .content h2 {
            color: #ff6600;
        }
        .content p {
            margin: 10px 0;
        }
        .footer {
            margin-top: 20px;
            text-align: center;
            font-size: 12px;
            color: #777;
        }
        .footer a {
            color: #ff6600;
            text-decoration: none;
        }
        .button {
            display: inline-block;
            padding: 10px 20px;
            margin: 20px 0;
            font-size: 16px;
            color: #fff;
            background-color: #ff6600;
            border-radius: 5px;
            text-decoration: none;
        }

/* Mobile responsiveness */
        @media only screen and (max-width: 600px) {
            .container {
                width: 100%;
                padding: 10px;
            }
            .header img {
                max-width: 100px;
            }
            .header h1, .content h2 {
                font-size: 1.5em;
            }
            .button {
                padding: 10px 15px;
                font-size: 14px;
            }
        }
    </style>
</head>
<body>
    <div class="container">
        <div class="header">
            <img src="" alt="Knobly Cream Logo">
            <h1>Unleash the Power of Digital and Content Marketing with Knobly Cream</h1>
        </div>
        <div class="content">
            <h2>Transform Your Strategy with Cutting-Edge Features:</h2>
            <p><strong>Curate:</strong> Seamlessly discover and share top-notch content to captivate your audience.</p>
            <p><strong>Create:</strong> Effortlessly produce compelling articles and posts with our intuitive tools.</p>
            <p><strong>Reach:</strong> Expand your audience reach and boost engagement with targeted strategies.</p>
            <p><strong>Measure:</strong> Gain deep insights into your performance with advanced analytics.</p>
            <p><strong>Optimize for ROI:</strong> Experience features designed to maximize your return on investment, ensuring consistent success. No more excuses for not achieving outstanding results.</p>
            <h2>Comprehensive and User-Friendly Tools:</h2>
            <p><strong>My Feeds:</strong> Customize your content feed to stay ahead of trends and innovations.</p>
            <p><strong>Community Feeds:</strong> Connect and collaborate with a vibrant community of marketers.</p>
            <p><strong>Our Team:</strong> Easily contact your teammates within Cream, fostering seamless communication and collaboration.</p>
            <p><strong>Newsletter:</strong> Send personalized, bulk emails effortlessly through Amazon SES.</p>
            <p><strong>GenAI Creator:</strong> Leverage AI to create high-quality articles, code, and more.</p>
            <p><strong>Request Article:</strong> On-demand AI-generated articles tailored to your needs.</p>
            <p><strong>Analytics:</strong> Monitor where and when your posts are read, and track their impact globally.</p>
            <p><strong>Group Chat:</strong> Foster meaningful conversations and collaborations with group chat functionality.</p>
            <h2>Why Choose Cream?</h2>
            <p>Experience a Revolutionary Approach: Cream is engineered to redefine digital and content marketing.</p>
            <p>Features Optimized for Success: Our tools are crafted to ensure you achieve the best possible ROI.</p>
            <p>Consistency in Excellence: No more excuses for not being consistently successful in your marketing efforts.</p>
            <h2>Join the Future of Marketing Today!</h2>
            <p>Contact Us: <a href="mailto:prashanth@knobly.com">prashanth@knobly.com</a></p>
            <p>Visit Us: <a href="https://knoblycream.com">https://knoblycream.com</a></p>
            <a href="https://knoblycream.com" class="button">Explore More</a>
        </div>
        <div class="footer">
            <p>&copy; 2024 Knobly Cream. All rights reserved.</p>
        </div>
    </div>
</body>
</html>
';

try {
    // Server settings
    $mail->isSMTP();
    $mail->Host       = 'email-smtp.ap-south-1.amazonaws.com';
    $mail->SMTPAuth   = true;
    $mail->Username   = 'AKIARWSGL3TOGXCYQJVY';
    $mail->Password   = 'BIj9DvNM3uX+cckSX4So50fqln6DEhie6dMJpe3AjzqK';
    $mail->SMTPSecure = 'tls';
    $mail->Port       = 587;

// Sender info
    $mail->setFrom($senderEmail, 'Knobly Support');

// Email content
    $mail->isHTML(true);
    $mail->Subject = $subject;
    $mail->Body    = $bodyText;
    $mail->AltBody = strip_tags($bodyText);

// Send email to each recipient
    foreach ($recipientEmails as $recipient) {
        $mail->addAddress($recipient);

$mail->send();
        echo "Email sent to: " . $recipient . "\n";

// Clear all recipients for the next iteration
        $mail->clearAddresses();
    }

} catch (Exception $e) {
    echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}
?>