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; } }