note 46202 deleted from function.ibase-fetch-row by aidan
| From: | aidan@php.net | Date: | Sat, 02 Oct 2004 06:41:44 +0000 |
| Subject: | note 46202 deleted from function.ibase-fetch-row by aidan | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-77729@lists.php.net to get a copy of this message | ||
Note Submitter: Paulo Crestani - pcrestani at hotmail dot com
----
<html>
<head>
<title>PHP com Interbase</title>
<style type="text/css">
td { font-family: tahoma; font-size: 10pt; }
</style>
</head>
<body>
<table cellpadding="2" cellspacing="0" width="50%">
<tr bgcolor="#AAccCC">
<td>Nome</td><td>Sobrenome</td><td>Nascimento</td>
</tr>
<?
$host = "127.0.0.1:D:\Arquivos de
programas\Borland\InterBase\Examples\database\EMPLOYEE.GDB";
$user = "SYSDBA";
$pass = "masterkey";
$conn = ibase_connect($host,$user,$pass);
$consulta = ibase_query($conn,"select * from EMPLOYEE");
$i = 0;
while($resultado = ibase_fetch_row($consulta)){
if($i % 2 == 0) $cor = "#FFFFFF"; else $cor = "#eeeeee";
$nome = $resultado[1]; $sobrenome = $resultado[2];
$nasc = $resultado[4];
$nascimento = explode(" ",$nasc);
$data = $nascimento[0];
$data = date('d/m/Y',strtotime($data));
?>
<tr bgcolor="<?=$cor;?>">
<td><?=$nome;?></td><td><?=$sobrenome;?></td><td><?=$data;?></td>
</tr>
<?
$i++;
}
?>
</table>
</font>
</body>
</html>