Posted By

graceman9 on 05/28/13

Tagged

Versions (?)

Last Edited at 05/28/13 11:57pm

Statistics

Viewed 615 times

Favorited by 0 user(s)

Related snippets

Upload archive, unzip, process and output multiple *.txt files

/ Published in: PHP

Upload special *.zip file with *.txt data.
*.txt data format is between tags:

From: +380990581747
Date: 21.02.2013
Time: 16:42
Content:
14

Highlighted TextExpand

<?php if (!empty($_FILES)): ?>
<?php

$allowedExts = array("zip");
	$extension = end(explode(".", $_FILES["file"]["name"]));
	if ($_FILES["file"]["size"] < 5000000 && in_array($extension, $allowedExts)) {
		if ($_FILES["file"]["error"] > 0) {
			echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
		}
		else {
			$date = date('Y-m-d_H-i-s');

// // upload info
			// echo "Upload: " . $_FILES["file"]["name"] . "<br>";
			// echo "Type: " . $_FILES["file"]["type"] . "<br>";
			// echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
			// echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br>";
			// exit;

// unzip
			$zip = new ZipArchive;
			$res = $zip->open($_FILES["file"]["tmp_name"]);
			$zip_ok = FALSE;
			if ($res === TRUE) {
				$dir = 'files/'. $date;
				mkdir($dir);
				$zip->extractTo($dir);
				$zip->close();
				$zip_ok = TRUE;
			}

if (!empty($dir)) {

// process
				$result = glob('./'. $dir .'/*.txt');
				if (!empty($result)) {
					foreach($result as $fname) {
						preg_match('|^\.\/'. $dir .'/(.*)$|Uis', $fname, $mass);
						$uploadfile = $mass[1];
						// Ð—Ð°Ð³Ñ€ÑƒÐ¶Ð°ÐµÐ¼ Ñ„Ð°Ð¹Ð» Ð² Ð¼Ð°ÑÑÐ¸Ð²
						// $get_array = file($uploadfile);
						$get_array = file($dir .'/'. $uploadfile);

foreach($get_array as $line) {
							@$line = iconv("UCS-2", "UTF-8", $line);
							$pos = strpos($line, '+380');
							if ($pos !== FALSE) {
								$sub = substr($line, $pos);
								$ars[] = $sub;
							}

// preg_match('|^From\: \+380([0-9]+)$|Uis', $line, $massive);
							// if(@$massive[1] != '') {
							// $ars[] = '+380'.@$massive[1];
							// //$active_sheet->setCellValueByColumnAndRow(0, $key, '+380'.$massive[1]);
							// }

}
					}
					$uniq = array_unique($ars);
					$key = 1;
					$output_array = array();
					foreach($uniq as $value) {
						$output_array[] = $value;
						$key++;
					}

// Ð˜Ð¼Ñ Ð±ÑƒÐ´ÑƒÑ‰ÐµÐ³Ð¾ Ñ„Ð°Ð¹Ð»Ð°
					$filename = $date;

header("Content-disposition: attachment; filename=". $filename .".csv");
					header("Content-Type: text/csv");
					$separator = empty($_POST['separator']) ? "
" : $_POST['separator'];
					print implode($separator, $output_array);
					exit();
				}
				else {
					echo '<div class="error">ÐžÑˆÐ¸Ð±ÐºÐ°: Ð°Ñ€Ñ…Ð¸Ð² Ð½Ðµ ÑÐ¾Ð´ÐµÑ€Ð¶Ð¸Ñ‚ Ñ‚ÐµÐºÑÑ‚Ð¾Ð²Ñ‹Ñ… Ñ„Ð°Ð¹Ð»Ð¾Ð², Ð¸Ð»Ð¸ Ð¾Ð½Ð¸ Ð½ÐµÑÐ¾Ð¾Ñ‚Ð²ÐµÑ‚ÑÑ‚Ð²ÑƒÑŽÑ‚ Ñ‚Ñ€ÐµÐ±ÑƒÐµÐ¼Ð¾Ð¼Ñƒ Ñ„Ð¾Ñ€Ð¼Ð°Ñ‚Ñƒ.</div>';
				}

}

}
	}
	else {
		echo '<div class="error">ÐžÑˆÐ¸Ð±ÐºÐ°: Ð½ÐµÐ´Ð¾Ð¿ÑƒÑÑ‚Ð¸Ð¼Ñ‹Ð¹ Ñ„Ð¾Ñ€Ð¼Ð°Ñ‚ Ñ„Ð°Ð¹Ð»Ð°.</div>';
	}
?>

<div class="back"><a href="./" title="Ð’ÐµÑ€Ð½ÑƒÑ‚ÑŒÑÑ Ðº Ñ„Ð¾Ñ€Ð¼Ðµ">Ð’ÐµÑ€Ð½ÑƒÑ‚ÑŒÑÑ Ðº Ñ„Ð¾Ñ€Ð¼Ðµ</a></div>
<?php else: ?>
<html>
<head>
	<meta charset="utf-8">
	<title>test</title>
	<style type="text/css">
		.main {
			margin: 100px;
			text-align: center;
		}
		.form-wrapper {
		}
		.form-wrapper input[type="submit"] {
		}
		.error {
			color:red;
			padding: 5px;
			border: 1px solid gray;
		}
		.back {
		}
		.back a {
			padding: 5px;
			font-size: 1.5em;
		}
		.main pre {
			text-align: left;
		}
		.tip {
			color: #999;
			font-size: 12px;
		}
	</style>
</head>
<body>
<div class="main">
	<div class="form-wrapper">
		<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data">
			<label for="file" class="tip">Ð¡Ð¸Ð¼Ð²Ð¾Ð»-Ñ€Ð°Ð·Ð´ÐµÐ»Ð¸Ñ‚ÐµÐ»ÑŒ:</label>
			<input type="text" name="separator" value="" placeholder="">
			<br><span class="tip">ÐŸÐ¾-ÑƒÐ¼Ð¾Ð»Ñ‡Ð°Ð½Ð¸ÑŽ (Ð¾ÑÑ‚Ð°Ð²Ð¸Ñ‚ÑŒ Ð¿ÑƒÑÑ‚Ñ‹Ð¼) Ð·Ð½Ð°Ñ‡ÐµÐ½Ð¸Ñ Ñ€Ð°Ð·Ð´ÐµÐ»ÐµÐ½Ñ‹ Ð½Ð¾Ð²Ð¾Ð¹ ÑÑ‚Ñ€Ð¾ÐºÐ¾Ð¹ (
).</span>
			<br>
			<br>
			<br>
			<label for="file">Ð¤Ð°Ð¹Ð»-Ð°Ñ€Ñ…Ð¸Ð²:</label>
			<input type="file" name="file" id="file">
			<input type="submit" name="submit" value="ÐžÑ‚Ð¿Ñ€Ð°Ð²Ð¸Ñ‚ÑŒ">
			<br><span class="tip">Ð¢Ñ€ÐµÐ±ÑƒÐµÑ‚ÑÑ Ð°Ñ€Ñ…Ð¸Ð² Ñ„Ð¾Ñ€Ð¼Ð°Ñ‚Ð° *.zip, ÑÐ¾Ð´ÐµÑ€Ð¶Ð°Ñ‰Ð¸Ð¹ Ð² ÐºÐ¾Ñ€Ð½Ðµ Ð²ÑÐµ Ñ„Ð°Ð¹Ð»Ñ‹. Ð”Ð»Ñ ÑÑ‚Ð¾Ð³Ð¾ Ð½ÑƒÐ¶Ð½Ð¾ Ð²Ñ‹Ð´ÐµÐ»Ð¸Ñ‚ÑŒ Ð²ÑÐµ Ñ„Ð°Ð¹Ð»Ñ‹ Ð¸ Ð´Ð¾Ð±Ð°Ð²Ð¸Ñ‚ÑŒ Ð¸Ñ… Ð² Ð°Ñ€Ñ…Ð¸Ð², Ð° Ð´Ð¾Ð±Ð°Ð²Ð»ÑÑ‚ÑŒ Ð² Ð°Ñ€Ñ…Ð¸Ð² Ð¿Ð°Ð¿ÐºÑƒ Ñ Ñ„Ð°Ð¹Ð»Ð°Ð¼Ð¸.</span>
		</form>
	</div>
</div>
</body>
</html>
<?php endif; ?>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.