|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/www/admin/ |
Upload File : |
<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<?
$title_text = "members";
// =============================================== Query
//$tableName = "notice";
if(!$pageCount) $pageCount = 15;
$show_one_page = $pageCount;
$show_view_page = 10;
$page = ( $page ) ? $page : 1;
$offset = ($page-1)*$show_one_page;
if($key_word) {
$key_word = str_replace(" ","",$key_word);
$where = "AND UPPER(".$key.") like '%".strtoupper($key_word)."%' ";
}
//if($sessionID =="cjesent" || $sessionID =="admin"){
//$where .=" and id not like '7%' or id like '9%' ";
$where .=" and id not like '2%' ";
//}
$order_by = ' ORDER BY member_code DESC';
$url_tail = "&tab=$tab&tabs=$tabs&key=$key&order_by=$order_by&LK=$LK";
//$total_count = get_db("SELECT * FROM user where activated = 1 and auth_code=10 order by m_enddate");
if(!$key_word) {
//$query_limit = "limit $offset,$show_one_page";
}
//$QUERY_PAGE = "SELECT * FROM user where activated = 1 and auth_code=10 order by m_startdate asc";
$QUERY_PAGE = "SELECT A.*,C.admin_date FROM user A ,user_cash C WHERE A.id = C.user_id and A.m_enddate = C.enddate and A.activated = 1 and A.auth_code=10 order by A.m_enddate asc";
//if($_SERVER["REMOTE_ADDR"] == $remoteAddr){
//echo $QUERY_PAGE."<br>";
//}
//$total_page = ceil( $total_count / $show_one_page);
//$Num = $total_count - $offset+$total_per; //
//$viewlist = ( !$total_count ) ? "" : Get_viewpage($page,$total_count,$show_one_page,$show_view_page,$url_tail);
$result= mysql_query($QUERY_PAGE,$db_con);
if(!$result) {
error("DB_ERROR");
exit;
}
$total = mysql_affected_rows();
header( "Content-type: application/vnd.ms-excel" );
header( "Content-Disposition: attachment; filename=$title_text.xls" );
header( "Content-Description: PHP4 Generated Data" );
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<TITLE>JYJ MEMBER</TITLE>
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="content-script-type" content="text/javascript" />
<meta http-equiv="content-language" content="ja" />
<meta name="author" content="parksihoo JAPAN OFFICIAL FANCLUB" />
<meta name="copyright" content="Copyright JYJ JAPAN OFFICIAL FANCLUB.All Rights Reserved." />
<meta name="robots" content="INDEX,FOLLOW" />
<meta name="keywords" content="parksihoo" lang="ja" xml:lang="ja" />
<meta name="description" content="parksihoo" lang="ja" xml:lang="ja" />
</HEAD>
<BODY>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<tr>
<td>
<table width="100%" cellspacing="0" cellpadding="0" border=1 align='center' class="table_ro">
<tr>
<!--th scope="row">No</th-->
<th scope="row">IDX</th>
<th scope="row">ID</th>
<th scope="row">Name</th>
<th scope="row">Name1</th>
<th scope="row">TEL</th>
<th scope="row">Email</th>
<th scope="row">address</th>
<th scope="row">Zip_Code</th>
<th scope="row">Start date</th>
<th scope="row">End date</th>
<th scope="row">modify date</th>
</tr>
<?
if(!$total){
echo "<tr><td colspan='6' align=center height='50px'>登録された情報がございません</td></tr>";
}else{
for($i=0; $i<$total; $i++) {
$row = mysql_fetch_array($result);
$created = substr($row[created],0,10);
$resub = Get_dbres("select tel,juso,zip1,zip2 from user_profiles where user_id = '$row[id]'");
$rows = mysql_fetch_array($resub);
$m_startdate_tmp = explode("-","$row[m_startdate]");
$m_startdate = $m_startdate_tmp[0].".".$m_startdate_tmp[1].".".$m_startdate_tmp[2];
$m_enddate_tmp = explode("-","$row[m_enddate]");
$m_enddate = $m_enddate_tmp[0].".".$m_enddate_tmp[1].".".$m_enddate_tmp[2];
//$admin_date = Get_db("select admin_date from user_cash where user_id = '$row[id]' and enddate ='$row[m_enddate]'");
$m_modified_tmp = explode("-","$row[admin_date]");
$m_modified = $m_modified_tmp[0].".".$m_modified_tmp[1].".".$m_modified_tmp[2];
?>
<!--tr align="center"-->
<!--td><?=$i?></td-->
<td><?=$row[id]?></td>
<td>J_<?=$row[userid]?></td>
<td><?=$row[username]?></td>
<td><?=$row[jname]?></td>
<td><?=$rows[tel]?></td>
<td><?=$row[email]?></td>
<td><?=$rows[juso]?></td>
<td><?=$rows[zip1]?>-<?=$rows[zip2]?></td>
<td><?=$m_startdate?></td>
<td><?=$m_enddate?></td>
<td><?=$m_modified?></td>
</tr>
<?
$Num--;
}
}
?>
</table>
</td>
</tr>
</table>
</BODY>
</HTML>