1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| $lStr = "<html><body><table border='1'>";
if ($lib!="") {
$lStr .= "<tr align='center' bgcolor='".$bg."'><td colspan='".ocinumcols($stmt)."'>";
$lStr .= "<b>".$lib."</b></td>";
$lStr .= "</tr><tr align='center' bgcolor='".$bg."'>";
$ncols = OCINumCols($stmt);
for ($i = 1; $i <= $ncols; $i++)
{
$col = OCIColumnName($stmt, $i);
$lStr .= "<td><b>".$col."</b></td>";
}
$lStr .= "</tr>";
}
$lign = 1;
while(ocifetch($stmt)) {
$cpt=1;
$lStr .= "<tr>"; while($cpt<=ocinumcols($stmt)) {
$lStr .= "<td> ".ociresult($stmt_req,$cpt)."</td>";
$cpt++;
}
$lStr .= "</tr>";
$lign++;
}
$lStr .= "</table></body></html>";
$headers = "From: moi@moi.com\n";
$headers .= "MIME-version: 1.0\n";
$headers .= "Content-type: text/html; charset= iso-8859-1\n";
mail("moi@moi.com", "titre", $lStr, $headers); |
Partager