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 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| <?php
function ODBCResourceToHTML($res, $sTable, $sRow){
$cFields = odbc_num_fields($res);
$strTable = "<table $sTable ><tr>";
for ($n=1; $n<=$cFields; $n++){
$strTable .= "<td $sRow><b>". str_replace("_", " ", odbc_field_name($res, $n)) . "</b></td>";
}
$strTable .= "</tr>";
while(odbc_fetch_row($res)){
$strTable .= "<tr>";
for ($n=1; $n<=$cFields; $n++){
$cell = odbc_result($res, $n);
if ($cell==''){
$strTable .= "<td $sRow> </td>";
}
else{
$strTable .= "<td $sRow>". nl2br(htmlspecialchars($cell)) . "</td>";
}
}
$strTable .= "</tr>";
}
$strTable .= "</table>";
Return $strTable;
}
$cx=odbc_connect('Kwisatz','','');
$cur=odbc_exec($cx,"SELECT * FROM dev_entete");
echo ODBCResourceToHTML($cur, 'Border=0 cellspacing=0 cellpadding=5', "style='FONT-FAMILY:Tahoma; FONT-SIZE:8pt; BORDER-BOTTOM:solid 1pt gree'");
odbc_close($cx);
?> |
Partager