<?php
include_once 'simple/HtmlDocument.php';
use simplehtmldom\HtmlDocument;
error_reporting(E_ALL);
function sef_link($baslik)
{
    $baslik = str_replace(array("&quot;","'"), NULL, $baslik); // tırnaklar için replace
    $bul = array('Ç', 'Ş', 'Ğ', 'Ü', 'İ', 'Ö', 'ç', 'ş', 'ğ', 'ü', 'ö', 'ı', '-');
    $yap = array('c', 's', 'g', 'u', 'i', 'o', 'c', 's', 'g', 'u', 'o', 'i', ' ');
    $perma = strtolower(str_replace($bul, $yap, $baslik));
    $perma = preg_replace("@[^A-Za-z0-9\-_]@i", ' ', $perma);
    $perma = trim(preg_replace('/\s+/',' ', $perma));
    $perma = str_replace(' ', '-', $perma);
    return $perma;
}
function bilgi_cek($url){
$headers=array(

'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36',
);


$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_NOBODY, false);



curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);

curl_setopt($ch, CURLOPT_HEADER, false);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$server_output = curl_exec($ch);
curl_close ($ch);
return $server_output;
}
$veri=bilgi_cek($_POST["link"]);
$doc = new HtmlDocument();
$html = $doc->load($veri);
$ana=$html->find(".quiz__questions > div");
//print_r($ana);
//exit;
$sql_code="";

foreach ($ana as $sorular){
    $soru_resim="";
$soru_sira= $sorular->find(".quiz__question__question-number",0)->plaintext;
$soru= $sorular->find(".quiz__question__question",0)->plaintext;
if($sorular->find(".quiz__question__question >img",0)){
    $soru_resim= "https://www.xxx.com".$sorular->find(".quiz__question__question >img",0)->getAttribute("src");
}


$sık_1= $sorular->find(".quiz__question__answers__answer",0)->plaintext;
$sık_2= $sorular->find(".quiz__question__answers__answer",1)->plaintext;
$sık_3= $sorular->find(".quiz__question__answers__answer",2)->plaintext;
$sık_4= $sorular->find(".quiz__question__answers__answer",3)->plaintext;
$aciklama= $sorular->find(".quiz__question__result",0)->plaintext;
$cevap_sik="";
foreach($sorular->find('.quiz__question__answers__answer') as $a){
    if($a->getAttribute("data-iscorrect")=="true"){
        $sik=$a->getAttribute("data-i");
    
        if($sik==1){
            $cevap_sik="A";
        }
        else if($sik==2){
            $cevap_sik="B";
        }
        else if($sik==3){
            $cevap_sik="C";
        }
        else if($sik==4){
            $cevap_sik="D";
        }
        $cevap= $a->plaintext;
    
        break;
    }

}
if($soru_resim!=""){
    
    $soru_resim='<img src="'.$soru_resim.'" alt="">';
}
$sql_code.= "INSERT INTO `question` (`image`,`question_type`,`category`, `subcategory`, `question`, `optiona`, `optionb`, `optionc`, `optiond`, `optione`, `answer`, `level`, `note`) VALUES
('','1','".$_POST["kategori"]."', '".$_POST["alt_kategori"]."', '".str_replace("'","`",$soru)." ".$soru_resim."', '".str_replace("'","`",$sık_1)."','".str_replace("'","`",$sık_2)."', '".str_replace("'","`",$sık_3)."', '".str_replace("'","`",$sık_4)."', '', '".$cevap_sik."', '".$_POST["level"]."', '".str_replace("'","`",$aciklama)."');";






}
file_put_contents(time().".txt", $sql_code);
echo $sql_code;

?>