Üçgen Yapımı

style tagı içerisine bu kodu ekleyiniz.

.yukari {
    border-left:12px solid transparent;
    border-right:12px solid transparent;
    border-bottom:12px solid #09F;
    width:0;
    height:0;
}
 
.asagi {
    border-left:12px solid transparent;
    border-right:12px solid transparent;
    border-top:12px solid #0B0;
    width:0;
    height:0;
}
 
.sol {
    border-right:12px solid #B00;
    border-top:12px solid transparent;
    border-bottom:12px solid transparent;
    width:0;
    height:0;
}
 
.sag {
    border-left:12px solid #F60;
    border-top:12px solid transparent;
    border-bottom:12px solid transparent;
    width:0;
    height:0;
}

sayfa içerisinde bu kodu kullanın

<div class="yukari"></div>
<div class="asagi"></div>
<div class="sol"></div>
<div class="sag"></div>

 

Mobil Cihaz Tespiti

Php ile

<?php 
function isMobile() {
    return preg_match("/(android|avantgo|blackberry|bolt|boost|cricket|docomo|fone|hiptop|mini|mobi|palm|phone|pie|tablet|up.browser|up.link|webos|wos)/i", $_SERVER["HTTP_USER_AGENT"]);
}
if(isMobile()){
 header('Location: http://localhost/mobil');
}
?>

Javascript ile

(function(a,b){if(/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino/i.test(a)||/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i.test(a.substr(0,4)))window.location=b})(navigator.userAgent||navigator.vendor||window.opera,'http://localhost/mobil');

 

Gelişmiş Hesap Makinesi

<HTML>
<HEAD>
<TITLE>JavaScript Gelismis Hesap Makinesi</TITLE>
<SCRIPT LANGUAGE='JavaScript'>
var displayText = ""
var num1
var num2
var operatorType

// Write to display
function addDisplay(n){
document.calc.display.value = ""
displayText += n
document.calc.display.value = displayText
}

// Addition
function addNumbers() {
if (displayText == "") {
  displayText = result
 }
num1 = parseFloat(displayText)
operatorType = "add"
displayText = ""
}

// Subtraction
function subtractNumbers() {
if (displayText == "") {
  displayText = result
 }
num1 = parseFloat(displayText)
operatorType = "subtract"
displayText = ""
}

// Multiplication
function multiplyNumbers() {
if (displayText == "") {
  displayText = result
 }
num1 = parseFloat(displayText)
operatorType = "multiply"
displayText = ""
}

// Division
function divideNumbers() {
if (displayText == "") {
  displayText = result
 }
num1 = parseFloat(displayText)
operatorType = "divide"
displayText = ""
}

// Sine
function sin() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = Math.sin(num1)
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// Cosine
function cos() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = Math.cos(num1)
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// ArcSine
function arcSin() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = Math.asin(num1)
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// ArcCosine
function arcCos() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = Math.acos(num1)
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// Square root
function sqrt() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = Math.sqrt(num1)
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// Square number (number to the power of two)
function square() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = num1 * num1
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// Convert degrees to radians
function degToRad() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = num1 * Math.PI / 180
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// Convert radians to degrees
function radToDeg() {
if (displayText == "") {
  num1 = result
  }
else {
  num1 = parseFloat(displayText)
  }
if (num1 != "") {
  result = num1 * 180 / Math.PI
  document.calc.display.value = result
  displayText = ""
  }
else {
  alert("Önce bir numara yazınız")
  }
}

// Calculations
function calculate() {
if (displayText != "") {
  num2 = parseFloat(displayText)
// Calc: Addition
  if (operatorType == "add") {
    result = num1 + num2
    document.calc.display.value = result
    }
// Calc: Subtraction
  if (operatorType == "subtract") {
    result = num1 - num2
    document.calc.display.value = result
    }
// Calc: Multiplication
  if (operatorType == "multiply") {
    result = num1 * num2
    document.calc.display.value = result
    }
// Calc: Division
  if (operatorType == "divide") {
    result = num1 / num2
    document.calc.display.value = result
    }
  displayText = ""
  }
  else {
  document.calc.display.value = "Hata!"
  }
}
function clearDisplay() {
displayText = ""
document.calc.display.value = ""
}
</SCRIPT>
</HEAD>
<BODY BGCOLOR="#FFFFFF" LINK="#9C6060">

<TABLE>
<TD> 
<TABLE BORDER=0 BGCOLOR="#AF9999">
<TD>
<TABLE border="0" cellpadding="2" cellspacing="2">
<FORM NAME=calc>
<TR>
	<TD COLSPAN=5><INPUT TYPE=text SIZE=22 NAME=display></TD>
<TR align="left" valign="middle">
	<TD><INPUT TYPE=button NAME="one" VALUE="   1   " onClick=addDisplay(1)></TD>
	<TD><INPUT TYPE=button NAME="two" VALUE="   2   " onClick=addDisplay(2)></TD>
	<TD><INPUT TYPE=button NAME="three" VALUE="   3   " onClick=addDisplay(3)></TD>
	<TD><INPUT TYPE=button NAME="plus" VALUE="   +   " onClick=addNumbers()></TD>
<TR align="left" valign="middle">
	<TD><INPUT TYPE=button NAME="four" VALUE="   4   " onClick=addDisplay(4)></TD>
	<TD><INPUT TYPE=button NAME="five" VALUE="   5   " onClick=addDisplay(5)></TD>
	<TD><INPUT TYPE=button NAME="six" VALUE="   6   " onClick=addDisplay(6)></TD>
	<TD><INPUT TYPE=button NAME="minus" VALUE="   -   " onClick=subtractNumbers()></TD>
<TR align="left" valign="middle">
	<TD><INPUT TYPE=button NAME="seven" VALUE="   7   " onClick=addDisplay(7)></TD>
	<TD><INPUT TYPE=button NAME="eight" VALUE="   8   " onClick=addDisplay(8)></TD>
	<TD><INPUT TYPE=button NAME="nine" VALUE="   9   " onClick=addDisplay(9)></TD>
	<TD><INPUT TYPE=button NAME="multiplication" VALUE="   *     " onClick=multiplyNumbers()></TD>
<TR align="left" valign="middle">
	<TD><INPUT TYPE=button NAME="zero" VALUE="   0   " onClick=addDisplay(0)></TD>
	<TD><INPUT TYPE=button NAME="pi" VALUE = "  Pi   " onClick=addDisplay(Math.PI)> </TD> 
	<TD><INPUT TYPE=button NAME="dot" VALUE="   .   " onClick=addDisplay(".")></TD>
	<TD><INPUT TYPE=button NAME="division" VALUE="   /   " onClick=divideNumbers()></TD>
<TR align="left" valign="middle">
	<TD><INPUT TYPE=button NAME="sqareroot" VALUE="sqrt" onClick=sqrt()></TD>
	<TD><INPUT TYPE=button NAME="squarex" VALUE=" x^2" onClick=square()></TD>
	<TD><INPUT TYPE=button NAME="deg-rad" VALUE="d2r  " onClick=degToRad()></TD>
	<TD><INPUT TYPE=button NAME="rad-deg" VALUE="r2d  " onClick=radToDeg()></TD>
<TR align="left" valign="middle">
	<TD><INPUT TYPE=button NAME="sine" VALUE="  sin  " onClick=sin()></TD>
	<TD><INPUT TYPE=button NAME="arcsine" VALUE="asin" onClick=arcSin()></TD>
	<TD><INPUT TYPE=button NAME="cosine" VALUE="cos" onClick=cos()></TD>
	<TD><INPUT TYPE=button NAME="arccosine" VALUE="acs" onClick=arcCos()></TD>

<TR align="left" valign="middle">
	<TD COLSPAN=2><INPUT TYPE=button NAME=clear VALUE="   Temizle   " onClick=clearDisplay()></TD>
	<TD COLSPAN=3><INPUT TYPE=button NAME=enter VALUE="      =      " onClick=calculate()></TD>

</TABLE>
</TABLE>


</TABLE>
</BODY>
</HTML>

 

Basit Tema Sistemi

<?php
class template
{
	private $file		= NULL;		// -- Load File
	private $content	= NULL;		// -- File Loaded
	private $tags		= array();	// -- Tags Added
	private $count		= 0;		// -- Loop of Tags
	public function fread($archive)
	{
		$this->file = @fopen($archive, "r");
		$this->content = @fread($this->file, filesize($archive));
		if(!$this->file) exit("Error open: {$archive}");
		if(!$this->content) exit("Error read: {$archive}");
	}
	public function set($name, $value)
	{
		$this->tags[$this->count++] = array("name" => $name, "value" => $value);
	}
	public function show()
	{
		foreach($this->tags as $tags)
			$this->content = str_replace("{".$tags['name']."}", $tags['value'], $this->content);
			
		eval("?>".$this->content."<?");
	}
}
define("TITLE", "Ben Sayfa Başlığıyım"); // -- Page Title
$veri="ben bir sayfa içeriğiyim";


$template = new template(); // -- Load Class

$template->set("TITLE", TITLE); // -- Add the tag {TITLE}
$template->set("ICERIK", $veri); // -- Add the tag {ICERIK}

switch($_GET["page"])
{
	case "home" :
	$template->fread("template/index.tpl.php"); // -- Load the index.tpl.php
	break;
	default : 
	$template->fread("template/index.tpl.php"); // -- Load the index.tpl.php
	break;
}

$template->show(); // -- Show template

//alttaki html kodlarını template/index.tpl.php dosyası oluşturarak içine yazınız
/*
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>{TITLE}</title>
</head>

<body>
{CONTENT}
</body>
</html>
*/
// çalıştırmak için  localhost/index.php?page=home tarzı case e göre
?>

 

Aşk Ölçer

<?php
error_reporting(4);
class lovecalc {
	function lovecalc ($firstname, $secondname) {
		$this->lovename = strtolower(preg_replace("/ /","",strip_tags(trim($firstname.$secondname))));
		$alp = count_chars($this->lovename);
		for($i=97;$i<=122;$i++){
			if($alp[$i]!=false){
				$anz = strlen($alp[$i]);
				if($anz<2){ $calc[] = $alp[$i]; }
				else{ for($a=0;$a<$anz;$a++){ $calc[] = substr($alp[$i],$a,1); } }
			}
		}
		while (($anzletter = count($calc))>2) {
			$lettermitte = ceil($anzletter/2);
			for($i=0;$i<$lettermitte;$i++){
				$sum = array_shift($calc)+array_shift($calc);
				$anz = strlen($sum);
				if($anz<2){ $calcmore[] = $sum; }
				else{ for($a=0;$a<$anz;$a++){ $calcmore[] = substr($sum,$a,1); } }
			}
			$anzc = count($calcmore);
			for($b=0;$b<$anzc;$b++){ $calc[] = $calcmore[$b]; }
			array_splice($calcmore,0);
		}
		$this->lovestat = $calc[0].$calc[1];
	}

	function showlove () {
		return "Mevcut Sevgi : %$this->lovestat";
	}
}

//örnek kullanım
?>
<html>
	<body>
	<form action="" method="get">
		Sen<input type="text" name="you" value="<?php echo @$_GET['you']; ?>"/>
		Ben<input type="text" name="me" value="<?php echo @$_GET['me']; ?>"/>
		<input type="submit" name="send" value="Hesapla"/>
	</form>
	</body>
</html>

<?php
$my_love = new lovecalc(@$_GET['you'],@$_GET['me']);
echo $my_love->showlove();
?>

 

Kredi Kartı Tanıma

<?php
error_reporting(4);
if(!defined(PHP_CREDITCARD_CLASS))
{

define(PHP_CREDITCARD_CLASS, 1);

define(UNKNOWN, 0);
define(MASTERCARD, 1);
define(VISA, 2);
define(AMEX, 3);
define(DINNERS, 4);
define(DISCOVER, 5);
define(ENROUTE, 6);
define(JCB, 7);

define(CC_OK, 0);
define(CC_ECALL, 1);
define(CC_EARG, 2);
define(CC_ETYPE, 3);
define(CC_ENUMBER, 4);
define(CC_EFORMAT, 5);
define(CC_ECANTYPE, 6);

class creditcard
{
  var $number;
  var $type;
  var $errno;

  function creditcard()
  {
    $this->number = 0;
    $this->type = UNKNOWN;
    $this->errno = CC_OK;
  }
  function check($cardnum)
  {
    $this->number = $this->_strtonum($cardnum);

    if(!$this->detectType($this->number))
    {
      $this->errno = CC_ETYPE;
      return false;
    }

    if($this->mod10($this->number))
    {
      $this->errno = CC_ENUMBER;
      return false;
    }

    return true;
  }
  function detectType($cardnum = 0)
  {
    if($cardnum)
      $this->number = $this->_strtonum($cardnum);
    if(!$this->number)
    {
      $this->errno = CC_ECALL;
      return UNKNOWN;
    }

    if(preg_match("/^5[1-5]d{14}$/", $this->number))
      $this->type = MASTERCARD;

    else if(preg_match("/^4(d{12}|d{15})$/", $this->number))
      $this->type = VISA;

    else if(preg_match("/^3[47]d{13}$/", $this->number))
      $this->type = AMEX;

    else if(preg_match("/^[300-305]d{11}$/", $this->number) ||
      preg_match("/^3[68]d{12}$/", $this->number))
      $this->type = DINNERS;

    else if(preg_match("/^6011d{12}$/", $this->number))
      $this->type = DISCOVER;

    else if(preg_match("/^2(014|149)d{11}$/", $this->number))
      $this->type = ENROUTE;

    else if(preg_match("/^3d{15}$/", $this->number) ||
      preg_match("/^(2131|1800)d{11}$/", $this->number))
      $this->type = JCB;

    if(!$this->type)
    {
      $this->errno = CC_ECANTYPE;
      return UNKNOWN;
    }

    return $this->type;
  }
  function detectTypeString($cardnum = 0)
  {
    if(!$cardnum)
    {
      if(!$this->type)
        $this->errno = CC_EARG;
    }
    else
      $this->type = $this->detectType($cardnum);

    if(!$this->type)
    {
      $this->errno = CC_ETYPE;
      return NULL;
    }

    switch($this->type)
    {
      case MASTERCARD:
        return "MASTERCARD";
      case VISA:
        return "VISA";
      case AMEX:
        return "AMEX";
      case DINNERS:
        return "DINNERS";
      case DISCOVER:
        return "DISCOVER";
      case ENROUTE:
        return "ENROUTE";
      case JCB:
        return "JCB";
      default:
        $this->errno = CC_ECANTYPE;
        return NULL;
    }
  }

  function getCardNumber()
  {
    if(!$this->number)
    {
      $this->errno = CC_ECALL;
      return 0;
    }

    return $this->number;
  }
  function errno()
  {
    return $this->errno;
  }

  function mod10($cardnum)
  {
    for($sum=0, $i=strlen($cardnum)-1; $i >= 0; $i--)
    {
      $sum += $cardnum[$i];
      $doubdigit = "".(2 * $cardnum[--$i]);
      for($j = strlen($doubdigit)-1; $j >= 0; $j--)
        $sum += $doubdigit[$j];
    }
    return $sum % 10;
  }

  function resetCard()
  {
    $this->number = 0;
    $this->type = 0;
  }

  function strError()
  {
    switch($this->errno)
    {
      case CC_ECALL:
        return "Geçersiz Arama";
      case CC_ETYPE:
        return "Bilinmeyen Kart Tipi";
      case CC_ENUMBER:
        return "Geçersiz Kart Numarası";
      case CC_EFORMAT:
        return "Geçersiz Format";
      case CC_ECANTYPE:
        return "Kart tipi taranamadı";
      case CC_OK:
        return "Başarılı";
    }
  }

  function _strtonum($string)
  {
    for($i=0; $i< strlen($string); $i++)
    {
      if(!is_numeric($string[$i]))
        continue;
      $nstr = "$nstr".$string[$i];
    }
    return $nstr;
  }

}


}

//ÖRNEK 
$cc = new creditcard;
$card=$_GET[card];
if($card)
{
  printf("%s  nolu kart %s <br>n", $card,
    (($ccret = $cc->check($card))?" gecerli":"gecersiz"));

  if($ccret)
  {
    printf("Kart Tipi: %s veya %d<br>n", $cc->detectTypeString(),
      $cc->detectType());
    printf("Kart Numarasi: %s<br>n", $cc->getCardNumber());
  }
  else
    printf("%s<br>n", $cc->strError());

}

?>

<form action="" method=get>
<input type=text name=card size=20><p>
<input type=submit value="Hesapla">
</form>

</body>

 

Adresten zip yükleme ve dizine çıkartma

 <?php
class urluploader {
                  private $filename; 
                  private $url; 
                  private $unzipdir;
       function __construct($fileurl,$dir=0)
              {
               if ($dir==0)
                      { $this->unzipdir=getcwd() . "/"; }
                      else {$this->unzipdir=$dir . "/";}
               $this->filename=$this->unzipdir . basename($fileurl);
                $this->url=$fileurl;
                }
       public function uploadFromUrl ()
               {
                 if(!filter_var($this->url, FILTER_VALIDATE_URL))
                     {die ("The provided url is invalid");}
                  $length=5120; 
                  $handle=fopen($this->url,'rb') or die ('gecersiz adres ');
                  $write=fopen ( $this->filename,'w');
                      while ( !feof($handle))
                        {
                           $buffer=fread ( $handle,$length );
                           fwrite ( $write,$buffer);
                         }
                  fclose ( $handle);
                  fclose ($write);
                  echo "<br>basarili:" . basename($this->filename) . "<br>" ;
                  return true;
               }
        public function unzip($newdir=false,$delete=false,$filename=false)
                {  if (!$filename){$filename=$this->filename;}
                          if(!$newdir){$newdir=$this->unzipdir;}
                     if (!file_exists($filename))
                           {die( 'bu dosya mevcut');}
                     if (class_exists('ZipArchive'))
	                  	{$zip = new ZipArchive;
			                  if($zip->open($filename) !== TRUE)
			                        {die('Unable to open the zip file');  }
		               	   $zip->extractTo($newdir) or die ('Unable to extract the file');
		                     echo "<br>Extracted the zip file<br>";
		                 	    $zip->close();
		                 }
		else
		{
			@shell_exec('unzip -d $newdir '. $this->filename);
			echo "<br>Unzipped the file using shell command<br>";
		}              
              If ($delete) {unlink($filename);
                 echo "<br>Deleting" . basename($filename);}
                return true;

                }
 }

 //örnek
 
        $upload= new urluploader("http://localhost/test.zip");//upload linki
       if($upload->uploadFromUrl())
       {$upload->unzip();}
       else {echo "basarisiz";}

 

Sorgu Sonucunu Excel’e Aktarmak

<?PHP
error_reporting(4);
class ExportToExcel
{
	function exportWithPage($php_page,$excel_file_name)
	{
		$this->setHeader($excel_file_name);
		require_once "$php_page";
	}
	function setHeader($excel_file_name)
	{
		header("Content-type: application/octet-stream");
		header("Content-Disposition: attachment; filename=$excel_file_name");
		header("Pragma: no-cache");
		header("Expires: 0");
	}
	function exportWithQuery($qry,$excel_file_name,$conn)//to export with query
	{
		$tmprst=mysql_query($qry,$conn);
		$header="<center><table border=1px><th>Tablo Dökümü</th>";
		$num_field=mysql_num_fields($tmprst);
		while($row=mysql_fetch_array($tmprst,MYSQL_BOTH))
		{
			$body.="<tr>";
			for($i=0;$i<$num_field;$i++)
			{
				$body.="<td>".$row[$i]."</td>";
			}
			$body.="</tr>";	
		}
		$this->setHeader($excel_file_name);
		echo $header.$body."</table";
	}
}
$conn=mysql_connect('localhost','root','')or die('bağlanmadı');
mysql_select_db('test');


//ÖRNEK
$exp=new ExportToExcel();

//$exp->exportWithPage("export_file.php","test.xls");

$qry="select * from qa_users";
$exp->exportWithQuery($qry,"test.xls",$conn);

?>