Re: Export/Write rows from DBF to CSV

I'm trying to adopt this piece of code for my use. I fixed the csv_data .= trim error. Does anyone know how I can fix empty fields? Everything is dumping to a csv file but information is not matching up. I don't know if I can insert a space or something if field is blank? Rahul S. Johari-2 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 ); > > -- View this message in context: http://old.nabble.com/Export-Write-rows-from-DBF-to-CSV-tp22496924p27646825.html Sent from the PHP - General mailing list archive at Nabble.com.