<?php
	include('include/header.php');	
	// Connect to Mysql	
	include_once('include/class.verifyEmail.php');
	include('include/function.php');
	
?>
	<div class="container main py-3">
		<div class="row">
			<div class="col-md-6">
				<div class="text-center">
					<h3 class="font-weight-bold">EMAIL FILTERING</h3>
					<p>A free online tool to filtering email from the text content.</p>
				</div>
				<form id="email_filter" method="POST" action="">					
					<textarea rows="15" cols="30" class="form-control" id="contents" onkeyup="countChar(this)" name="contents" form="email_filter" required="required" maxlength="10000" placeholder="Copy/paste the text content here. Maximum 10.000 characters."><?php if(isset($results)){ echo var_dump($results); } ?></textarea>
					<div id="charNum"></div>
					<input type="hidden" id="ip_address" name="ip_address" value="<?=$_SERVER['REMOTE_ADDR'] ?>">
					<input type="hidden" id="created_at" name="created_at" value="<?=date('Y-m-d H:i:s') ?>">
					<input type="hidden" id="updated_at" name="updated_at" value="<?=date('Y-m-d H:i:s') ?>">
					<p class="text-center mt-3"><input type="submit" name="submit_email_filter" class="btn btn-success" value="SUBMIT"></p>
				</form>
			</div>
			<div class="col-md-6">
				<div class="text-center">
					<h3 class="font-weight-bold">EMAIL FILTER RESULTS</h3>
					<p>Filtered email list and removed duplicate emails.</p>
				</div>
				<?php
					if(isset($_GET['hash']) && $_GET['hash']){
						
						$result = $conn->query("SELECT * FROM email_filter WHERE hash = '".trim($_GET['hash'])."'");
						while($row = $result->fetch_assoc()){
							$results = $row['content'];
						}
				?>
					<textarea rows="15" cols="30" class="form-control"><?=$results ?></textarea>
				<?php
					}
				?>
			</div>
		</div>
	</div>
	<script>
		  function countChar(val) {
			var len = val.value.length;
			if (len >= 10000) {
			  val.value = val.value.substring(0, 10000);
			} else {
			  $('#charNum').text(10000 - len);
			}
		  };
	</script>	
<?php	
	if(isset($_POST['submit_email_filter']) && $_POST['submit_email_filter']){
		include('include/config_db.php');
		$conn = new mysqli($servername, $username, $password, $dbname);
		mysqli_set_charset($conn, 'UTF8');
		// Check connection
		if ($conn->connect_error) {
		  die("Connection failed: " . $conn->connect_error);
		}else
		$hash = rand_string(20);
		$locate = json_decode(file_get_contents('http://ip-api.com/json/'. $_SERVER['REMOTE_ADDR']));			
			if($locate->status == 'success'){
				$locate = $locate->city .'-'. $locate->regionName .'-'. $locate->country;
			}
		
		$contents = array_unique(extract_emails($_POST['contents']));
	
		$contents = implode(",", $contents);
		
		$sql_fillter = "INSERT INTO email_filter (hash, content, ip_address, locate, created_at) VALUES 
			('$hash', '$contents', '".$_POST['ip_address']."', '$locate', '".date('Y-m-d H:i:s')."')";
			
		
		
		if ($conn->query($sql_fillter) === TRUE) {			
			echo "<p style='text-align: center;'>Email filtering successful. </p>";	
			echo "<h3 style='text-align: center;'><a href='/email-filtering.php?hash=".$hash."'><button type='button'  style='text-align: center;' class='btn btn-primary btn-lg'>VIEW RESUALT</button></a></ha>";
			//echo "<h3 style='text-align: center;'><a href='/email-filtering.php?hash=".$hash."'>RESULT</a></h3>";
			//header("Location: ?hash=$hash");
			} else {
				  echo "An error occurred <br>" . $conn->error;
			}
				
		
		
	}
	include('include/footer.php');	
?>