| Server IP : 108.170.25.35 / Your IP : 18.191.68.61 Web Server : Apache/2 System : Linux gains.winzonesoftech.com 4.18.0-513.24.1.el8_9.x86_64 #1 SMP Mon Apr 8 11:23:13 EDT 2024 x86_64 User : softechwinzone ( 1579) PHP Version : 8.1.28 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/softechwinzone/domains/winzonesoftech.in/public_html/admin/ |
Upload File : |
<?php include('session.php')?>
<?php include('header.php')?>
<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
<style>
img.banner {
width: auto;
height:50px;
}
.flt
{
float:left;
}
.pull-right
{
float:right
}
</style>
<script src="https://cdn.jsdelivr.net/gh/linways/table-to-excel@v1.0.4/dist/tableToExcel.js"></script>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Sidebar -->
<?php include('sidebar.php')?>
<!-- End of Sidebar -->
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<!-- Topbar -->
<?php include('topbar.php')?>
<!-- End of Topbar -->
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- Page Heading -->
<div class="d-sm-flex align-items-center justify-content-between mb-4">
<h1 class="h3 mb-0 text-gray-800">Internship Details</h1>
</div>
<a href="exportintern.php" class="btn btn-success">Export Data</a>
<!-- DataTales Example -->
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary flt">Inserted Data List</h6>
<button class="pull-right"id="btnExport" onclick="exportReportToExcel(this)">EXPORT LIST</button>
</div>
<div class="card-body" id="invoice">
<div class="table-responsive" >
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<div >
<thead >
<tr>
<th>S.No</th>
<th>Name</th>
<th>Phone Number</th>
<th>Email Id</th>
<th>City</th>
<th>Student degree </th>
<th>Passed out</th>
<th>Message</th>
</tr>
</thead>
<tbody>
<?php
$x=1;
$sql=mysqli_query($conn,"SELECT * FROM `internship` ORDER BY `id` DESC");
while($row=mysqli_fetch_array($sql))
/**$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row) **/
{
?>
<tr>
<td><?php echo $x; ?></td>
<td><?php echo $row['fname']." ".$row['lname']; ?></td>
<td><?php echo $row['phone']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['city']; ?></td>
<td><?php echo $row['degree']; ?></td>
<td><?php echo $row['passtout']; ?></td>
<td><?php echo $row['message']; ?></td>
</tr>
<?php
$x++;
}
echo '<script type="text/javascript"> drawChart(); </script>';
?>
</tbody>
</div>
</table>
</div>
</div>
</div>
</div>
<!-- /.container-fluid -->
</div>
<!-- End of Main Content -->
<script>function exportReportToExcel() {
let table = document.getElementsByTagName("table"); // you can use document.getElementById('tableId') as well by providing id to the table tag
TableToExcel.convert(table[0], { // html code may contain multiple tables so here we are refering to 1st table tag
name: `export.xlsx`, // fileName you could use any name
sheet: {
name: 'Sheet 1' // sheetName
}
});
}
</script>
<?php include('footer.php')?>