상품정보 액셀(엑셀, exel) 다운로드 소스 채택완료

include_once("./_common.php"); $excel_down = "g4_write_" . $_GET['bo_table']; //엑셀 다운로드 테이블 $wr_id = $id = $_GET['wr_id'];

include "../../../dbconfig.php"; $db_conn = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die('서버에 접속하지 못했습니다.'); mysql_select_db($mysql_db, $db_conn); //@mysql_query("SET CHARACTER SET utf8");  // 한글깨지면 주석해지

if ($ms =="excel"){ $g4[title] = "엑셀 문서 다운로드";   header( "Content-type: application/vnd.ms-excel" );   header( "Content-Disposition: attachment; filename=data.xls" );   //header( "Content-Description: PHP4 Generated Data" );  } else if ($ms =="power"){  $g4[title] = "파워포인트 문서 다운로드";   header( "Content-type: application/vnd.ms-powerpoint" );   header( "Content-Disposition: attachment; filename=data.ppt" );   // header( "Content-Description: PHP4 Generated Data" );  } else if ($ms =="word"){   $g4[title] = "워드 문서 다운로드";   header( "Content-type: application/vnd.ms-word" );   header( "Content-Disposition: attachment; filename=data.doc" );   //header( "Content-Description: PHP4 Generated Data" );  } else if ($ms =="memo"){   $g4[title] = "메모 문서 다운로드";   header( "Content-type: application/vnd.ms-notepad" );   header( "Content-Disposition: attachment; filename=data.txt" );  } else {   header( "Content-type: application/vnd.ms-excel" );   header( "Content-Disposition: attachment; filename=clickmarketing.xls" );   // 파일명을 게시판 그룹명으로  }   header( "Content-Description: PHP4 Generated Data" );

$temp=mysql_fetch_array(mysql_query("select count(*) from $excel_down ")); //where wr_is_comment = '0' and wr_content = '$wr_id' ")); $result=@mysql_query("select * from $excel_down order by wr_datetime desc");// where wr_is_comment = '0'  and wr_content = '$wr_id' order by wr_datetime desc");

$number=$temp[0];

?>

예제코드입니다. 쿼리나 해당 개수 및 폼등은 맞게끔 수정해야됩니다.