cvs

[vbbit]

Hi how can I use CVS? I meant how can I make a cvs file?

[penagate]

You need to download it if you don't already have it.
http://ftp.gnu.org/non-gnu/cvs/

Moved.

[visualAd]

- does he mean CSV?

[penagate]

Oh crap... maybe.

[visualAd]

I am glad I gave you that negative rep.

[RhinoBull]

- does he mean CSV?

LOL... CVS is pharmacy chain in my town.

Hi how can I use CVS? I meant how can I make a cvs file?

Where is the data come from and what language do you use to program?

[vbbit]

The data will be coming from mysql, and I want to use PHP to program. Is it CVS or CSV? lol.. P told me to download something I have no idea.

[RhinoBull]

The data will be coming from mysql, and I want to use PHP to program. Is it CVS or CSV? lol.. P told me to download something I have no idea.

In that case you better off posting this in PHP forum directly or ask mods to move it.
And it's CSV - comma separated values (if that's what you need).

[visualAd]

In that case you better off posting this in PHP forum directly or ask mods to move it.
And it's CSV - comma separated values (if that's what you need).

Don't you mean ask the mods to move it back?

[visualAd]

CSV = Comma Separated Values.

They are very easy to create, you just need to ensure you follow the following rules:

• Each row is terminated with a carriage return / line feed "\r\n" in terms of PHP.
• Fields are separated by commas.
• Fields that contain strings with spaces, commas or newlines are enclosed in double quotes.
• Double quotes inside strings are escaped with two successive double quotes " "" ".
• The first row may be the column names.

You could have a simple class that creates it for you:

class CSVCreator
{
    private $rows = array();
    
    /* an array of data to add */
    public function addRow($data)
    {
    if (! is_array($data)) {
        throw new Exception('Bad data format');
    }

        $this->rows[] = $data;
    }

    /* $cols can contain an array of column names */
    public function create($cols = null)
    {
    $ret = '';
    $rows = $this->rows; // get a copy of the data

    if (is_array($cols)) {
        // prepend to the beginning of the arrray
        array_unshift($rows, $cols);
    }

    foreach ($rows as $row) {
        $strRow = '';
        foreach($row as $col) {
        if (! is_numeric($col)) {
             // enclose all strings in quotes and escape quotes
            $col = '"' . str_replace('"', '""', $col) . '"';
        }

                $strRow .= $col . ',';
        }

        $strRow = substr($strRow, 0, -1); // strip off the last comma if needed
        $ret .= $strRow . "\r\n";
    }

    // strip off last line break \r\n    
    $ret = substr($ret, 0, -2);

    return $ret;
    }
} 

You use it by simply supplying it with the results from a function like mysql_fetch_row().

$csv = new CSVCreator;

while (($row = mysql_fetch_row())) {
    $csv->addRow($row);
}

echo($csv->create()); 

[RhinoBull]

Don't you mean ask the mods to move it back?

Ah... just noticed that.

[vbbit]

Oh so after I got that csv file, what is its extension I should save to? and how can I insert it in Ms. Access? or sql server?

[visualAd]

Save it with whatever extension you like. Although as it is a CSV file, using a .csv extension would be the most logical thing to do.