kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg
Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536
/
home4
/
kisgavwq
/
sisnikol.com
/
skpadmin
/
Upload FileeE
HOME
<?php //faculties.php session_start(); require_once("../includes/settings.php"); require_once("../includes/database.php"); require_once("../includes/classes/db.cls.php"); require_once("../includes/classes/sitedata.cls.php"); require_once("includes/functions/common.php"); require_once("../includes/classes/Admin.cls.php"); require_once("../includes/classes/Faculties.cls.php"); require_once("../includes/classes/DBquery.cls.php"); $db = new SiteData(); $adminObj = new Admin(); $dbobj = new dbquery(); $data_student=$dbobj->fetch_data("tbl_registration"); $i=1; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=student.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; echo '<caption>Student Details</caption>'; //make the column headers what you want in whatever order you want echo '<tr><th>#</th><th>Roll No.</th><th>Name</th><th>Email</th><th>Phone</th><th>Studying In</th><th>City</th><th>Message</th></tr>'; foreach($data_student as $sdata){ echo '<tr><td>'.$i++.'</td><td>'.$sdata['rollno'].'</td><td>'.$sdata['name'].'</td><td>'.$sdata['email'].'</td><td>'.$sdata['phone'].'</td><td>'.$sdata['studyingin'].'</td><td>'.$sdata['city'].'</td><td>'.$sdata['message'].'</td></tr>'; } echo "</table>"; ?>