table 2 excel

<?
/*maaf lagi malas ngetik rapi*/
$r=mysql_connect ('localhost','root','') or die(mysql_error());
mysql_select_db('work_sejahtera4');

/*tablenya*/
$tabel=array('aging_inv','aging_invdet');
/*relationnya*/
$rel=array('inv_id','idet_id');

/*bila terjadi proses pengiriman data*/
if($_POST)
{
    if($_POST['type']=='excel')
    {
        /*
        bila udah faham ini.. silakan pake phpexcel
        */
        $filename='gunawan_'.mktime().'.xls';
        header("Content-Disposition: attachment; filename=$filename");
        header("Content-Type: application/vnd.ms-excel");
    }

    $kols=implode(",",$_POST['kolom']);
    $sql="select ".$kols." from ".
        $tabel[0]." , ".$tabel[1]." where ".
        $tabel[0].".".$rel[0]." = ".$tabel[1].".".$rel[1];
    $r=mysql_query($sql)or die('error');
    $s.= '<center><form action="#" method="post" name="check" onsubmit="Tampil()">';
    $_POST['type']='excel';
    foreach($_POST as $nm=>$val)
        $s.="<input type=hidden name='$nm' value='$val' />";
    $s.= '<input type="submit" name="submit" value="save sebagai Excel">';
    $s.="</form></center>   ";
    $s.='
    <div align="center"><h2>TAMPILAN DATA</h2>
        <table cellpadding="3" cellspacing="1" border=1 bgcolor="#000000">
        <tr>';

        $kols2=explode(",",$kols);
        for ($n=0; $n<count($kols2); $n++)
        {
            $s.='
            <th style="vertical-align:top"><font color="#ffffff">
            '.$kols2[$n]."</font></th>\n";
        }
        $s.="</tr>\n";
        echo $s;$s='';
        while($data3=mysql_fetch_array($r))
        {
            $s.='<tr bgcolor="#FFFFFF">';
            //$s.="<td>".++$n1."</td>";
            for($i=0;$i<count($kols2);$i++)
            {
                $s.="\n<td>".$data3[$i]." </td>";
            }
            $s.="\n </tr>";
            echo $s;$s='';
        }
        $s.='</tr></table>';


}else{
    $aField=array();$n=0; //meletakkan field-fieldnya
    foreach($tabel as $t)
    {
        $query='SHOW COLUMNS FROM '.$t;
        $hasil=mysql_query($query)or die(mysql_error());

        while($data=mysql_fetch_row($hasil))
        {
            $aField[$n][]=$data[0];
        }
        $n++;
    }

    //hemat!!
    $arrsama=array_intersect($aField[0],$aField[1]);
    //digabung!!
    $arr=array_merge($aField[0],$aField[1]);
    //$jmlarray=count($arr);
    $arr2=array_unique($arr);

    ?>
    <script type="text/javascript" language="javascript">
    <!--
    function Check(chk)
    {
        if(document.check.semua.checked==true)
        {
            for (i=0;i<chk.length;i++)
                chk[i].checked=true ;
            document.getElementById("message").innerHTML="Hapus Semua Centang";
            var chklist = document.getElementsByClassName('class' + chk);
        }
        else
        {
            for (i=0;i<chk.length;i++)
                chk[i].checked=false;
            document.getElementById("message").innerHTML="Centang Semua";
            var chklist = document.getElementsByClassName('class' + chk);
        }
    }
    //-->
    </script>
    <?
    $s='';
    $s.= '<form action="#" method="post" name="check" onsubmit="Tampil()">';

    $s.= '<input type="checkbox" name="semua" value="semua" onClick="Check(document.check.kolom)"><span id=message>Centang Semua</span>
    <p>';

    $n=0;
    $arr3 = array();
    //UNTUK field KEMBAR
    foreach ($arrsama as $index3=>$nilai3)
    {
        $arr3[] = $nilai3;
    }


    foreach($arr2 as $index=>$kol)
    {
        reset($arr3);$stat=0;
        foreach($arr3 as $v)
        {
            if($v==$kol) $stat=1;
        }
        if ($stat==1)
        {
            $kol2="$tabel1.$kol";
        }
        else
        {
            $kol2="$kol";
        }

        $s.= '<input type="checkbox" name="kolom[ ]"
        value="'.$kol2.'"
        onclick="check2()">'.$kol.'&nbsp;|&nbsp;';
        $n++;
    }?>
    <script type="text/javascript">

    function Tampil()
    {
        var chklist=document.getElementsByClassName("class");
        document.check.kolom.value=chklist;
    }
    </script>

    <?
    $s.= '<p>Tanggal : <input type="text" name="datepicker" size="10" id="datepicker" onkeypress="return handleEnter(this, event)" /> sampai <input type="text" name="datepicker" size="10" id="datepicker" onkeypress="return handleEnter(this, event)" />&nbsp;';

    $s.= '<input type="submit" name="submit" value="Tampil">';
    $s.= '</form>';
    $s.= '<hr/>';
}
echo $s;
/*
sql tablenya.. sekedar catatan.. ada data yg tidak punya koneksi.. tp lanjut aja

CREATE TABLE IF NOT EXISTS `aging_inv` (
  `inv_id` int(11) NOT NULL AUTO_INCREMENT,
  `inv_stat` int(11) NOT NULL DEFAULT '1',
  `inv_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `inv_by` int(11) NOT NULL,
  PRIMARY KEY (`inv_id`)
)   AUTO_INCREMENT=141 ;

--
-- Dumping data for table `aging_inv`
--

INSERT INTO `aging_inv` (`inv_id`, `inv_stat`, `inv_date`, `inv_by`) VALUES
(7, 2, '2012-03-10 16:27:27', 0),
(8, 3, '2012-03-11 22:25:26', 0),
(9, 2, '2012-03-11 22:38:49', 0),
(10, 2, '2012-03-11 22:40:24', 0),
(11, 2, '2012-03-13 08:39:37', 0),
(12, 2, '2012-03-27 01:01:01', 62),
(13, 2, '2012-03-28 11:30:01', 62);

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 14, 2012 at 05:35 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `work_sejahtera4`
--

-- --------------------------------------------------------

--
-- Table structure for table `aging_invdet`
--

CREATE TABLE IF NOT EXISTS `aging_invdet` (
  `idet_id` int(11) NOT NULL COMMENT 'sama kayak inventory',
  `idet_head` text NOT NULL COMMENT 'pisahkan dengan \\t',
  `idet_code` char(21) NOT NULL COMMENT 'ada kemungkinan berubah',
  `idet_pos` int(11) NOT NULL COMMENT 'posisi pada bulan berjalan',
  `idet_date` date NOT NULL COMMENT 'agak wasting tp buat pengechekan',
  PRIMARY KEY (`idet_id`),
  UNIQUE KEY `idet_code` (`idet_code`)
) COMMENT='detail invoice';

--
-- Dumping data for table `aging_invdet`
--

INSERT INTO `aging_invdet` (`idet_id`, `idet_head`, `idet_code`, `idet_pos`, `idet_date`) VALUES
(1, 'Handra Jl. adasgasdsdas', 'CRC/1/III/12', 1, '2012-03-10'),
(2, 'Handra Jl. adasgasdsdas', 'CRC/2/III/12', 2, '2012-03-10'),
(3, 'Handra Jl. adasgasdsdas', 'CRC/3/III/12', 3, '2012-03-10'),
(4, 'Handra Jl. adasgasdsdas', 'CRC/4/III/12', 4, '2012-03-10'),
(5, '   ', 'CRC/5/III/12', 5, '2012-03-10'),
(6, '   ', 'CRC/6/III/12', 6, '2012-03-10'),
(7, 'Gardian    Jl Hendra', 'CRC/7/III/12', 7, '2012-03-10'),
(8, 'Gardian    JL Pejaten', 'CRC/8/III/12', 8, '2012-03-10'),
(9, 'Handra Testing', 'CRC/9/III/12', 9, '2012-03-11'),
(10, 'Gardian   dadasd', 'CRC/10/III/12', 10, '2012-03-11'),
(11, 'Pt Asian Bersama  Jl Asia Afrika no 34 Jakarta 11220', 'CRC/11/III/12', 11, '2012-03-13'),
(12, 'INDOMARCO PRIMASTAMA  INDOMARCO PRIMASTAMA\r\n', 'CRC/12/III/12', 12, '2012-03-26'),
(13, 'ABDA  ', 'ADA', 1, '2012-01-28');
*/