prepare($sql); $query->execute(); $results=$query->fetchAll(PDO::FETCH_OBJ); $cnt=1; if($query->rowCount() > 0) { foreach($results as $result) { echo ' '; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=".$filename."-report.xls"); header("Pragma: no-cache"); header("Expires: 0"); $cnt++; } } ?>

#	Name	Email	Gender	Phone	Designation
'.$cnt.'	'.$Name= $result->name.'	'.$Email= $result->email.'	'.$Gender= $result->gender.'	'.$Phone= $result->mobile.'	'.$Designation= $result->designation.'