ID: 2931
Updated by: sterling
Reported By: [EMAIL PROTECTED]
Old Status: Analyzed
Status: Closed
Bug Type: Feature/Change Request
Operating System: IBM AIX 4
PHP Version: 4.0
New Comment:
This is more of a feature request for PEAR's DB.php... Your welcome to
implement it, still, not a PHP feature request (at least not one to be
implemented).
Previous Comments:
------------------------------------------------------------------------
[2001-06-08 07:18:36] [EMAIL PROTECTED]
Looks like more of a candidate for a PEAR class. You're welcome to
implement it. :)
------------------------------------------------------------------------
[2001-02-10 13:54:08] [EMAIL PROTECTED]
refiling against 4.0.
------------------------------------------------------------------------
[1999-12-07 13:07:32] [EMAIL PROTECTED]
One of the many plugins for Perl's DBI module is the DBD::CSV module.
This allows users to treat a CSV file as if it were a real database.
Instead of manually reading a file line-by-line and parsing it to find
the fields I want, I can write code like this:
$dbh = DBI->connect("DBI:CSV:f_dir=/foo/bar;"
. "csv_eol=\r\n;"
. "csv_sep_char=\t;");
$sth = $dbh->prepare("SELECT * from foo where fn='Dave'");
$sth->execute();
$dbh->do("DELETE from foo where fn='Dave'");
The advantage of this is primarily:
- easier code to write, and
- easy portability to a real database later (almost as simple as
changing all references from DBD:CSV to DBD:MySQL)
I know PHP4 is moving in the direction of a DBI-like solution, and
that's great. In the meantime, would it be possible to add CSV
"database" support to PHP? (csv_connect, csv_query, csv_fetch_array,
etc.) to simulate the operations of a database on a CSV file?
Thanks!
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=2931&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]