break;
case "dot":
$separator = ".";
break;
case "colon":
$separator = ":";
break;
case "semicolon":
$separator = ";";
break;
case "other":
$separator = stripslashes($arr_in["otherseparator"]);
break;
default:
$separator = stripslashes($arr_in["separator"]);
break;
}
$csv = new csv("../uploads/" . $arr_in["filename"], $separator, stripslashes($arr_in["enclosure"]), $charset);
$_SESSION["filename"] = $arr_in["filename"];
$_SESSION["separator"] = $separator;
$_SESSION["enclosure"] = stripslashes($arr_in["enclosure"]);
$_SESSION["csvdata"] = $retstr = json_encode($csv->getArrCsv());
/*
if (count($csv) == 0) { //csv file is empty
$_SESSION["total_num_columns_in_csv"] = 0;
} else {
$_SESSION["total_num_columns_in_csv"] = count($csv[0]); //row 0 are the title.
}
*/
//$_SESSION["test"] = $csv->getArrCsv();
echo $retstr;
<?php
session_start();
require_once "../class/db.class.php";
require_once "../class/csv.class.php";
$arr_in = json_decode(file_get_contents('php://input'), true);
if (!isset($_SESSION["csvdata"])) {
$csv = new csv("../uploads/" . $_SESSION["filename"], $_SESSION["separator"], $_SESSION["enclosure"], "ISO-8859-1");
$arr_csv = $csv->getArrCsv();
} else {
$arr_csv = json_decode($_SESSION["csvdata"]);
}
$db = new db();
$issue = $db->insert($_SESSION["tablename"], $_SESSION["dbcolumnslist"], $arr_in, $arr_csv);
echo json_encode($issue);
function debug($string)
{
ob_start();
$var = func_get_args();
call_user_func_array('var_dump', $var);
$string = ob_get_clean();
if ($fp = fopen("../debug.txt", "w")) {
fwrite($fp, $string . "\n");
fclose($fp);
}
}
