New question

Question:

 
  0  
 
 
Oso L Karma: 4 Mexico
 
 Date: 22-06-2018 08:21:37 (In Spanish)

¿Cómo puedo exportar tabla HTML a Excel?[Unresolved]

<?php
require_once ("./conexion/conexion.php");

if (!$conn){
    $msg = "Cannot connect to Oracle ".oci_error();
} else {
    $msg = "Connected to Oracle";
}
$sql = 'SELECT * FROM customer';
$stid = oci_parse($conn, $sql);
oci_execute($stid);

    echo "<table border='1'>\n";
        echo "<td>Cust_sID</td>";
        echo "<td>INFO1</td>";
        echo "<td>SBS_NO</td>";
        echo "<td>CREATED_DATE</td>";
        echo "<td>MODIFIED_DATE</td>";
        echo "<td>CMS_POST_DATE</td>";
        echo "<td>Email</td>";
        echo "<td>FST_SALE_DATE</td>";
        echo "<td>LST_SALE_DATE</td>";
        echo "<td>LST_RETURN_DATE</td>";
        echo "<td>LST_SALE_AMT</td>";
        echo "<td>First Name</td>";
        echo "<td>Last Name</td>";


while ($row = oci_fetch_assoc($stid)) {
     echo "<tr>\n";
         echo "<td>". $row["CUST_SID"] . "</td>\n";
         echo "<td>". $row["INFO1"] . "</td>\n";
         echo "<td>". $row["SBS_NO"] . "</td>\n";
         echo "<td>". $row["CREATED_DATE"] . "</td>\n";
         echo "<td>". $row["MODIFIED_DATE"] . "</td>\n";
         echo "<td>". $row["CMS_POST_DATE"] . "</td>\n";
         echo "<td>". $row["EMAIL_ADDR"] . "</td>\n";
         echo "<td>". $row["FST_SALE_DATE"] . "</td>\n";
         echo "<td>". $row["LST_SALE_DATE"] . "</td>\n";
         echo "<td>". $row["LST_RETURN_DATE"] . "</td>\n";
         echo "<td>". $row["LST_SALE_AMT"] . "</td>\n";
         echo "<td>". $row["FIRST_NAME"] . "</td>\n";
         echo "<td>". $row["LAST_NAME"] . "</td>\n";
     echo "</tr>\n";

}

echo "</table>\n";

if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

oci_execute($stid);
while (($row = oci_fetch_array ($stid, OCI_ASSOC)) != false) { // Ignorar los NULL
    //var_dump($row);
    echo "<pre>";

    print_r($row);


    echo "</pre>";


}
oci_free_statement($stid);
oci_close($conn);
?>
 Tags: Excel - HTML - HTML Table - PHP - Question Votes: 0 - Answers: 2 - Views: 14 Share on: Google Facebook Twitter LinkedIn Link
 

Answers:

To actively participate in the community first must authenticate, enter the system.Sign In
 
frjcbbae garagebible.com