Untitled

<html>
 <head>
  <title>SWP Gmail App - number of unread e-mails</title>
 </head>
 <body>
	<?php
		$file = 'jsons/readAllMessesages.xml';
		fopen('jsons/readAllMessesages.xml', 'w');
		$current = file_get_contents($file);

		$servername = "www.db4free.net:3307";
		$username = "kontotestwe1";
		$password = "dceda05f6cebc0f79097caf777ce7daf";
		$dbname = "gmailvoiceclient";

		// Create connection
		$conn = new mysqli($servername, $username, $password, $dbname);
		// Check connection
		if ($conn->connect_error) {
			die("Connection failed: " . $conn->connect_error);
		}

		//zapytanie omija maile voxeo, ponieważ zawierają niedopuzczalne ciągi znaków
		$sql = "select * from Messesages where senderEmail not like '%voxeo.com' order by `DATE` desc";
		$result = $conn->query($sql);
		$delimiter = 0;

		if ($result->num_rows > 0) {
			echo '[';
			$current .='<?xml version="1.0" ?><xml><parent><JSON>[';
			while($row = $result->fetch_assoc()) {
				if($delimiter < 1){
					$delimiter++;
				} else {
					echo ',';
					$current .=',';
				}
				echo json_encode($row);
				$current .=json_encode($row);
				// echo '{'$row['historyId'].$row['senderName'].$row['subject'].$row['text'];
			}
						$current .=']</JSON></parent></xml>';
			echo ']';

		} else {
			echo "0 results";
		}
		$conn->close();

		file_put_contents($file, $current);
	?>
 </body>
</html>