php table exporting it to excel [duplicate]

Question

ok so i have this code for a table.

$idUser = $_SESSION['id'];
$query = "SELECT b.*, c.name FROM bookings b JOIN user c ON b.userId=c.userId WHERE b.date >=CURDATE() and isdelete=0";
$result = mysqli_query($link, $query);
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo '<tr>';
        echo '<td>' . $row['id'] . '</a></td>';
        echo '<td>' . $row['date'] . '</td>';
        echo '<td>' . $row['start'] . '</td>';
        echo '<td>' . $row['name'] . '</td>';
        if($row['isPayed']==0){
          echo '<td>Blom Lunas</td>';
        }
        else{
          echo '<td>Sudah Lunas</td>';
        }
        echo '</tr>';
    }
} else {
    echo '<tr><td colspan="6">No data in table</td></tr>';
}
echo '</table>';

how can i import this table into excel when i click a button bellow the table.

thx @RST good find

Drew
– Drew

2016-11-27 15:18:57 +00:00
Commented Nov 27, 2016 at 15:18 — Drew
– Drew, Commented Nov 27, 2016 at 15:18

piotr · Accepted Answer · 2016-11-27 15:19:03Z

0

Best option is exporting selected data to csv file, not drawing table. Something like that:

$filename = 'data.csv';
while ($row = mysqli_fetch_assoc($result)) {
    $array_od_data = [
        $row['id'],
        $row['date'],
        $row['start'],
        $row['name'],
        $row['isPayed'] == 0 ? 'Blom Lunas' : 'Sudah Lunas'
    ];
    $line = implode(',', $array_od_data) . '\r\n';
    file_put_contents($filenae, $line, FILE_APPEND);
}

Then simply import data.csv file into Excel sheet

answered Nov 27, 2016 at 15:19

piotr

1,2821 gold badge9 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

php table exporting it to excel [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related