Preview: users_export_xls.php
Size: 4.51 KB
/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');
}
?>
Directory Contents
Dirs: 17 × Files: 180