<?php
$arrContextOptions=array(
    "ssl"=>array(
        "verify_peer"=>false,
        "verify_peer_name"=>false,
    ),
);  
$text = iconv("UTF-8","ISO-8859-9",$text);

$response = file_get_contents("http://www.sektorel.com/sektorler", false, stream_context_create($arrContextOptions));
 
    	  preg_match_all('@<h3><a href="(.*?)</a>@si',$response,$kategori); 
		 $say = count($kategori[0]);
 ?>
  	 <form action="index.php" method="post">
<td>Firma Türleri</td><td>
<select name="ad">
<?
for($i =0; $i <=$say; $i++)
{ 	 if (empty($kategori[1][$i])){
 } else { $kat[$i] = explode('">', $kategori[1][$i]);
                           

	 
?> 


<option value="http://www.sektorel.com/sektorler<? echo $kat[$i][0]; ?>"><? echo $kat[$i][1]; ?></option>
<? 
}}?>
</select></td>

 </select>

<td></td><td>
<input type="submit"  value="Firma Listele" /> 
</td>
</form>
	 <?


$ad=$_POST['ad']; 
$sayfa=$_POST['sayfa']; 

if(empty($ad)){} 
else{
	
$gelenskat = file_get_contents($ad);

    	  preg_match_all('@<h4><a href="(.*?)"@si',$gelenskat,$katcek); 
$get = file_get_contents("http://www.sektorel.com".$katcek[1][0]);
preg_match_all('@<div class="firma-content">(.*?)<div class="clear"></div>@si',$get,$icerik); 
preg_match_all('@Sektörler</a> >(.*?)<@si',$get,$baslik); 
echo $baslik[1][0];
preg_match_all('@<img src="(.*?)"@si',$icerik[1][0],$resim); 
preg_match_all('@ <div class="fright">(.*?)<h3>@si',$icerik[1][0],$aciklama); 
preg_match_all('@Yetkili Kişi :(.*?)<@si',$icerik[1][0],$yetkili); 
preg_match_all('@Adres :(.*?)<@si',$icerik[1][0],$adres); 
preg_match_all('@Sehir :(.*?)<@si',$icerik[1][0],$sehir); 
preg_match_all('@Ülke :(.*?)<@si',$icerik[1][0],$ulke); 
preg_match_all('@Tel :(.*?)<@si',$icerik[1][0],$telefon); 
preg_match_all('@Gsm :(.*?)<@si',$icerik[1][0],$ulke); 
preg_match_all('@Fax :(.*?)<@si',$icerik[1][0],$fax); 
preg_match_all('@Web Sitesi : <a href="(.*?)"@si',$icerik[1][0],$website); 
preg_match_all('@EPosta : <a href="mailto:(.*?)"@si',$icerik[1][0],$mail); 


$resims = "http://www.sektorel.com".$resim[1][0];

echo $resims;
	
	

  
/////////////////////////////////////////////////////////////////////////////////
 if (empty($baslik[1][0])){
 } else {
try {
     $db = new PDO("mysql:host=localhost;dbname=enuyasdgunf_fradmv1;charset=utf8", "enuyasdgunf_fradmv1", "gf7sd?asdR+J");

} catch ( PDOException $e ){
     print $e->getMessage();
}


$EmailSay = $db->prepare("SELECT * FROM fdr WHERE adi = ?");
        $EmailSay->execute(array($baslik));
        $kontrol = $EmailSay->fetch(PDO::FETCH_ASSOC);
        
        if($kontrol > 0)
        {
            echo "Bu Firma var zaten !.";
        } else {
$tarih = date("d/m/Y");

function seo($s) {
 $tr = array('ş','Ş','ı','I','İ','ğ','Ğ','ü','Ü','ö','Ö','Ç','ç','(',')','/',':',',',',',"'",'^','è','&');
 $eng = array('s','s','i','i','i','g','g','u','u','o','o','c','c','','','-','-','','','','e','');
 $s = str_replace($tr,$eng,$s);
 //$s = strtolower($s);
 $s = preg_replace('/&amp;amp;amp;amp;amp;amp;amp;amp;amp;.+?;/', '', $s);
 $s = preg_replace('/\s+/', '-', $s);
 $s = preg_replace('|-+|', '-', $s);
 $s = preg_replace('/#/', '', $s);
 $s = str_replace('.', '', $s);
 $s = trim($s, '-');
 return $s;
}
$isimlisa =  seo($baslik);
$edadti = str_replace('amp;', "", $isimlisa);
if (empty($resims)){
 } else {
copy($resims,"logo/$edadti.jpg");
copy($resims,"banner/$edadti.jpg");
 copy($resims,"kapak/$edadti.jpg");}




$query = $db->prepare("INSERT INTO filar SET
kadi=?,
sifre=?,
adi=?,
seo=?,
aciklama=?,
adres=?,
tarih=?,
cep=?,
email=?,
fax=?,
website=?,
logo=?,
yadi=?,
video=?,
durum=?,
ktarih=?,
arama_baslik=?,
emailonay=?,
kapak=?,
banner=?,
lokasyon=?,
paket=?,
facebook=?,
twitter=?,
google=?,
instagram=?,
haftaici=?,
kategori=?,
anahtar_kelimeler=?");

$insert = $query->execute(array(
     "demo",
	 "123",
	 $baslik[1][0],
	 $edadti,
	 $aciklama[1][0],
	 $adres[1][0],
	 $tarih,
	 $telefon[1][0],
	 "demo@demo.com",
	 $fax[1][0],
	 $site,
	 "$edadti.jpg",
	 $yetkili[1][0],
	 $video, 
	 $durum,
	 $tarih,
	 $baslik[1][0],
	 '1',
	 "$edadti.jpg",
	 "$edadti.jpg",
	 $adres[1][0],
	 "1",
	 $facebook,
	 $twitter,
	 $google,
	 $instagram,
	 $haftaici,
	"11111",
	 $keywords
));
if ( $insert ){
    $last_id = $db->lastInsertId();
    print "Firma Ekleme İşlemi Başarılı!";
}
$son_id = $db->lastInsertId();

//// firma resimleri


for($i =0; $i <=$resimsay; $i++)
{ 	 if (empty($_POST["resim$i"])){
 } else {
	 $dsfsf = $_POST["resim$i"];
$queryi = $db->prepare("INSERT INTO fidm SET
pid=?,
resim=?

");
$inserti = $queryi->execute(array(
     $last_id,
	  $dsfsf
	 ));
	 if ( $inserti ){
    $last_idi = $db->lastInsertId();

}
}}

////////


$db = null;

		}
   
}
////////////////////////////////////////////////////////////////////////////////
}
?>

$baslik="T&# 252;rkiye’deki Şirketlerin Ger&# 231;ekten ERP’ye İhtiya...
";

echo html_entity_decode($baslik);

Türkiye’deki Şirketlerin Gerçekten ERP’ye İhtiya...