PHP Dosya Yöneticisi

<?php
include("inc/config.php");

function hizirgpt_send_api_request($prompt) {
    global $db;

$siteayar = $db->query("SELECT * FROM ayarlar WHERE id = 1")->fetch(PDO::FETCH_ASSOC);
    $api_key = $siteayar['chatgpt'];
    $url = 'https://api.openai.com/v1/completions';
    $post_fields = array(
        "model" => "gpt-3.5-turbo-instruct",
        "prompt" => $prompt,
        "max_tokens" => 2000,
        "temperature" => 0
    );
    $header  = [
        'Content-Type: application/json',
        'Authorization: Bearer ' . $api_key
    ];
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($post_fields));
    curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
    $result = curl_exec($ch);
    if (curl_errno($ch)) {
        echo 'Error: ' . curl_error($ch);
    }
    curl_close($ch);
    $response = json_decode($result);
    return $response->choices[0]->text;
}

function hizirgpt_send_requests() {
    global $db;
    $siteayar = $db->query("SELECT * FROM ayarlar WHERE id = 1")->fetch(PDO::FETCH_ASSOC);

$baslikgetir = $db->prepare("SELECT * FROM gptbaslik");
    $baslikgetir->execute();
    $basliklar = $baslikgetir->fetchAll(PDO::FETCH_ASSOC);
    $prompt1 = $db->query("SELECT * FROM promptlar WHERE id = 1")->fetch(PDO::FETCH_ASSOC)['prompt'];
    $prompt2 = $db->query("SELECT * FROM promptlar WHERE id = 2")->fetch(PDO::FETCH_ASSOC)['prompt'];
    $prompt3 = $db->query("SELECT * FROM promptlar WHERE id = 3")->fetch(PDO::FETCH_ASSOC)['prompt'];
    $yanitlar = array();

// Fetch the list of categories
    $kategoriList = cokluveri("kategori", $db);

foreach ($kategoriList as $kategori) {
        $kategoriId = $kategori["id"]; // Fetch the category ID correctly

// Create a prepared statement to select basliklar for this category
        $basliksay = $db->prepare("SELECT * FROM gptbaslik WHERE kategori_id = ?");
        $basliksay->execute([$kategoriId]); // Execute the query for each category
        $basliksayi = $basliksay->rowCount();
        $basliksay = $db->prepare("SELECT * FROM gptbaslik");
        $basliksay->execute();
        $basliksayi = $basliksay->rowCount();
        if ($basliksayi == 0) {
            echo 'no';
        }

foreach ($basliklar as $baslik) {
            $prompt1 = str_replace('[keyword]', $baslik['baslik'], $prompt1);
            $prompt2 = str_replace('[keyword]', $baslik['baslik'], $prompt2);
            $prompt3 = str_replace('[keyword]', $baslik['baslik'], $prompt3);

$response1 = hizirgpt_send_api_request($prompt1);
            $yanit1 = $response1;

if ($yanit1) {
                $response2 = hizirgpt_send_api_request($prompt2);
                $yanit2 = $response2;
            }

if ($yanit2) {
                $response3 = hizirgpt_send_api_request($prompt3);
                $yanit3 = $response3;
            }
            $yanit = $yanit1 . "\n" . $yanit2 . "\n" . $yanit3;

if ($yanit3) {
                $curl = curl_init();
                curl_setopt_array($curl, array(
                    CURLOPT_URL => 'https://api.pexels.com/v1/search?query='.urlencode($baslik['baslik']),
                    CURLOPT_RETURNTRANSFER => true,
                    CURLOPT_ENCODING => '',
                    CURLOPT_MAXREDIRS => 10,
                    CURLOPT_TIMEOUT => 0,
                    CURLOPT_FOLLOWLOCATION => true,
                    CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                    CURLOPT_CUSTOMREQUEST => 'GET',
                    CURLOPT_HTTPHEADER => array(
                        'Authorization: '.$siteayar['pixabay']
                    ),
                ));
                $response = curl_exec($curl);
                $response = json_decode($response);
                $resim = $response->photos[0]->src->original;
                $first_image_url = $resim;
                $dosyaAdi = '../uploads/' . uniqid() . '.png';
                if ($first_image_url) {
                    copy($first_image_url, $dosyaAdi);
                } else {
                    $dosyaAdi = '';
                }
                $seobaslik = $baslik['baslik'];
                $baslikSlug = seolink($baslik['baslik']);
                $link = seolink($baslik['baslik']);
                $kategori = $kategoriId; // Use the fetched category ID
                $seoaciklama = substr($yanit, 0, 160);
                $html = '<h2 id="sonuc">Sonuç</h2> ';
                $html = preg_replace('/<h2 id="sonuc">(.*?)<\/h2>/', '', $html);
                $sql = "INSERT INTO blog (baslik, icerik, kategori, seobaslik, seodescription, seolink, tur, resim) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

$stmt = $db->prepare($sql);
                if ($stmt->execute([$baslik['baslik'], $yanit, $kategori, $seobaslik, $seoaciklama, $link, 'blog', $dosyaAdi])) {
                    echo json_encode(['status' => 'success', 'message' => 'Yazı başarıyla yayımlandı.']);
                } else {
                    $errorInfo = $stmt->errorInfo();
                    echo json_encode(['status' => 'error', 'message' => 'Yazı yayımlanırken bir hata oluştu. SQL Hatası: ' . $errorInfo[2]]);
                }
                $basligisil = $db->prepare("DELETE FROM gptbaslik WHERE baslik = ?");
                $basligisil->execute(array($baslik['baslik']));
                die();
            }
        }
    }
    return $yanitlar;
}

$yanitlar = hizirgpt_send_requests();
foreach ($yanitlar as $yanit) {
    echo '<pre>' . print_r($yanit, true) . '</pre>';
}
?>

İptal

📁 PHP Dosya Yöneticisi

📝 openx.php

📝 openx.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)