note 50575 deleted from function.fwrite by nlopess
| From: | nlopess@php.net | Date: | Thu, 03 Mar 2005 19:43:35 +0000 |
| Subject: | note 50575 deleted from function.fwrite by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-85887@lists.php.net to get a copy of this message | ||
Note Submitter: goncalves at tedablio dot com dot br
----
esta funcao cria um arquivo "meuarquivo.csv" no formato csv de acordo com os campos da
tabela do select !
[POSTGRESQL]
<?
$filename = "meuarquivo.csv";
$Arquivo = fopen($filename, 'w+')
$sql="select * from tabela";
$socket = pg_connect(host=[servidor] port=[porta] dbname=[banco de dados] user=[usuario]
password=[senha], $sql);
////////////////// nome dos campos
for ($a=0;$a < pg_numfields($rs);$a++){
$mLinha .= '"' . pg_fieldname($rs,$a) . '"' . ',';
}
$mLinha .= "\n";
fwrite($Arquivo, $mLinha);
//////////////////////////
/////////////////////////// registros
for ($i=0 ;$i < pg_numrows($rs); $i++){
$ln=pg_fetch_array($rs, $i);
$mLinha = "";
for ($a=0;$a < pg_numfields($rs);$a++){
$mAspas = "";
if (pg_fieldtype($rs,$a) == 'varchar' or pg_fieldtype($rs,$a) == 'date'){
$mAspas = '"';
}
$mLinha .= $mAspas . $ln[pg_fieldnum($rs,pg_fieldname($rs,$a))] . $mAspas . ',';
}
$mLinha .= "\n";
fwrite($Arquivo, $mLinha);
}
///////////////////////////////////////
fclose($Arquivo);
?>