Re: MySQL to DBF

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Emilio Alvarado" <aemilio@xxxxxxxxxxxxxxxxx> wrote in message
news:20040519031150.18047.qmail@xxxxxxxxxxxxxxx
> I need to make a dbf file with some mysql records
> The creation of the dbf with the dbase_create works FINE
> Now I need to fill the dbf, I have a mysql database with some of the data,
I
> have the apropiate SQL to view that data but I need to make an array with
> that data and some "", 0.
> How can i do this
>
> Thanks

$result = mysql_query('SELECT ...');

// open your DBF
$dbf = dbase_open($filename, 2);

// get each row as an array
while ($row = mysql_fetch_row($result)) {
    // now insert the row into your DBF, $dbf is your identifier from the
open command
    db_add_record($dbf, $row);
}

Haven't tested it, though. Take a look at the manual page. There are some
user comments that might help you:
http://de.php.net/manual/en/function.dbase-add-record.php


Regards, Torsten

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux