1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / MCS_Backup / shubha27Aug / admin /
Filename : members_inactive_excel.php
back
<?php
include "../includes/config.php";
$csvoutput =""; 
$cntreq='1'; 
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=Members_Inactive.xls");
		
		$header = "Inactive Members List";
		$header .= "\n\n";
		$csvoutput .= $header;
		
		$str = '<table border="0" cellpadding="0" cellspacing="0" id="ctbl"><tr style="border: 1px solid black; font-weight:bold;"><td class="blue-bgimg">S.No</td><td class="blue-bgimg">User Name</td><td class="blue-bgimg">Profile ID</td><td class="blue-bgimg">Password</td><td class="blue-bgimg">Email Id</td><td class="blue-bgimg">Date of Birth</td><td class="blue-bgimg">Phone</td><td class="blue-bgimg">Mobile</td><td class="blue-bgimg">Created Date</td></tr></table>';
		
		$csvoutput .= $str;

			$sql=$db->get_all_assoc("select * from memberregister  where activestatus='1' order by id desc");
			$cntreq1=1;
			 foreach($sql as $sel_user)
			 {
			 $contact = $sel_user['areacode']." ".$sel_user['phoneno'];
			 $dob = $sel_user['day']." ".$sel_user['month']." ".$sel_user['year'];
			 $dat = date('d M, Y', strtotime($sel_user['created_date']));
			 $csvoutput .= "\n";
		   
		     $string = '<table border="0" cellpadding="0" cellspacing="0" id="ctbl"><tr style="border: 1px solid black;"><td class="boreder-bottom">'."$cntreq1".'</td><td class="boreder-bottom">'."$sel_user[fname]".' '."$sel_user[lname]".'</td><td class="boreder-bottom">'."$sel_user[profileid]".'</td><td class="boreder-bottom">'."$sel_user[password]".'</td><td class="boreder-bottom">'."$sel_user[email]".'</td><td class="boreder-bottom">'."$dob".'</td><td class="boreder-bottom">'."$contact".'</td><td class="boreder-bottom">'."$sel_user[mobileno]".'</td><td class="boreder-bottom">'."$dat".'</td></tr></table>';
			 $csvoutput .= $string;
		    $cntreq1++;
			}
		   
		  
		   $csvoutput .= "\n";
		$date=date("d-m-y ");
		$filename = "Members_inactive$date.csv";
		
	
		echo($csvoutput);
		   
		   
		    ?>