티스토리 뷰

Network/Web

XE 회원정보 엑셀로 출력

알 수 없는 사용자 2011. 8. 9. 10:40

참고는 이쪽 : http://www.xpressengine.com/19585441

 

한글 / 확장변수 수정된 버전임..

관리자가 아닐경우 아무 반응 없도록 함..

 

<?
define('__ZBXE__',true);
require_once("../../config/config.inc.php");
$oContext = &Context::getInstance();
$oContext->init();
 
$logged_info = Context::get('logged_info');
$isadmin = $logged_info->is_admin;
 
if($isadmin)
{
    $connect_host        = "localhost";
    $connect_id        = "디비아이디";
    $connect_pass        = "패스워드";
    $connect_db        = "디비이르ㅁ";
    $connect_table        = "xe_member";
    $xls_filename        = "memberlist.xls";
 
    $connect=@mysql_connect($connect_host,$connect_id,$connect_pass);
    @mysql_query("set character set utf8");
    $mysql=@mysql_select_db($connect_db,$connect);
}
else
{
    @mysql_close($connect);
    die();
}
header("Content-Type: application/vnd.ms-excel"); 
header("Content-Disposition: attachment; filename=$xls_filename"); 
?> 
 
<html> 
  <head> 
    <meta http-equiv=Content-Type content="text/html; charset=UTF-8" />
  </head> 
  <body> 
    <table border=1>
    <tr align=center>
<?
  $fields = mysql_list_fields("$connect_db", "$connect_table");
  $columns = mysql_num_fields($fields);
 
  for ($i = 0; $i < $columns; $i++) {
    $field[$i]=mysql_field_name($fields, $i);
    if($field[$i]=='extra_vars')
    {
    echo "<th>확장변수1</th>";
    echo "<th>확장변수2</th>";
    echo "<th>확장변수3</th>";
    echo "<th>확장변수4</th>";
    echo "<th>확장변수5</th>";
    echo "<th>확장변수6</th>";
    echo "<th>확장변수7</th>";
    }
    else echo "<th>".$field[$i]. "</th>";
  }
?>
    </tr>
 
<?
  $result=mysql_query("select * from $connect_table");
  while($data=mysql_fetch_assoc($result)){
    echo"<tr>";
 
    for ($i = 0; $i < sizeof($field); $i++) {
    if($i==3) echo "<td></td>";
    elseif($i==15) {
        $dstr=date("Y-m-d", ztime($data["$field[$i]"]));
        echo "<td>".$dstr."</td>";
    } elseif($i==16) {
        $dstr=date("Y-m-d", ztime($data["$field[$i]"]));
        echo "<td>".$dstr."</td>";
    } elseif($i==19) {
        $ser = unserialize($data["$field[$i]"]);
        echo "<td>".$ser->확장변수1."</td>";
        echo "<td>".$ser->확장변수2."</td>";
        echo "<td>".$ser->확장변수3."</td>";
        echo "<td>".$ser->확장변수4."</td>";
        echo "<td>".$ser->확장변수5."</td>";
        echo "<td>".$ser->확장변수6."</td>";
        echo "<td>".$ser->확장변수7."</td>";
 
    } elseif($i==20) {
        $dstr=date("Y-m-d", ztime($data["$field[$i]"]));
        echo "<td>".$dstr."</td>";
    } else echo "<td>".$data["$field[$i]"]."</td>";
    }
 
  echo"</tr>";
}
?>
    </table>
  </body> 
</html>

'Network > Web' 카테고리의 다른 글

Firefox 주소창 + 구글검색 통합하기  (0) 2013.09.26
웹폰트 제작  (0) 2011.10.08
XE Data Export Tool Ver 0.2 에서 게시판 목록이 뜨지 않을때  (0) 2011.03.21
웹개발자라면 알아야될 css tip(?)  (0) 2011.02.06
[style.css] div와 span, id와 class 어떤 차이가 있을까?  (0) 2011.02.06