<h2>DKP</h2>
	<form method="POST" action="dkp.php">
	<p>Enter one or more queries separated by newlines:</p>
	</p>
	<table width = 1000>
	<tr>
	<th width = 300>Name</th><th>Item</th>
	</tr>
	</table>
	<textarea name="sites" rows = "7" cols = "120" wrap = "Off"></textarea>
	<p><input type="submit"> <input type="reset"></P>
	</form>
 
<?php
function mysql_insert_array($table, $data) {
	foreach ($data as $field=>$value) {
		$fields[] = '`' . $field . '`';
		$values[] = "'" . mysql_real_escape_string($value) . "'";
 
	}
	$field_list = join(',', $fields);
	$value_list = join(', ', $values);
 
	$query = "INSERT INTO `" . $table . "` (" . $field_list . ") VALUES (" . $value_list . ")";
 
	return $query;
}
 
if(isset($_POST['raidData'])) {
$raidInput = $_POST['raidData'];
}
 
if(isset($raidInput)) {
$newArr = explode("\r\n", $raidInput);
foreach ($newArr as $key => $value) {
	if(is_null($value) || empty($value)) {
		unset($newArr[$key]);
	} else {
		$newArr[$key] = trim($value);
	}
	}
 
}
 
 
 
$nameArr = "";
$itemArr = "";
 
foreach($newArr as $line) {
	$arr = explode("\t", $line);
	if($nameArr == "") {
		$nameArr = array($arr[0]);
	} else {
	$nameArr[] .= $arr[0];	
	}
	if($itemArr == "") {
		$itemArr = array($arr[1]);
	} else {
		$itemArr[] .= $arr[1];
	}
 
}
 
mysql_connect;
mysql_select_db;
 
 
 
mysql_insert_array($table, $nameArr);
 
mysql_insert_array($table, $itemArr);
 
 
 
?>