<?php

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$baslik = trim($_POST["T1"]);
$metni = $_POST["T2"];
$tag = $_POST["T7"];
$kat = $_POST["T9"];
$gorsel = "https://tuuuq.com/post-img/unlu.jpg";

// Link oluşturma
$bul = trim($baslik);
$bulunacak = array('ç','Ç','ı','İ','ğ','Ğ','ü','ö','Ş','ş','Ö','Ü',',',' ','(',')','[',']',':','?','(',')','--',':','ä',"á"); 
$degistir  = array('c','C','i','I','g','G','u','o','S','s','O','U','','-','','','','','-','','','','',"-","a","a");   
$link = str_replace($bulunacak, $degistir, $bul);
$link = preg_replace('/[^a-zA-Z0-9-]/', '-', $link);
$link = preg_replace('/-+/', '-', $link);

// Veritabanı bağlantısı
$servername = "localhost";
$database = "tuuuq";
$username = "paslaa";
$password = "f5tfrdd4rd4rdtgyhutfxg";

$conn = mysqli_connect($servername, $username, $password, $database);
$conn->set_charset("utf8");

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Aynı başlık var mı kontrol et
$stmt = $conn->prepare("SELECT id FROM paylasim WHERE baslik = ?");
$stmt->bind_param("s", $baslik);
$stmt->execute();
$stmt->store_result();

if ($stmt->num_rows > 0) {
    echo "Bu kayıt zaten var!";
} else {
    // Yeni kayıt ekle
    $stmt = $conn->prepare("INSERT INTO paylasim (baslik, metni, tag, kat, link, google, gorsel, otopost, otovideo, hit,otopost2,aciklama) VALUES (?, ?, ?, ?, ?, '', ?, '', '', 0,'','')");
    $stmt->bind_param("ssssss", $baslik, $metni, $tag, $kat, $link, $gorsel);

    if ($stmt->execute()) {
        echo ";Kayıt eklendi";
    } else {
        echo "Hata: " . $stmt->error;
    }
}

$stmt->close();
$conn->close();

?>