Export array to csv or xls with php and oracle

0

I need to be able to export an array to csv, please, the code:

 <?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);
?>
    
asked by Francisco 13.03.2018 в 19:04
source

0 answers