source: temp/trunk/html/tar_tset.php @ 5544

<?php
require_once("./require.php");

$objtar = new SC_Tar();


//Á°²èÌ̤ǰµ½ÌÂоݤΥե¡¥¤¥ë¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¤«
//count´Ø¿ô¤òÍѤ¤¤Æ¥Á¥§¥Ã¥¯¤·¡¢»ØÄ̵꤬¤¤¾ì¹ç¤Ï½ªÎ»¤¹¤ë
if (count($HTTP_POST_VARS["compck"]) == 0)
{
    print("°µ½ÌÂоݤΥե¡¥¤¥ë¤¬¤¢¤ê¤Þ¤»¤ó");
    print("<META HTTP-EQUIV=refresh CONTENT=\"1; URL=http://localhost/mytest12.php" ."\">");
    exit;
}

//file¥Õ¥©¥ë¥À¤Ë°ÜÆ°¤¹¤ë
chdir("file");

//ÊÑ¿ô$key¤ò½é´ü²½¤¹¤ë
$key = "";

//ÊÑ¿ô$key¤ËÁ°²èÌ̤ǻØÄꤵ¤ì¤¿¥Õ¥¡¥¤¥ë̾¤òÏ¢·ë¤·¤Æ³ÊǼ¤¹¤ë
//¥Õ¥¡¥¤¥ë̾¤È¥Õ¥¡¥¤¥ë̾¤Î´Ö¤ÏȾ³Ñ¥¹¥Ú¡¼¥¹¤òÆþ¤ì¤ë
for ($i=0;$i<count($HTTP_POST_VARS["compck"]);$i++){
    print $HTTP_POST_VARS["compck"][$i]."<br>";
    $key = $key . " " .$HTTP_POST_VARS["compck"][$i];

}

//¥Õ¥¡¥¤¥ë̾¤òºîÀ®¤¹¤ë
//¸½ºß¤ÎÀ¾Îñ¤Îǯ¤Î²¼2·åƬ¥¼¥íÉÕ¤­ + ·î¤ÎƬ¥¼¥íÉÕ¤­ + Æü¤ÎƬ¥¼¥íÉÕ¤­ + 
//"-" + »þ´Ö¤ÎƬ¥¼¥íÉÕ¤­ + ʬ¤ÎƬ¥¼¥íÉÕ¤­ + ÉäÎƬ¥¼¥íÉÕ¤­ + "tar.gz"
$fname = "bu".date(ymd)."-".date(his).".tar.gz";

//¥ª¥Ö¥¸¥§¥¯¥È¤òºîÀ®¤¹¤ë
//new Archive_Tar(¥Õ¥¡¥¤¥ë̾,°µ½Ì¥Õ¥é¥°);
//°µ½Ì¥Õ¥é¥°TRUE¤Ïgzip°µ½Ì¤ò¤ª¤³¤Ê¤¦
$tar = new Archive_Tar($fname, TRUE);

//°µ½Ì¤ò¤ª¤³¤Ê¤¦
$tar->create($key);

//°µ½Ì´°Î»¤Î¥á¥Ã¥»¡¼¥¸¤òɽ¼¨¤¹¤ë
print("<br>¤ò°µ½Ì¤·¤Þ¤·¤¿¡£<br>");
print("¥Õ¥¡¥¤¥ë̾¤Ï " . $fname . "¤Ç¤¹¡£<br><br>");

//HTMLʸ¤ò½ÐÎÏ¡¡javascript¤ò»ÈÍѤ·¤ÆľÁ°¤Î¥Ú¡¼¥¸¤ËÌá¤ë¥ê¥ó¥¯
print ("<br><a href=javascript:history.back();>Ìá¤ë</a><br>");


///////////////////////////////////////////////////////////////////////////////////////////////


//PEAR¤ÎTar¤òÆɤ߹þ¤à
require_once("Tar.php");

//Á°²èÌ̤DzòÅàÂоݤΥե¡¥¤¥ë¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¤«
//count´Ø¿ô¤òÍѤ¤¤Æ¥Á¥§¥Ã¥¯¤·¡¢»ØÄ̵꤬¤¤¾ì¹ç¤Ï½ªÎ»¤¹¤ë
if (count($HTTP_POST_VARS["compck"]) == 0)
{
    print("²òÅàÂоݤΥե¡¥¤¥ë¤¬¤¢¤ê¤Þ¤»¤ó");
    print("<META HTTP-EQUIV=refresh CONTENT=\"1; URL=http://localhost/mytest13.php" ."\">");
    exit;
}

//file¥Õ¥©¥ë¥À¤Ë°ÜÆ°¤¹¤ë
chdir("file");

//ÊÑ¿ô$key¤ËÁ°²èÌ̤ǻØÄꤵ¤ì¤¿¥Õ¥¡¥¤¥ë̾¤ò³ÊǼ¤¹¤ë
$key = $HTTP_POST_VARS["compck"];

//²òÅàÀè¤Î¥Õ¥©¥ë¥À̾¤ò$fname¤Ë³ÊǼ¤¹¤ë
//¥Õ¥©¥ë¥À̾¤Ï¡Ö¥Õ¥¡¥¤¥ë̾.tar.tz¡×¤è¤ê¡Ö.tar.tz¡×¤ò¼è¤ê½ü¤¯
//substr(ʸ»úÎó,³«»Ï°ÌÃÖ,ʸ»ú¿ô¡Ë¤Ïʸ»úÎó¤Î³«»Ï°ÌÃÖ¤«¤éʸ»ú¿ôʬ¤ò¼è¤ê½Ð¤¹´Ø¿ô
//strlen(ʸ»úÎó¡Ë¤Ïʸ»úÎó¤ÎŤµ¤òÊÖ¤¹´Ø¿ô
$fname = substr($key,0,strlen($key) - 7);

//¥ª¥Ö¥¸¥§¥¯¥È¤òºîÀ®¤¹¤ë
//new Archive_Tar(¥Õ¥¡¥¤¥ë̾,°µ½Ì¥Õ¥é¥°);
//°µ½Ì¥Õ¥é¥°TRUE¤Ïgzip²òÅà¤ò¤ª¤³¤Ê¤¦
$tar = new Archive_Tar($key, TRUE);

//»ØÄꤵ¤ì¤¿¥Õ¥©¥ë¥ÀÆâ¤Ë²òÅह¤ë
$tar->extract("./" . $fname);

//²òÅരλ¤Î¥á¥Ã¥»¡¼¥¸¤òɽ¼¨¤¹¤ë
print($key . "¤ò<br>" .$fname . "¥Õ¥©¥ë¥À¤Ë²òÅत¤¿¤·¤Þ¤·¤¿¡£<br>");

//HTMLʸ¤ò½ÐÎÏ¡¡javascript¤ò»ÈÍѤ·¤ÆľÁ°¤Î¥Ú¡¼¥¸¤ËÌá¤ë¥ê¥ó¥¯
print ("<br><a href=javascript:history.back();>Ìá¤ë</a><br>");

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?php

//¥À¥¦¥ó¥í¡¼¥ÉÁ°¤Ëɽ¼¨¤¹¤ë¥À¥¤¥¢¥í¥°¤Î»ØÄê
header("Content-Type: application/octet-stream");

//¥À¥¦¥ó¥í¡¼¥ÉÁ°¤Ëɽ¼¨¤¹¤ë¥À¥¤¥¢¥í¥°¤Î»ØÄê¡¡¥Õ¥¡¥¤¥ë̾¤ò bu+ÆüÉÕ.csv
//¤È»ØÄê
header("Content-Disposition: attachment; filename=bu".date(ymd).".csv");

//DB¤ØÀܳ³«»Ï ¥µ¡¼¥Ð¡¼Ì¾--localhost ¥æ¡¼¥¶¡¼Ì¾--root ¥Ñ¥¹¥ï¡¼¥É--root
$dbHandle = mysql_connect("localhost","root","root");

//DB¤ÎÀܳ¤Ë¼ºÇÔ¤·¤¿¾ì¹ç¤Ï¥¨¥é¡¼É½¼¨¤ò¤ª¤³¤Ê¤¤½èÍýÃæÃÇ
if ($dbHandle == False) {
    print ("can not connect db\n"); 
    exit;
}

//db̾  test
$db = "test";

//SQLʸ tab1ɽ¤«¤énumberÎó¤ÎÃͤξº½ç¤Ë¥½¡¼¥È¤·¤¿Á´¹Ô¤ò¼è¤ê½Ð¤¹
$sql = "select * from tab1 order by number";

//SQLʸ¤ò¼Â¹Ô¤¹¤ë
$rs = mysql_db_query($db,$sql);

//mysql_num_fields¡¡´Ø¿ô¤ò»ÈÍѤ·Îó¿ô¤ò¼èÆÀ¤¹¤ë
$fields = mysql_num_fields($rs);

//mysql_num_rows¡¡´Ø¿ô¤ò»ÈÍѤ·¹Ô¿ô¤ò¼èÆÀ¤¹¤ë
$rows = mysql_num_rows($rs);

//¼è¤ê½Ð¤·¤¿¹Ô¿ôʬ·«¤êÊÖ¤¹
for($i=0;$i<$rows;$i++){

//Îó¿ôʬ·«¤êÊÖ¤¹
    for($j=0;$j < $fields;$j++){
    
//Îó¤ÎÆâÍƽÐÎϤ¹¤ë
        print(mysql_result($rs,$i,$j));
        
//ºÇ½ªÎó¤Ç¤Ê¤¤¾ì¹ç¤Ï ¥«¥ó¥Þ ¤ò½ÐÎϤ¹¤ë
        if ($j < $fields - 1)
            print(",");
    }

//²þ¹Ô¥³¡¼¥É¤ò½ÐÎϤ¹¤ë
    print("\n");
}

?>








?>