|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2001-02-10 13:54 UTC] jimw@php.net
[2001-06-08 07:18 UTC] cynic@php.net
[2002-01-27 01:30 UTC] sterling@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 13:00:02 2025 UTC |
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!