public function importTableHeaderFromCSV($file)
{
$filename = $file . ".csv";
if (!fileExists($filename) and $this->entityexist($file)) {
echo "import can only in a new table";
die;
}
$CSVHandler = new CSVHandler($filename);
$CSVHandler->countColumns();
$data = $CSVHandler->getHeaders();
$HelperFunctions = new HelperFunctions();
$data = $HelperFunctions->array_trim($data);
$Evaluator = new Evaluator();
$date = array_filter($data, $Evaluator->returnOnlyLettersNumbersUnderscore($data));
$sql = "CREATE TABLE IF NOT EXISTS ` " . $file . " ` (";
for ($i = 0; $i <= $CSVHandler->countColumns(); $i++) {
if ($i == 0) {
$sql .= "`" . $data[$i] . "` int(11) NOT NULL auto_increment";
}
$sql .= "`" . $data[$i] . "` varchar(255) NOT NULL default ''";
if ($i == 0) {
$sql .= "PRIMARY KEY (`" . $data[$i] . "`)";
}
}
$sql .= ")";
$result = $this->executeGenericStatement($sql);
if (empty($result)) {
return NULL;
}
}
