<?
$sayac = intval($_POST["sayfa"]);
function KodTemizle($text)
{
    $gkod = array(" ", "?", "I", "İ", ",", "Ş", "Ç", "ç", "Ğ", "ğ");
    $dkod = array("-", "_", "i", "i", "", "s", "c", "c", "g", "g");
 
    $ykod = str_replace($gkod, $dkod, $text);
    return $ykod;
}
header("content-type:text/html; charset=iso-8859-9");
//$aranan=$_GET["ara"];
//echo "Aranan kelime : $aranan<p>";
//$kackayit =$sayac+150;
$sayac = $CanCeLcik;
$kackayit = $sayac + 100;
//$sayac=2000;
//$kackayit=2005;
while ($sayac < $kackayit)
{
    $metin = file_get_contents("http://www.sarki-sozleri.net/?p=$sayac");
    preg_match('#<h1 class="post-title">(.*?)</h1>#si', $metin, $title);
    preg_match('#rel="category tag">(.*?)</a>#si', $metin, $kat);
    preg_match('#div class="post-content">(.*?)<!-- post-id -->#si', $metin, $icerik);
    $kes1 = mysql_real_escape_string(trim(strip_tags($title[1])));
    $kes = iconv("UTF-8", "windows-1254", @$kes1);
    $kategori_adi = mysql_real_escape_string(trim(strip_tags($kat[1], '<p><center>')));
    $icerikmi = iconv("UTF-8", "windows-1254", mysql_real_escape_string(trim(strip_tags
        ($icerik[1], '<b><p><center><br>'))));
    $ozet = substr($icerikmi, 0, 250) . "<br>Devamı";
    $seobaslik = strtolower(KodTemizle($kes));
    $kategori_seo = strtolower(KodTemizle($kategori_adi));
    echo "$kes - > $kategori_adi<br><br>";
    if ($kes == "")
    {
        echo "<strong>$sayac</strong> Nolu İçerik Boştur<p> ";
        $handle = fopen("programlama1.txt", "w");
        fwrite($handle, $sayac);
        fclose($handle);
        $sayac++;
    } else
    {
        $basliksor = mysql_fetch_array(mysql_query("Select * from blogs where title='$seobaslik'"));
        if ($basliksor != '0')
        {
            echo "Bu İçerikler Zaten DAha Önce Girilmiş >>>>>  <strong>$kes</strong> -->>>> $sayac";
            $handle = fopen("programlama.txt", "w");
            fwrite($handle, $sayac);
            fclose($handle);
            $sayac++;
        } else
        {
                $ekleyenuser = "alper";
                $ekleyenisim = "Alper Ozkan";
                $katid = "33";
                $ekle = mysql_query("insert into blogs values(NULL, '$ekleyenuser', NULL, 'white', '$icerikmi', '$kes', '$kes', '$kes', 0, NOW(), NOW(), 0, 0, 0, '$katid', '$kes', NULL, NULL, NULL, '$ekleyenisim', NULL, 1)");
                if ($ekle)
                {
                    echo "<strong>$sayac</strong>  Kayitlar tamam<br>";
                    $handle = fopen("programlama.txt", "w");
                    fwrite($handle, $sayac);
                    fclose($handle);
                    $sayac++;
                } else
                {
                    echo "<strong>$sayac</strong> İçerikli Konular Vt ye Eklenemedi";
                    $handle = fopen("programlama.txt", "w");
                    fwrite($handle, $sayac);
                    fclose($handle);
                    $sayac++;
                }
        }
    }
}
?>