Re: Export/Write rows from DBF to CSV

On Fri, Mar 13, 2009 at 9:56 AM, Rahul S. Johari < sleepwalker@rahulsjohari.com> wrote: > 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 > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > You are overwriting the variable ($csv_data) that holds the row, add a period (concatenator) operator to build the up the data #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!! -- Bastien Cat, the other other white meat