OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 db.php	368 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 demoForm.html	1.99 KB	04/10/2025 08:12:36 AM	rw-r--r--
📄 news_pagination.json	35 bytes	04/10/2025 05:40:59 AM	rwxrwxrwx
📄 posts_pagination.json	52 bytes	04/10/2025 05:44:17 AM	rwxrwxrwx
📄 saveDemo.php	1.82 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 send_log.txt	68.41 KB	04/10/2025 05:52:23 AM	rwxrwxrwx
📄 webhook_post_log.txt	272.88 KB	04/09/2025 09:25:07 AM	rwxrwxrwx
📄 whatsappAPI.php	22 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 whatsapp_messages.log	9.53 KB	04/10/2025 05:52:22 AM	rw-rw-rw-

Editing: saveDemo.php

<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "cream";

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

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

ini_set('display_startup_errors', 1);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $date = $_POST['date'] ?? '';
    $time = $_POST['time'] ?? '';
    $description = $_POST['description'] ?? '';

if (empty($date) || empty($time) || empty($description)) {
        echo "Error: All fields are required.";
        exit;
    }

$dateObject = DateTime::createFromFormat('Y-m-d', $date);
    if (!$dateObject) {
        echo "Error: Invalid date format.";
        exit;
    }
    $formattedDate = $dateObject->format('d-m-Y');

$dayFormatter = new IntlDateFormatter(
        'kn_IN',
        IntlDateFormatter::FULL,
        IntlDateFormatter::NONE,
        'Asia/Kolkata',
        IntlDateFormatter::GREGORIAN
    );
    $eventDay = $dayFormatter->format($dateObject);
    $eventDay = explode(',', $eventDay)[0];

$timeObject = DateTime::createFromFormat('H:i', $time);
    if (!$timeObject) {
        echo "Error: Invalid time format.";
        exit;
    }
    $eventTime = $timeObject->format('g:i A');

$sql = "INSERT INTO bookdemo (event_date, event_day, event_time, description) VALUES (?, ?, ?, ?)";
    $stmt = $conn->prepare($sql);
    if ($stmt === false) {
        echo "Error: " . $conn->error;
        exit;
    }

$stmt->bind_param("ssss", $formattedDate, $eventDay, $eventTime, $description);

if ($stmt->execute()) {
        echo "Success: Event added successfully.";
    } else {
        echo "Error: " . $stmt->error;
    }

$stmt->close();
    $conn->close();
} else {
    echo "Invalid request.";
}