$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 wp_posts where post_name='$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{
$kategori_kontrol=mysql_num_rows(mysql_query("Select * from wp_terms where slug='$kategori_seo'"));
if ($kategori_kontrol=='0') {
mysql_query("Insert Into wp_terms (name,slug,term_group) values ('$kategori_adi','$kategori_seo','0')");
$k_sql=mysql_fetch_array(mysql_query("Select * from wp_terms where slug='$kategori_seo'"));
$kid=$k_sql[term_id];
mysql_query("Insert Into wp_term_taxonomy (term_id,taxonomy,description) values ('$kid','category','$kategori_adi')");
$taxonomy_sql=mysql_fetch_array(mysql_query("Select * from wp_term_taxonomy where term_id='$kid'"));
$taxonomy_id=$taxonomy_sql[term_taxonomy_id];
}else {
$k_sql=mysql_fetch_array(mysql_query("Select * from wp_terms where slug='$kategori_seo'"));
$kid=$k_sql[term_id];
$taxonomy_sql=mysql_fetch_array(mysql_query("Select * from wp_term_taxonomy where term_id='$kid'"));
$taxonomy_id=$taxonomy_sql[term_taxonomy_id];
$ekle=mysql_query("Insert Into wp_posts (post_author,post_category,post_title,post_name,post_content,post_date,post_date_gmt,post_excerpt) values ('1','$kid','$kes','$seobaslik','$icerikmi','$tarih','$tarih','$ozet')");
$sid=mysql_insert_id();
$v=mysql_fetch_array(mysql_query("Select * from wp_posts where post_name='$seobaslik'"));
$ekle.=mysql_query("Insert Into wp_term_relationships (object_id,term_taxonomy_id) values ('$v[ID]','$taxonomy_id')");
$ekle.=mysql_query("Insert Into wp_postmeta (meta_id,post_id,meta_key,meta_value) values ('$kid','$v[ID]','_wp_old_slug','$kes')");
$ekle.=mysql_query("Insert Into wp_term_relationships (object_id,term_taxonomy_id) values ('$v[ID]','4')");
$ekle.=mysql_query("Insert Into wp_postmeta (meta_id,post_id,meta_key,meta_value) values ('$tagid','$v[ID]','_edit_last','$kes')");
mysql_query("Update wp_term_taxonomy set count=count+1 where term_id='$kid'");
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++;
}
}
}}
}
?> kendi php scriptimin mysql ( sql ) dosyasıda bu sekilde..
CREATE TABLE `blogs` ( `blogsid` bigint(15) unsigned NOT NULL auto_increment, `username` varchar(255) NOT NULL default '', `bbackground` varchar(255) NOT NULL default '', `pagecolor` varchar(10) NOT NULL default '', `blog` longtext, `metak` longtext NOT NULL, `metad` longtext NOT NULL, `metat` longtext NOT NULL, `numviews` int(10) unsigned default '0', `upldate` datetime default NULL, `updated` datetime NOT NULL default '0000-00-00 00:00:00', `numemails` int(10) unsigned default '0', `numprints` int(10) unsigned default '0', `numsaved` int(10) unsigned default '0', `categoryid` int(10) unsigned default NULL, `title` varchar(100) default NULL, `memadsen` varchar(255) NOT NULL default '', `shopadsen` varchar(255) NOT NULL default '', `yahoadsen` varchar(255) NOT NULL default '', `contributor` varchar(100) default NULL, `imp` varchar(255) NOT NULL default '', `status` smallint(1) NOT NULL default '0', PRIMARY KEY (`blogsid`) ) TYPE=MyISAM;
örnek girilmis bir sql verisi
(200, 'alper', '', 'white', sýðmayacak kadar\r\nbüyük bir sevgimiz olduðunu sakýn unutma !', 'sevgi mesajlari,güzel sözleri', 'sevgi mesajlari,güzel sözleri', 'sevgi mesajlari,güzel sözleri', 0, '2008-09-05 23:57:12', '2008-09-05 23:57:12', 0, 0, 0, 33, 'Bu kartanesi', '', '', '', 'Alper Ozkan', '56', 1),
bunu nasıl editleyebilirim arkadaşlar acaba bir fikri olan varmi bu konuda.
yada yardimci olabilecek bir arkadasim varmi
soruna yardimci olan arkadasa populer bir siiteden text link verecegim foter den