CVS challenges

[dianaqt]

I've rooted for hours and have found every-which way to delete an entire row from SQL db.... but what about a CVS file?

I'm looking to create an easy way to add (which I've figured out) and DELETE rows via an admin utility. I'm stumped...

Anyone out there kind enough to point me in the right direction?

Thanks a bunch,

Diana

[jpmoriarty]

what's a CVS file?

[dianaqt]

The file is just a regular .txt file. I'm using the file to collect & look up info... but I will need to change row's within the file time to time. Instead of pulling down the file and manually editing it, I am building a admin that will select a specific row and delete it.

So far about the only solution I have found to the problem is to place the entire .txt file into a variable, remove the row that needs to be removed, Delete the old file and then write a new txt file with the entry deleted.

I was hoping that there would be an easier way to delete just one row in the .txt file, instead of having to delete the entire file and rebuild it.

I've looked at preg_replace, locating the row to be erased, placing it into a variable and edit it so it has no value... I just can't figure out how to actually Delete it from the txt file.

For example... if the txt file looked like this:

1111,entryOne,data
2222,entryTwo,data
3333,entryThree,data

How would I erase the entire 2222 row from the txt file WITHOUT having to grab the entire file, erase the 2222 row entry, erase the old file & save the new file with the 2222 row deleted?

Thanks for any help or direction...

[poison]

hi

class CSVDatabase {
	var $_data;

function CSVDatabase ($file=null) {
	if (!is_null($file)) {
		$this->open($file);
	}
}

function open ($file) {
	// doityourself =)
}

function save () {
	// doityourself =)
}

/**
* @return void
* @param int $col
* @param mixed $value
* @desc erase particular row in databse having the specified $value in the $col umn
*/
function eraseRow ($col, $value) {
	// generate PCRE (has to be slightly changed if it should discard whitespaces...
	$pcre='/^';
	for ($i=0; $i<$col; ++$i) {
		$pcre.='[^,]*?\,';
	}
	$pcre.=preg_quote($value);
	$pcre.='(\,.*?\r?\n|\r?\n)/sm';
	// replace line
	$this->_data=preg_replace($pcre, '', $this->_data);
}

}
$db=new CSVDatabase();
$db->_data='1111,entryOne,data
2222,entryTwo,data
3333,entryThree,data
';
$db->eraseRow(0, 1111);
echo $db->_data . '<br><br>';
$db->eraseRow(1, 'entryTwo');
echo $db->_data . '<br><br>';

hope this helps =D
btw, it's a CSV (comma seperated values) not CVS (concurrent versions system) file 😉
regards

[poison]

ok...here goes a slightly improved version

class CSVDatabase {
	var $_data=null;
	var $_filename=null;

/**
* @return CSVDatabase
* @param string[optional] $file
* @desc class for manipulating CSV files
*/
function CSVDatabase ($file=null) {
	if (!is_null($file)) {
		$this->open($file);
	}
}

/**
* @return void
* @param string $file
* @desc open specified database file
*/
function open ($file) {
	$this->_data=join ('', file($file));
	$this->_filename=$file;
}

/**
* @return void
* @desc save database
*/
function save () {
	$fp=fopen ($this->_filename, "wb");
	fwrite ($fp, $this->_data);
	fclose ($fp);
}

/**
* @return void
* @param int $col
* @param mixed $value
* @desc erase particular row in databse having the specified $value in the $col umn. value can also be an array...
*/
function eraseRow ($col, $value) {
	// generate PCRE (has to be slightly changed if it should discard whitespaces...
	$pcre='/^';
	for ($i=0; $i<$col; ++$i) {
		$pcre.='[^,]*?\,';
	}
	if (is_array($value)) {
		$pcre.='(';
		for ($i=0; $i<count($value); ++$i) {
			$pcre.=preg_quote($value[$i]);
			if ($i<(count($value)-1)) {
				$pcre.='|';
			}
		}
		$pcre.=')';
	} else {
		$pcre.=preg_quote($value);
	}
	$pcre.='(\,.*?\r?\n|\r?\n)/sm';

	// replace line
	$this->_data=preg_replace($pcre, '', $this->_data);
}


/**
* @return void
* @param array $values
* @desc add row to database. expects 1D array with values
*/
function addRow ($values) {
	$this->_data.=join(',', $values) . "\n";
}


/**
* @return array
* @param int $key_col
* @param mixed $key_value
* @desc get row for particular key value in 1D array
*/
function getRow ($key_col, $key_value) {
	$pcre='/^(';
	for ($i=0; $i<$key_col; ++$i) {
		$pcre.='[^,]*?\,';
	}

	$pcre.=preg_quote($key_value);

	$pcre.='(\,.*?\r?\n|\r?\n))/sm';

	// fetch row
	preg_match($pcre, $this->_data, $result);
	$result=split(',', trim($result[0]));

	return ($result);
}




}

// ---------
// } usage {
// ---------

//$db=new CSVDatabase('yourcsvfile.txt');

$db=new CSVDatabase();
// data needs newline at end
$db->_data='1111,entryOne,data
2222,entryTwo,data
3333,entryThree,data
4444,entryFour,data
5555,entryFive,data
6666,entrySix,data
';


$db->addRow(array(7777, 'entrySeven', 'data'));

$db->eraseRow(0, 6666);

echo $db->_data;

var_dump($db->getRow(0, 4444));
//$db->save();

have fun =D