OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	01/21/2025 10:39:45 AM	rwxr-xr-x
📄 config.php	9.42 KB	01/21/2025 10:39:35 AM	rw-r--r--
📄 db_connect.php	261 bytes	01/21/2025 10:39:36 AM	rw-r--r--
📄 function.php	2.72 KB	01/21/2025 10:39:36 AM	rw-r--r--
📄 genai_func.js	15.21 KB	01/21/2025 10:39:38 AM	rw-r--r--
📄 handler.php	6.06 KB	01/21/2025 10:39:37 AM	rw-r--r--
📄 validate.logged.php	1.01 KB	01/21/2025 10:39:38 AM	rw-r--r--

Editing: handler.php

<?php
header("Content-Type: application/json");

include 'db_connect.php';
include 'function.php';

// Get the JSON data
$jsonData = file_get_contents("php://input");

// Decode the JSON data
$data = json_decode($jsonData, true);

// Initialize the response array
$response = [
    "status" => "error",
    "message" => "Invalid input data"
];

// Check if data is valid
if (isset($data['request'], $data['feedId'])) {
    $request = $data['request'];
    $feedId = $data['feedId'];

if ($request === 'loadLike') {
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                $flag = checkLike($conn, $userId, $feedId);

$response = [
                    "status" => "success",
                    "response" => $flag
                ];
            } catch (Exception $e) {
                // Log the error message
                error_log($e->getMessage());

$response = [
                    "status" => "error",
                    "message" => "An error occurred while checking like status."
                ];
            }
        }
    } elseif ($request === 'likeCount') {
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                $count = likeCount($conn, $feedId);

$response = [
                    "status" => "success",
                    "count" => $count
                ];
            } catch (Exception $e) {
                // Log the error message
                error_log($e->getMessage());

$response = [
                    "status" => "error",
                    "message" => "An error occurred while checking like status."
                ];
            }
        }
    } elseif ($request === 'like') {
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                // Insert like into the database
                $sql = "INSERT INTO reader_thumbs_up (userId, articleId) VALUES (?, ?)";
                $stmt = $conn->prepare($sql);
                $stmt->bind_param("ii", $userId, $feedId);
                $stmt->execute();

$response = [
                    "status" => "success"
                ];
            } catch (Exception $e) {
                error_log($e->getMessage());
                $response = [
                    "status" => "error",
                    "message" => "An error occurred while adding a like."
                ];
            }
        }
    } elseif ($request === 'unlike') {
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                // Remove like from the database
                $sql = "DELETE FROM reader_thumbs_up WHERE userId = ? AND articleId = ?";
                $stmt = $conn->prepare($sql);
                $stmt->bind_param("ii", $userId, $feedId);
                $stmt->execute();

$response = [
                    "status" => "success"
                ];
            } catch (Exception $e) {
                error_log($e->getMessage());
                $response = [
                    "status" => "error",
                    "message" => "An error occurred while removing a like."
                ];
            }
        }
    } elseif ($request === 'checkColl'){
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                // Prepare SQL statement to check likes
                $sql = "SELECT COUNT(*) AS count FROM reader_collection WHERE user_id = ? AND feed_id = ?";
                $stmt = $conn->prepare($sql);
                $stmt->bind_param("ii", $userId, $feedId);
                $stmt->execute();
                
                // Fetch the result
                $result = $stmt->get_result(); // Use get_result to fetch results
                $row = $result->fetch_assoc();
                $count = isset($row['count']) ? (int)$row['count'] : 0;
        
                $response = [
                    "status" => "success",
                    'count' => $count
                ];
            } catch (Exception $e) {
                error_log($e->getMessage());
                $response = [
                    "status" => "error",
                    "message" => "An error occurred while checking the like."
                ];
            }
        }
    } elseif ($request === 'addColl') {
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                // Insert like into the database
                $sql = "INSERT INTO reader_collection (user_id, feed_id) VALUES (?, ?)";
                $stmt = $conn->prepare($sql);
                $stmt->bind_param("ii", $userId, $feedId);
                $stmt->execute();
                $response = [
                    "status" => "success"
                ];
            } catch (Exception $e) {
                error_log($e->getMessage());
                $response = [
                    "status" => "error",
                    "message" => "An error occurred while adding a like."
                ];
            }
        }
    }elseif ($request === 'removeColl') {
        if (isset($data['userId'])) {
            $userId = $data['userId'];
            try {
                // Insert like into the database
                $sql = "DELETE FROM reader_collection WHERE user_id = ? AND feed_id = ?";
                $stmt = $conn->prepare($sql);
                $stmt->bind_param("ii", $userId, $feedId);
                $stmt->execute();
                $response = [
                    "status" => "success"
                ];
            } catch (Exception $e) {
                error_log($e->getMessage());
                $response = [
                    "status" => "error",
                    "message" => "An error occurred while removing a like."
                ];
            }
        }
    }
}

// Send the JSON response
echo json_encode($response);