On Thu, Feb 18, 2010 at 02:31:00PM -0800, OBXer wrote:
>
> 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 );
> >
> >
>
> 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?
>
What do you mean "fix" empty fields? And what do you mean by
"information is not matching up"?
You shouldn't insert spaces where there are blank fields. Just leave
them blank. The commas are supposed to delimit all the fields, including
the empty ones. Like:
John,Smith,,123 Main St,Tucson,AZ,,,,
Paul
--
Paul M. Foster
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
