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);
?>