Exporting data from database using fopen
| From: | Vern | Date: | Fri, 13 Aug 2004 16:04:29 +0000 |
| Subject: | Exporting data from database using fopen | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193710@lists.php.net to get a copy of this message | ||
I'm trying to write data to a file from a Postgres database using the
following code
<?php
//LOOP THROUGH RECORDSET
while (!$rsITEMS->EOF) {
//CREATE CSV
//OPEN DUMP FILE
$fp = fopen("./dump.sql", "w");
//WRITE DATA TO DUMP
fwrite($fp, "$rsITEMS->Fields('item_id')\n");
//LOOP
$rsITEMS->MoveNext();
}
//CLOSE FILE
fclose($fp);
?>