One Hat Cyber Team

Your IP : 3.142.131.16

Server IP : 50.28.103.30

Server : Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64

Server Software : nginx/1.24.0

PHP Version : 8.3.12

Buat File | Buat Folder

Dir : ~/www/wwwroot/ef.electronharmony.com/2/

View File Name : addurlhome.php

<?php
include 'mysql.php';

header('Content-Type: application/json');

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    echo json_encode(['success' => false, 'message' => 'Database connection failed: ' . $conn->connect_error]);
    exit;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $urls = $conn->real_escape_string($_POST['urls']);
    $titles = $conn->real_escape_string($_POST['titles']);
    $logos = $conn->real_escape_string($_POST['logos']);
    $keywordss = $conn->real_escape_string($_POST['keywordss']);
    $descriptions = $conn->real_escape_string($_POST['descriptions']);
    $countrys = $conn->real_escape_string($_POST['countrys']);
    $categoryss = $conn->real_escape_string($_POST['categoryss']);
    $statuss = 'No';

    // Check if there is already an entry for today
    $today = date('Y-m-d'); // Get current date
    $checkSql = "SELECT id FROM url_entries WHERE DATE(created_at) = '$today' LIMIT 1";
    $checkResult = $conn->query($checkSql);

    if ($checkResult->num_rows > 0) {
        echo json_encode(['success' => false, 'message' => 'You can only add one entry per day.']);
        exit;
    }

    // Insert new entry
    $sql = "INSERT INTO url_entries (urls, titles, logos, keywordss, descriptions, countrys, categoryss, statuss, created_at) 
            VALUES ('$urls', '$titles', '$logos', '$keywordss', '$descriptions', '$countrys', '$categoryss', '$statuss', NOW())";

    if ($conn->query($sql) === TRUE) {
        echo json_encode(['success' => true, 'message' => 'Data inserted successfully']);
    } else {
        echo json_encode(['success' => false, 'message' => 'Error inserting data: ' . $conn->error]);
    }
} else {
    echo json_encode(['success' => false, 'message' => 'Invalid request method. Only POST is allowed.']);
}

$conn->close();
?>