File: /var/www/html/tmpr/../tmpr/../tmpr/../v/importExcel.php
<?php
include("../includes/limittext.php");
include('../Connections/videoondemand.php');
require("../DbSql.inc.php");
require("../NewsSql.inc.php");
require("../const.inc.php");
$db = new NewsSQL($DBName);
function filter($arr) {
global $link;
return array_map(array($link, 'real_escape_string'), $arr);
}
$_GET = filter($_GET);
$_POST = filter($_POST);
/**
* XLS parsing uses php-excel-reader from http://code.google.com/p/php-excel-reader/
*/
header('Content-Type: text/plain');
if (isset($argv[1]))
{
$Filepath = $argv[1];
}
elseif (isset($_GET['File']))
{
$Filepath = "uploads/mydata/".$_GET['File'];
}
else
{
if (php_sapi_name() == 'cli')
{
echo 'Please specify filename as the first argument'.PHP_EOL;
}
else
{
echo 'Please specify filename as a HTTP GET parameter "File", e.g., "/test.php?File=test.xlsx"';
}
exit;
}
// Excel reader from http://code.google.com/p/php-excel-reader/
require('../brandExcel/php-excel-reader/excel_reader2.php');
require('../brandExcel/SpreadsheetReader.php');
date_default_timezone_set('UTC');
/*$StartMem = memory_get_usage();
echo '---------------------------------'.PHP_EOL;
echo 'Starting memory: '.$StartMem.PHP_EOL;
echo '---------------------------------'.PHP_EOL;
*/
try
{
$Spreadsheet = new SpreadsheetReader($Filepath);
$BaseMem = memory_get_usage();
$Sheets = $Spreadsheet -> Sheets();
$Time = microtime(true);
$Spreadsheet -> ChangeSheet(0);
foreach ($Spreadsheet as $Key => $Row )
{
/*echo $Key.': ';*/
if ($Row)
{
/**/
$rowNew = json_encode($Row);
$rowNew = str_replace('[','',$rowNew);
$rowNew = str_replace(']','',$rowNew);
$cats = explode(",", $rowNew);
foreach($cats as $key => $cat) {
$columns = $key;
$cat = trim($cat);
$cat = str_replace('"','',$cat);
$record .="'column$key':'".$cat . "',";
}
}
else
{
var_dump($Row);
}
$CurrentMem = memory_get_usage();
/* echo 'Memory: '.($CurrentMem - $BaseMem).' current, '.$CurrentMem.' base'.PHP_EOL;
echo '---------------------------------'.PHP_EOL;*/
/* if ($Key && ($Key % 500 == 0))
{
echo '---------------------------------'.PHP_EOL;
echo 'Time: '.(microtime(true) - $Time);
echo '---------------------------------'.PHP_EOL;
}*/
}
/*echo PHP_EOL.'---------------------------------'.PHP_EOL;
echo 'Time: '.(microtime(true) - $Time);
echo PHP_EOL;
echo '---------------------------------'.PHP_EOL;
echo '*** End of sheet '.$Name.' ***'.PHP_EOL;
echo '---------------------------------'.PHP_EOL;*/
/* $rowNew = str_replace('[','{',$rowNew);
$rowNew = str_replace(']','}',$rowNew);
echo $rowNew ;*/
//echo $columns;
$db ->updateDataColumn($newsid,$columns);
$rowNew = str_replace("','column0'","',{'column0'",$record);
$rowNew = str_replace("',{'column0'","'},{'column0'",$rowNew);
$rowNew = $rowNew."}";
$rowNew = str_replace("',}","'}",$rowNew);
$rowNew = "{".$rowNew;
$rowNew = "[".$rowNew;
$rowNew = $rowNew."]";
$rowNew = str_replace("','",'","',$rowNew);
$rowNew = str_replace("':'",'":"',$rowNew);
$rowNew = str_replace("{'",'{"',$rowNew);
$rowNew = str_replace("'}",'"}',$rowNew);
echo $rowNew ;
}
catch (Exception $E)
{
echo $E -> getMessage();
}
?>