芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/users_export_xls.php

<?php 
session_start();
if($_SESSION['sat_login_id']!=''){
include('lib/conn.php');
include("functions.php");

$Randid=rand(100,500);
$date=date("m-d-Y");
$filename = $Randid."_".$date."_"."user_data.xls";

header("Expires: Sat, 01 Jan 2000 00:00:00 GMT"); 
header("Last-Modified: ".date("D, d M Y H:i:s")." GMT"); 
header("Pragma: public"); 
header("Expires: 0"); 
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Cache-Control: public"); 
header("Content-Description: File Transfer");

session_cache_limiter("must-revalidate"); 
header("Content-Type: application/vnd.ms-excel"); 
header('Content-Disposition: attachment; filename="' . $filename .'"');

$col_heading.="Name"."\t";
$col_heading.="Username"."\t";
$col_heading.="Effective Date"."\t";
$col_heading.="Title"."\t";
$col_heading.="User Level"."\t";
$col_heading.="Password"."\t";
$col_heading.="Password Recover"."\t";
$col_heading.="Security1 Q"."\t";
$col_heading.="security1 A"."\t";
$col_heading.="security2 Q"."\t";
$col_heading.="security2 A"."\t";
$col_heading.="security3 Q"."\t";
$col_heading.="security3 A"."\t";
$col_heading.="Status"."\t";
$col_heading.="Email"."\t";
$col_heading.="Reports To Name"."\t";
$col_heading.="Notes"."\t";
$col_heading.="Notes Desc"."\t";
$col_heading.="Rcv Reqs Email"."\t";
$col_heading.="submittals_emails"."\t";
$col_heading.="Rvc Hotlist Email"."\t";
$col_heading.="inactive_date"."\t";
$col_heading.="phone"."\t";
$col_heading.="extension_phone"."\t";
$col_heading.="online"."\t";
$col_heading.="last_time"."\t\n";

if($_SESSION['sqlUser']!=''){
	$sql =$_SESSION['sqlUser'];
	}else{
	$sql="select * from abs_users where 1 order by user_id desc";	
	$result=mysql_query($sql);
	if(mysql_num_rows($result)>0){
		while($row_domestic_productDetails=mysql_fetch_array($result)){
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['name']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['username']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['effective_date'])."\t";
			$col_heading.=check_null_value('user_level','abs_user_level','id',stripslashes($row_domestic_productDetails['title']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['user_level'])).' : '.check_null_value('user_level','abs_user_level','id',stripslashes($row_domestic_productDetails['user_level']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['password']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['password_recover']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['securityq1']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['securitya1']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['securityq2']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['securitya2']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['securityq3']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['securitya3']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['status']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['email']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['reports_to_name']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['notes']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['notes_desc']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['rcv_reqs_email']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['submittals_emails']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['rvc_hotlist_email']))."\t";
			$col_heading.=check_null_date($row_domestic_productDetails['inactive_date'])."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['phone']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['extension_phone']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['online']))."\t";
			$col_heading.=check_null(stripslashes($row_domestic_productDetails['last_time']))."\t\n";
			
			
			
			//$col_heading.=date('m/d/Y',strtotime($row_domestic_productDetails['post_date']))."\t\n";
		}
		echo $col_heading;
	}
  $_SESSION['sqlUser']='';
}
	
	/*else{
		header('location:user.php?error=1');
		exit();
	}*/
}
else{
	header('location:index.php');
}
?>