File: C:/xampp/htdocs/ACFrame/TVI-parsing12.php
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5" />
<title>GW publication system</title>
<?php
$dStr=rand(1,1000);
///1025
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{ ///1204
//echo "Upload: " . $_FILES["file"]["name"] . "<br />";
$filename=$dStr.$_FILES["file"]["name"];
//echo "Type: " . $_FILES["file"]["type"] . "<br />";
// echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
// echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" .$dStr. $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ". "<br />";
}
else
{ ////1023
move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" .$dStr. $_FILES["file"]["name"]);
// echo "upload sucess! " . "<br />";
$contents = file("upload/".$dStr.$_FILES["file"]["name"]);
$str = implode($contents);
//echo $contents[20];
//echo $str;
function get_string_between($string, $start, $end){
$string = " ".$string;
$ini = strpos($string,$start);
if ($ini == 0) return "";
$ini += strlen($start);
$len = strpos($string,$end,$ini) - $ini;
return substr($string,$ini,$len);
}
//$fullstring = "this is my [tag]dog[/tag]";
$parsed = get_string_between($str, "�H�H�X���i��", "�i��s�Ƥ�����");
//echo $parsed; // (result = dog)
$string = str_replace(array('\'', '"'), '', $parsed);
$p = ereg_replace("\r\n?", "\t", $string);
$dotPT = explode("\t", $string);
$csvname = substr($_FILES["file"]["name"], 0, -4);
echo $csvname."<br />";
for($x=0;$x<=110;$x++){
//echo $x."--".$dotPT[$x]."<br />";
if ( preg_match('/\r\n?/',$dotPT[$x]) ){
$chunk=$x+1;
echo "chunk: ".$chunk." is it<br />";
break;
}}
//echo "<br>$pt=".$pt;
$p = str_replace("\n", ',', $p);
echo $p;
$dot = explode("\t", $p);
echo "array size=".(sizeof($dot)-1)."<br />";
//echo "dot-19=".$dot[19];
$copy=(((sizeof($dot)-1)/$chunk)-2);
echo "copy of namecard=".$copy."<br />";
$connection = mysql_connect("127.0.0.1", "root", "fredsql") or die ("Unable to connect!");
mysql_query("SET NAMES 'big5'");
$db = "jjbook";
// select database
mysql_select_db($db) or die ("Unable to select database!");
$cell=$copy*$chunk-$chunk;
for ($i=44; $i<=$cell;$i=$i+22) {
$j=$i+8;
$page = substr($dot[$j], 0, -1); // returns "abcde
$k=$i-4;
$dstr=$dot[$k];
$dstr1=str_replace("��", "-", $dstr);
$dstr2=str_replace("��", "", $dstr1);
$pDate="2013-".$dstr2;
$pMtr=$dot[$k+1];
$pMtr1=str_replace("��", "", $pMtr);
$pMon="2013-".$pMtr1."-01";
$snid=$dot[$k+2];
$jjid=$dot[$k+3];
$distr=$dot[$i+1];
$distr1=str_replace("��", "-", $distr);
$distr2=str_replace("��", "", $distr1);
$dataIn="2013-".$distr2;
$editor=$dot[$i+3];
$pfstr=$dot[$i+5];
$pfstr1=str_replace("��", "-", $pfstr);
$pfstr2=str_replace("��", "", $pfstr1);
$proof1="2013-".$pfstr2;
$dcstr=$dot[$i+7];
$dcstr1=str_replace("��", "-", $dcstr);
$dcstr2=str_replace("��", "", $dcstr1);
$docDate="2013-".$dcstr2;
// generate and execute query
$query ="INSERT INTO pbchart(jobname, page,pDate,pMon,snid,jjid,dataIn,editor,proof1,docDate) VALUES('$dot[$i]', '$page', '$pDate','$pMon','$snid','$jjid','$dataIn','$editor','$proof1','$docDate')";
//echo $query;
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
echo $i."=".$dot[$i].$dot[$j].$dstr.$pMon."X".$pfstr;
}
$duble=" select MAX(`pid`) as max from `pbchart` group by `jobname` having count(*)>=2 ";
//$duble=" select `pid`, `jobname` from `pbchart` group by `jobname` having count(*)>=2 ";
echo $duble;
$resultDB=mysql_query($duble) or die ("Error in query: $duble. " . mysql_error());
while($row = mysql_fetch_object($resultDB)){
echo "pid=".$row->max."<p>";
$qdel="delete from pbchart where pid='$row->max'";
$delDB=mysql_query($qdel) or die ("Error in query: $duble. " . mysql_error());
}
mysql_close($connection);
}}
?>