user_login){die('Please Login');} if(!in_array($user->user_login,array('swc','vansindata','betty','kate'))){ die('cannot view, please contact Administrator.'); } $reason_id = isset($_GET['reason_id']) ? $_GET['reason_id']+0 : 0; $ary_reason = array(); $ary_reason_count = array(); $sql='SELECT * FROM '.TBL_UNSUBEMAIL_REASON.' ORDER BY reason_order'; foreach($wpdb->get_results($sql)as$v){ $ary_reason[$v->reason_id]=$v->reason_label; # $sql = 'SELECT COUNT(id) FROM '.TBL_UNSUBEMAIL.' WHERE reason='.$v->reason_id; $count = $wpdb->get_var($sql); $ary_reason_count[$v->reason_id]=$count; } #print_r($ary_reason); echo'

退訂結果:

'; $a = !$reason_id ? array() : $wpdb->get_results('SELECT * FROM '.TBL_UNSUBEMAIL.' WHERE reason='.$reason_id.' ORDER BY unsub_datetime DESC'); echo'
'; echo''; foreach($a as$v){ echo''; } echo'
'.implode('',array( 'Email','退訂時間','退訂原因','退訂其它原因','提供理由時間','IP' )).'
'.implode('',array($v->unsubemail, $v->unsub_datetime, isset($ary_reason[$v->reason]) ? $ary_reason[$v->reason]:$v->reason,$v->reason_text,$v->reason_datetime,$v->ip)).'
';