cvs

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

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

Moved.

:lol: - does he mean CSV? ;)

Oh crap... maybe.

I am glad I gave you that negative rep.

Quote:

---

Originally Posted by visualAd

:lol: - does he mean CSV? ;)

---

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

Quote:

---

Originally Posted by vbbit

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?

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.

Quote:

---

Originally Posted by 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.

---

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).

Quote:

---

Originally Posted by RhinoBull

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? :D

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:

PHP Code:

---

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().

PHP Code:

---

$csv = new CSVCreator;

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

echo($csv->create()); 


---

Quote:

---

Originally Posted by visualAd

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

---

Ah... just noticed that. :D

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?

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.