Import iš tekstinio failo į mysql (Page 1 of 2)

<?php
ini_set("memory_limit","512M");
// nbanba

require_once "maincore.php";

$table_name = "zaidejai";
$file_name = "players.txt";

class CsvImporter {
    private $fp;
    private $parse_header;
    private $header;
    private $delimiter;
    private $length;

    function __construct($file_name, $parse_header=false, $delimiter="\t", $length=8000)
    {
        $this->fp = fopen($file_name, "r");
        $this->parse_header = $parse_header;
        $this->delimiter = $delimiter;
        $this->length = $length;
        $this->lines = $lines;

        if ($this->parse_header)
        {
           $this->header = fgetcsv($this->fp, $this->length, $this->delimiter);
        }

    }

    function __destruct()
    {
        if ($this->fp)
        {
            fclose($this->fp);
        }
    }

    function get($max_lines=0)
    {
        $data = array();

        if ($max_lines > 0)
            $line_count = 0;
        else
            $line_count = -1;

        while ($line_count < $max_lines && ($row = fgetcsv($this->fp, $this->length, $this->delimiter)) !== FALSE)
        {
            if ($this->parse_header)
            {
                foreach ($this->header as $i => $heading_i)
                {
                    $row_new[$heading_i] = $row[$i];
                }
                $data[] = $row_new;
            }
            else
            {
                $data[] = $row;
            }

            if ($max_lines > 0)
                $line_count++;
        }
        return $data;
    }
}

$importer = new CsvImporter($file_name, true);

while($details = $importer->get(30000)) {
dbquery("INSERT INTO ".$table_name." VALUES ()");
$result = dbquery("SELECT * FROM ".$table_name);
$countcols = count(dbarray($result));
dbquery("TRUNCATE TABLE ".$table_name);

$countrows = count($details);

for ($k = 0; $k < $countrows; ++$k) {

$values = "";
$i = 0;

foreach ($details[$k] as &$value) {
    ++$i;
    $countrecs = count($details[0]);
    $countdiff = $countcols - $countrecs;
    $value = iconv("UTF-8", "windows-1257", $value);

    if ($i == $countrecs) {
    $values .= "'".$value."'";
        for ($j = 0; $j < $countdiff; ++$j) {
            $values .= ", ''";
        }
    } else {
    $values .= "'".$value."', ";
    }
}

dbquery("INSERT INTO ".$table_name." VALUES (".$values.")");

}
}

?>