PHP Classes

File: index.php

Recommend this page to a friend!
  Classes of ganesh kavhar   PHP Export MySQL Query to Excel   index.php   Download  
File: index.php
Role: Auxiliary script
Content type: text/plain
Description: Auxiliary script
Class: PHP Export MySQL Query to Excel
Download an Excel file from MySQL query results
Author: By
Last change:
Date: 9 months ago
Size: 2,226 bytes
 

Contents

Class file image Download
<?php

include('config.php');

?>



<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="utf-8">

    <title>How fetch Data in excel in PHP</title>

        <meta name="viewport" content="width=device-width, initial-scale=1">

    <link href="https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css" rel="stylesheet">

    <style type="text/css">

        .custab{

    border: 1px solid #ccc;

    padding: 5px;

    margin: 5% 0;

    box-shadow: 3px 3px 2px #ccc;

    transition: 0.5s;

    }

.custab:hover{

    box-shadow: 3px 3px 0px transparent;

    transition: 0.5s;

    }

    </style>

    <script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>

    <script src="https://netdna.bootstrapcdn.com/bootstrap/3.0.0/js/bootstrap.min.js"></script>

</head>

<body>

<div class="container">

    <div class="row col-md-12 custyle">

    <table class="table table-striped custab">

    <thead>

    <a href="genrate-excel.php" class="btn btn-primary btn-xs pull-right"><b>+</b>Genrate Excel</a>

        <tr>

            <th>Sr.</th>

            <th>Name</th>

            <th>Email id</th>

             <th>Phone Number</th>

            <th>Department</th>

            <th>Joining Date</th>

        </tr>

    </thead>

<?php

$query
=mysqli_query($con,"select * from tblemploye");

$cnt=1;

while (
$row=mysqli_fetch_array($query)) {



?>



            <tr>

                <td><?php echo $cnt; ?></td>

                <td><?php echo $row['fullName']?></td>

                <td><?php echo $row['emailId']?></td>

                <td><?php echo $row['phoneNumber']?></td>

                <td><?php echo $row['department']?></td>

                <td><?php echo $row['joiningDate']?></td>

            </tr>

<?php

$cnt
++;

}
?>

        

    </table>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- fordemos -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-8906663933481361"
     data-ad-slot="9236995934"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
    </div>

</div>

</body>

</html>