Gecko [ myeducation.co.th ]

Name	Size	Permission
config	[ DIR ]	drwxr-xr-x
.htaccess	740 B	-rwxr-xr-x
category_content.php	3.02 KB	-rwxr-xr-x
config.php	460 B	-rwxr-xr-x
content_ram_web.php	5.97 KB	-rwxr-xr-x
content_ram_web2.php	5.97 KB	-rw-r--r--
content_ttt_view.php	957 B	-rwxr-xr-x
index.html	0 B	-rwxr-xr-x
update_view_content.php	1.46 KB	-rwxr-xr-x

Code Editor : content_ram_web2.php

<?php
header('Access-Control-Allow-Origin: *'); // Replace * with your domain for better security
header('Content-Type: application/json');

include 'config/ram_web_2023.php';

if (isset($_GET['ID'])) {
    $ID = trim($_GET['ID']);
} else {
    echo json_encode(['error' => 'No ID provided']);
    exit;
}

try {
    // Query for home content
    $stmt = $pdo->prepare("
        SELECT home.Home_ID, home.Member_ID, home.Home_Date, home.Home_Time, 
        home.Home_Visitors, home.Home_Sub, home.Home_Short, home.Home_Detail,
        home.Home_Category, home.StatusHome_ID, home.StatusShowPage_ID , home.Home_aa_chat
        FROM home
        WHERE home.StatusHome_ID = 1 AND home.Home_ID = :id
        ORDER BY home.Home_ID DESC
    ");
    $stmt->execute(['id' => $ID]);
    $homeData = $stmt->fetch(PDO::FETCH_ASSOC);

if ($homeData) {
        $HomeID = $homeData["Home_ID"];
        $Check_HomeDetai2 = urldecode($homeData["Home_Detail"]);

// Query for home images
        $stmtImg = $pdo->prepare("
            SELECT img_home.Home_ID, img_home.ImgHome_Img,
            img_home.ImgHome_Sort, img_home.StatusImgHome_ID
            FROM img_home
            WHERE img_home.Home_ID = :homeId
            ORDER BY img_home.ImgHome_Sort ASC 				
            LIMIT 1
        ");
        $stmtImg->execute(['homeId' => $HomeID]);
        $homeImageData = $stmtImg->fetch(PDO::FETCH_ASSOC);
        
                $homeData['image'] =  $HomeImg_Img; 
                if ($homeImageData) {

if (preg_match('/^https?:\/\//i', $homeImageData['ImgHome_Img'])) {
                        $homeImageData['ImgHome_Img'] = $homeImageData['ImgHome_Img'];
                    }else{
                        $homeImageData['ImgHome_Img'] = "https://maracar.rampagesoft.com/model/upload/img/IMG_Home/" . $homeImageData['ImgHome_Img'];
                    }
                                       
                    $homeData['image'] = $homeImageData;

} else {
                    $homeData['image'] = null;
                }

// Check if Home_aa_chat is empty or null
        if (empty($homeData['Home_aa_chat'])) {
            $api_key = "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";
            $text_to_summarize = $Check_HomeDetai2;

// Initialize cURL session for GPT API
            $ch = curl_init();

// API URL for GPT-3.5 Turbo chat-based model
            curl_setopt($ch, CURLOPT_URL, 'https://api.openai.com/v1/chat/completions');
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
            curl_setopt($ch, CURLOPT_POST, 1);

// Set headers
            $headers = [
                'Content-Type: application/json',
                'Authorization: Bearer ' . $api_key
            ];
            curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

// Set data
            $data = [
                "model" => "gpt-4o-mini",
                "messages" => [
                    [
                        "role" => "system",
                        "content" => "You are a helpful assistant that summarizes text."
                    ],
                    [
                        "role" => "user",
                        "content" => "สรุปเนื้อหาข้างต้นไม่เกิน 100 คำ ในรูปแบบเรียงความที่ต่อเนื่อง และเป็นธรรมชาติ :"
                    ],
                    [
                        "role" => "user",
                        "content" => $text_to_summarize
                    ],
                    [
                        "role" => "user",
                        "content" => "เขียนแคมเปญการตลาด แนะนำบริการ ของ TTT-WEBSITE.com ให้สอดคล้องกับเนื้อหา เป็นรูปแบบบทความเท่านั้น"
                    ],
                    [
                        "role" => "user",
                        "content" => "ให้เรียบเรียง แคมเปญการตลาด ให้เข้ากับ เนื้อหาบทความ เป็นรูปแบบ Social Media Posts เพื่อดึงดูดผู้อ่าน และเป็นระเบียบสวยงาม แบบมืออาชีพ และเป็นธรรมชาติ TTT-WEBSITE.com"
                    ]
                ],
                "max_tokens" => 500,  // Limit the response to 256 tokens
            ];

// Send the JSON payload
            curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));

// Execute cURL session and get the response
            $result = curl_exec($ch);
            $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

// Check for errors
            if ($httpcode !== 200) {
                echo json_encode(['error' => 'Error calling GPT API', 'http_code' => $httpcode, 'response' => curl_error($ch)]);
            } else {
                $decoded_result = json_decode($result, true);
                $assistant_message = $decoded_result['choices'][0]['message']['content'];

// Update Home_aa_chat in database
                $add_aa_chat = urlencode($assistant_message);
                $sql_update = "UPDATE home SET Home_aa_chat = :aa_chat WHERE Home_ID = :home_id";
                $stmtUpdate = $pdo->prepare($sql_update);
                $stmtUpdate->execute(['aa_chat' => $add_aa_chat, 'home_id' => $HomeID]);

// Update the homeData array with new Home_aa_chat
                $homeData['Home_aa_chat'] = $assistant_message;
            }

// Close cURL session
            curl_close($ch);
        }

echo json_encode($homeData);
    } else {
        echo json_encode(['error' => 'No data found']);
    }

} catch (PDOException $e) {
    echo json_encode(['error' => $e->getMessage()]);
}
?>

${this.title}

Code Editor : content_ram_web2.php