How to Transfer your Data in Database to Excel in PHP/MySQL

Submitted by alpha_luna on Saturday, June 11, 2016 - 15:17.

If you are looking for on how to Transfer your Data in Database to Excel then you are at the right place. This PHP Excel tutorial the user enables to make a backup copy of your data in your database in the form of excel worksheet. Kindly click the button to save the excel file to your computer. Creating a table with your data from the database and one button to download the data and save it as excel file as shown in the image below. Result

Here's the source code in the image above.

<div class="alert alert-info">
    <button type="button" class="close" data-dismiss="alert">&times;</button>
    <strong>Excel Writer</strong>&nbsp;Click The Button to View th e Excel File
</div>
 
<?php
 
$excel = mysql_query("select  * from member")or die(mysql_error());
$row = mysql_fetch_array($excel);
$member_excel_id = $row['member_id'];
?>
 
<form method="POST" action="excel.php">
    <input type="hidden" name="id_excel" value="<?php echo $member_excel_id; ?>">
    <button id="save_voter" class="btn btn-primary" name="save"> Download Excel File </button>
</form>
 
<table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered" id="example">
 
 
    <thead>
        <tr>
            <th>FirstName</th>
            <th>LastName</th>
            <th>MiddleName</th>
            <th>Address</th>
            <th>Email</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $query = mysql_query("select * from member") or die(mysql_error());
        while ($row = mysql_fetch_array($query)) {
            ?>
            <tr>
                <td><?php echo $row['firstname']; ?></td>
                <td><?php echo $row['lastname']; ?></td>  
                <td><?php echo $row['middlename']; ?></td>
                <td><?php echo $row['address']; ?></td>
                <td><?php echo $row['email']; ?></td>
            </tr>
 
 
    </tbody>
</table>

For more question about this source code just email me at [email protected] or comment in this tutorial. Hope that this tutorial will help you a lot.

Thank you

Add new comment

239 views