• 17-04-2022, 15:51:33
    #1
    Aşağıdaki kod yapısında veri çekilen yerde Metin varsa metin çekiyor, Resim varsa da Resim çekiyor, fakat Metin+Resim varsa sadece metni alıyor bunu Metin+Resim çekme yapabilir miyiz?
    <?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;
    
    ?>
  • 21-04-2022, 14:48:34
    #2
    Bu konuda bilgisi olan yok mudur acaba?
  • 21-04-2022, 21:55:00
    #3
    Web Tasarım ve Yazılım
    KhanJitsu adlı üyeden alıntı: mesajı görüntüle
    Aşağıdaki kod yapısında veri çekilen yerde Metin varsa metin çekiyor, Resim varsa da Resim çekiyor, fakat Metin+Resim varsa sadece metni alıyor bunu Metin+Resim çekme yapabilir miyiz?
    <?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;
    
    ?>
    <?php
    include_once 'simple/HtmlDocument.php';
    use simplehtmldomHtmlDocument;
    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;
    $soru_resim= "https://www.xxx.com".$sorular->find(".quiz__question__question >img",0)->getAttribute("src");
    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;

    ?>
    İmg sorgusunu if in dışına alıp bir deneyebilir miyiz
  • 21-04-2022, 21:55:22
    #4
    Web Tasarım ve Yazılım
    <?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;
     $soru_resim= "https://www.xxx.com".$sorular->find(".quiz__question__question >img",0)->getAttribute("src");
    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;
     
    ?>
  • 21-04-2022, 22:00:09
    #5
    bostanci96 adlı üyeden alıntı: mesajı görüntüle
    <?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;
     $soru_resim= "https://www.xxx.com".$sorular->find(".quiz__question__question >img",0)->getAttribute("src");
    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;
     
    ?>
    Bu sayfa çalışmıyor hatası verdi hocam bu işlemi yaptıktan sonra.
  • 21-04-2022, 22:05:18
    #6
    Web Tasarım ve Yazılım

    Şunu if in dışına aldım sadece ama acaba kodu yapıştırırken mi yanlışlık oldu
  • 21-04-2022, 23:00:34
    #7
    @bostanci96; arkadaş hatayı çözmüştür kendisine çok teşekkür ederim.