Read php file using php file and excel export

Question

I have two files like below.

What I'm trying to do is, I want to fetch the second file content in first file, and then export it to xls.

What is the problem with the below code.

My intension is to - read a second php file using first php file, and then excel export that content into .xls in C:/myfiles/test.xls

index.php

    <?php
    $read_file = readfile("my_export_file.php");
    $file = 'test.xls';
    header("Content-type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename=$file");
    echo $read_file;
    ?>

my_export_file.php

    <script type="text/javascript"> my javascript content</script>
    <?php
    include 'db.php';
    $my_query = "mysql query to get the table content";
    ?>
    <table>
    <tr><td>.. mysql row content ..</td><td>.. mysql row content ..</td></tr>
    <tr><td>.. mysql row content ..</td><td>.. mysql row content ..</td></tr>
    <tr><td>.. mysql row content ..</td><td>.. mysql row content ..</td></tr>
    </table>

Could someone help me to get this done.

Thanks in advance.

Regards, Kimz

You should echo your html in my_export_file.php & then just include it in index.php instead of readfile — Rajesh Ujade
– Rajesh Ujade, Commented Sep 26, 2014 at 9:25
@rajeshujade - could u add your thoughts/comments so that it will be more helpful. — user3350885
– user3350885, Commented Sep 26, 2014 at 9:40

Bhupender Keswani · Accepted Answer · 2014-09-26 10:05:17Z

1

Found out solution, try this:

index.php

<?php
ob_start();
include "my_export_file.php";
$contents = ob_get_contents();
ob_end_clean();
echo $contents; //get whole content/test
?>

Hope this help you.

answered Sep 26, 2014 at 10:05

Bhupender Keswani

1,2281 gold badge10 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3350885 Over a year ago

excel export ? how to attach the $contents to excel export.?

Bhupender Keswani Over a year ago

add your following code before "echo $contents;" : header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=$file");

Rajesh Ujade · Accepted Answer · 2014-09-26 09:47:16Z

In your export.php file you should fetch result & create table with results. Then just echo that table as given in example.

my_export_file.php

    <?php
    include 'db.php';
    $my_query = "mysql query to get the table content";

    $html = "<table>"
    $html .= "<tr><td>.. mysql row content ..</td><td>.. mysql row content ..</td></tr>";
    $html .= "<tr><td>.. mysql row content ..</td><td>.. mysql row content ..</td></tr>";
    $html .= "<tr><td>.. mysql row content ..</td><td>.. mysql row content ..</td></tr>";
    $html = ."</table>";
    ?>

index.php

    <?php
    require_once("my_export_file.php");
    $file = 'test.xls';
    header("Content-type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename=$file");
    echo $html;
    ?>

Collectives™ on Stack Overflow

Read php file using php file and excel export

index.php

my_export_file.php

2 Answers 2

2 Comments

my_export_file.php

index.php

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

index.php

my_export_file.php

2 Answers 2

2 Comments

my_export_file.php

index.php

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related