<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);


$servername = "localhost";
$username = "sp_smroz";
$dbname = "sp_smroz";
$password = "VELV6VhOx";

$array = array();

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

$getUbezpieczenia = "SELECT parent_item_id, field_213, field_218 FROM app_entity_26";

$result = $conn->query($getUbezpieczenia);


while($row = $result->fetch_assoc()) {


	// co 30 dni lub co 14 dni
	if(date('d-m-Y', time() + 2592000) == date('d-m-Y', $row["field_213"]) || date('d-m-Y', time() + 1209600) == date('d-m-Y', $row["field_213"])){

		$getUser = "SELECT * FROM app_entity_25 WHERE id = ".$row["parent_item_id"]."";
		$user = $conn->query($getUser);
		$tel = mysqli_fetch_row($user)[8];

		$array[] = array('tresc' => $row["field_218"], 'telefon' => $tel);


	}
}

	$temp_arr = array('tresc' => 'sdaas', 'telefon' => '2154151551');
	$temp_arr2 = array('tresc' => 'zxcs', 'telefon' => '212151551');
	$array2 = array($temp_arr, $temp_arr2);

	//print_r($array2);
	echo '</br>';
	echo '</br>';
	print_r($array);

	//print_r(json_encode(array($temp_arr, $temp_arr2)));
	//print_r($array);


	echo json_encode($array2, JSON_PRETTY_PRINT);


	//file_put_contents("base.json", $json);

$conn->close();