Untitled


    <?php header('Content-Type: text/html; charset=utf-8'); ?>
<html>
	<head>

		<meta name="google" content="notranslate">
		<meta charset="UTF-8">
		 <!--[if !mso]><!-- -->
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<!--<![endif]-->
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">


		<?php
		//echo ' <meta http-equiv="refresh" content="0;url=../mail.php?emailUpdate=' . $emailsCount . '" />';
		include("../assets/sqlconfig.php");
		$emailsCount = 0;?>

	</head>
	<body>

		<?php
		error_reporting(0);

		echo '<a href="../mail.php">Back</a>';
    // Multiple email account
		$emails = array(
			array(
				'no'		=> '1',
				//'label' 	=> '########',
				'host' 		=> '########',
				'username' 	=> '########',
				'password' 	=> '########'
			),

			// bla bla bla ...
		);

		foreach ($emails as $email) {

			$read = imap_open($email['host'],$email['username'],$email['password']) or die('<div class="alert alert-danger alert-dismissable">Cannot connect to ##### mailbox: ' . imap_last_error().'</div>');

			$array = imap_search($read,'ALL');

			if($array) {

				$html = '';

				rsort($array);

				$html.= '<div class="panel panel-default">
							<div class="panel-heading">
								'.$email['label'].'
							</div>
							<div class="panel-body">
								<div class="panel-group" id="accordion">';

				foreach($array as $result) {

					$overview = imap_fetch_overview($read,$result,0);


					//	$conn = new mysqli($servername, $username, $password, $dbname);


					$conn = new mysqli($servername, $username, $password, $dbname);
					$message = imap_body($read,$result,0);
					$reply = imap_headerinfo($read,$result,0);
					$input_number = mysqli_real_escape_string($conn, $email['no'].$result);
					$input_subject = mysqli_real_escape_string($conn, substr(strip_tags($overview[0]->subject),0,50));
					$input_from = mysqli_real_escape_string($conn, $overview[0]->from);
					$input_from_email = mysqli_real_escape_string($conn, $reply->from[0]->mailbox.'@'.$reply->from[0]->host);
					$input_email = mysqli_real_escape_string($conn, $message);
					$input_date = mysqli_real_escape_string($conn, $overview[0]->date);


// Check email exsistance
					if ($conn->connect_error) {
						die("Connection failed: " . $conn->connect_error);
					}

					$sql = "SELECT * FROM `mail` WHERE `email_number` = '$input_number'";
					$result = $conn->query($sql);

					if ($result->num_rows > 0) {


							//echo "Email There<br>" . $input_number . "<br>";

					} else {
							$emailsCount++;

	//ADDING EMAILS TO DB

							$conn = new mysqli($servername, $username, $password, $dbname);


							if ($conn->connect_error) {
								die("Connection failed: " . $conn->connect_error);
							}


								$sql = "INSERT INTO `mail` (`id`, `email_number`, `email_subject`, `email_message`, `email_from`, `email_from_email`, `email_date`, `email_read_status`) VALUES (NULL, '$input_number', '$input_subject', '$input_email', '$input_from', '$input_from_email', '$input_date', 'Unread');";


								echo $input_subject . "<br>";

							if ($conn->query($sql) === TRUE) {
							//	echo "New record created successfully<br>";

							} else {
								//echo "Error: " . $sql . "<br>" . $conn->error;
							}

							$conn->close();

	//ADDING EMAILS TO DB END


					}
					$conn->close();


// Check email exsistance END


				/*	$html.= '	<div class="panel panel-default">
									<div style="color: red;" class="panel-heading">
										<h4 class="panel-title">
											<a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#'.$email['no'].$result.'">
												<span class="subject">'.substr(strip_tags($overview[0]->subject),0,50).'.. </span>
												<span class="from">'.$overview[0]->from.'</span>
												<span class="date">on '.$overview[0]->date.'</span>
											</a>
										</h4>
									</div>
									<div id="'.$email['no'].$result.'" class="panel-collapse collapse">
										<div class="panel-body">
											<pre>'.$message.'<hr>From: '.$reply->from[0]->mailbox.'@'.$reply->from[0]->host.'</pre>
										</div>
									</div>
								</div>';	 */

				}

				$html.= '</div>
					</div>
				</div>';

				echo $html;

			}

			imap_close($read);
			echo '<script>window.location.href="../mail.php?emailUpdate=' . $emailsCount . '";</script>';
			//echo "<center>" . $emailsCount . " New emails</center>";
			//echo $emailsCount;
		}

		?>

		<!-- Javascript -->
		<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>

	</body>
</html>