Export/Write rows from DBF to CSV

From: Date: Fri, 13 Mar 2009 13:56:09 +0000
Subject: Export/Write rows from DBF to CSV
Groups: php.general 
Request: Send a blank email to php-general+get-289988@lists.php.net to get a copy of this message
Ave, I'm trying to retrieve data from a DBF database and write it to a CSV file in a comma delimited format. I'm able to get the data and write it to CSV, but it only writes the last row/record ... not all the records. I know I don't have the correct code and I'm hoping someone can help me... _____________ #CREATE CSV $date = date('mdy'); $_file = 'CSV/TransferData_'.$date.'.csv'; $_fp = @fopen( $_file, 'w' ); #SELECT DBF TO OPEN - READ ONLY $db = dbase_open("mydata.dbf", 0); #PULL UP RECORD if ($db) { $record_numbers = dbase_numrecords($db); for ($i = 1; $i <= $record_numbers; $i++) { $row = dbase_get_record_with_names($db, $i); #WRITE ROWS TO VARIABLE $_csv_data = trim($row['PHONE']).",".trim($row['DATE']).","."\n"; <-- THIS is where my problem is! This only writes the last row!! } } #WRITE TO CSV @fwrite( $_fp, $_csv_data ); @fclose( $_fp ); _____________ Thanks! --- Rahul Sitaram Johari Founder, Internet Architects Group, Inc. [Email] sleepwalker@rahulsjohari.com [Web] http://www.rahulsjohari.com

« previous php.general (#289988) next »