ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:csv

CSV File

The syntax required and necessary file formats have not yet been identified from the legacy documentation. Can you help?

Specification
Driver Namecsv
Alternate Nameproxy
Data Providercsv
StatusInactive1)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6Yes

Description

The csv driver allows a CSV file to be read across an http connection and treated like a database table.

  • The only parameter passed in the connect statement is the url of the file
  • https connections are currently not supported.
  • In order to write back data, the file/directory must be writable by the Identity that the web server runs as. This may be a problem in IIS, creating an AppPool specifically for the process may provide a possible solution.
  • Some methods are not supported

Usage

$db = newAdoConnection('csv');
$db->connect('http://127.0.0.1/files/file.csv');
1) This driver is not actively supported or enhanced by ADOdb project members, but you can provide fixes and enhancements if you have the expertise
v5/database/csv.txt · Last modified: 2017/04/21 11:49 (external edit)