Server IP : 108.170.25.35 / Your IP : 18.116.86.255 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/private_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')?>