I got this error : Warning: dbase_open() [function.dbase-open]: unable to open database pmast.dbf in C:\Program Files\Apache Group\Apache2\htdocs\Lending\foxpro_dsn.php on line 10
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
#CREATE CSV
$date = date('mdy');
$file = 'CSV/TransferData'.$date.'.csv';
$fp = @fopen( $file, 'rw' );
#SELECT DBF TO OPEN - READ ONLY
$db = dbase_open("pmast.dbf", 0);//Z:\SECPAY1
//$file_dbf = 'pmast.dbf';
//$db = dbase_open($file_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);
[COLOR="#40E0D0"]#WRITE ROWS TO VARIABLE[/COLOR]
echo [COLOR="#0000FF"]$row[/COLOR]['empno'];
[COLOR="#0000FF"]$row[/COLOR]['category'].","."\n";
}
}
#WRITE TO CSV
@fwrite( $fp, $csv_data );
@fclose( $_fp );
?>
Please suggest me a solution...
Thanks
Lalith