". "". "". "". "". "". "TCN". "".cevir('K.NO')."". "".cevir('K.TARÝH')."". "".cevir("ÜNVAN")."". "AD". "SOYAD". "ONAY-1". "ONAY-2". "KURUM". "CEP-TEL". "E-POSTA". "".cevir("ÝÞ ADRESÝ")."". "".cevir("AÝDAT")."". "".cevir("AÝDAT NOT")."". ""; $sql = "SELECT * FROM tad_uyeler LEFT JOIN tad_unvanlar ON tad_unvanlar.UNVAN_ID = tad_uyeler.UYE_UNVAN_NO WHERE (UYE_DURUM = 1) ORDER BY UYE_ID DESC"; $Rs = mysql_query($sql, $conn); while ($Rec = mysql_fetch_array($Rs)) { $tcn = $Rec["UYE_TC"]; $kayit1 = $Rec['UYE_KAYIT']; $kayit2 = preg_replace("/ /",'T',$Rec['UYE_ONAY']); $unvan = cevir($Rec["UNV_AD"]); $ad = cevir($Rec["UYE_AD"]); $soyad = cevir($Rec["UYE_SOYAD"]); $kurum = cevir($Rec["UYE_KURUM"]); $cep = cevir($Rec["UYE_CEP"]); $eposta = cevir($Rec["UYE_EPOSTA"]); $onay1 = cevir($Rec['UYE_KURUL_AD_1'].' '.$Rec['UYE_KURUL_SOYAD_1']); $onay2 = cevir($Rec['UYE_KURUL_AD_2'].' '.$Rec['UYE_KURUL_SOYAD_2']); $isadres= cevir($Rec["UYE_ISADRES"]); $aidat = cevir($Rec["UYE_AIDAT"]); $aidatnot= cevir($Rec["UYE_AIDAT_NOT"]); if (preg_match("/^0000\-/",$kayit2)) $kayit2='1900-01-01T00:00:00'; $data .= "". "".$tcn."". "".$kayit1."". "".$kayit2."". "".$unvan."". "".$ad."". "".$soyad."". "".$onay1."". "".$onay2."". "".$kurum."". "".$cep."". "".$eposta."". "".$isadres."". "".$aidat."". "".$aidatnot."". ""; } mysql_free_result($Rs); $data .= ""; header("Content-type: application/octet-stream;charset=utf-8;"); header("Content-Disposition: attachment; filename=".$fname.";"); header("Content-Type: application/ms-excel"); header("Pragma: no-cache"); header("Expires: 0"); echo $data; CloseConn(); exit; function cevir($s) { $s = str_replace("Þ","Ş",$s); $s = str_replace("þ","ş",$s); $s = str_replace("Ð","Ğ",$s); $s = str_replace("ð","ğ",$s); $s = str_replace("Ý","İ",$s); $s = str_replace("Ç","Ç",$s); $s = str_replace("ç","ç",$s); $s = str_replace("Ü","Ü",$s); $s = str_replace("ü","ü",$s); $s = str_replace("Ö","Ö",$s); $s = str_replace("ö","ö",$s); $s = str_replace("ý","ı",$s); $s = str_replace("+","+",$s); $s = str_replace("-","-",$s); $s = str_replace(">",">",$s); $s = str_replace("<","<",$s); $s = str_replace("é","é",$s); $s = str_replace("è","è",$s); $s = str_replace("à","à",$s); $s = str_replace("ë","ë",$s); $s = str_replace("ê","ê",$s); $s = str_replace("ö","ö",$s); $s = str_replace("ï","ï",$s); $s = str_replace("î","î",$s); $s = str_replace("â","â",$s); $s = str_replace("ù","ù",$s); $s = str_replace("ô","ô",$s); $s = str_replace("û","û",$s); return $s; }