<?php
include "general.php";
include "connect.php";


// Read the JSON file 
$json = file_get_contents("users2.json");


$json_data = json_decode($json, true);

foreach ($json_data as $key1 => $value1) {

  foreach($value1 as $elem)  {


   

   $age= $elem['age'];
   $reg_date = date('Y/m/d', strtotime("-$age years"));
  print_r( substr($reg_date,0,10));
   $name=$elem['userName'];
   $birthDate=$age;
   $country= $elem['country'];
   $dateCreated= $elem['registered_at'];
   $email= $elem['email'];
   $emailverified= "false";
   $gender=$elem['gender'];
   if($gender=="M"){
    $genderSearch="F";
   }{
    $genderSearch="M";
   }
   
   $lastSeen= $dateCreated;
   $location= $elem['location'];
   $phonenumber= $elem['phone'];
   $photoUpload= "false";
   $photo_url1= $elem['photo'];
   $profileMessage= $elem['profileMessage'];
   $userToken ="web";
   $userType="1";
   $domain= "penpaleurope.com";

   date_default_timezone_set('africa/lagos');



	$query ="insert into penpal (name,phonenumber,email,emailcode,country,location,gender,birthDate,photo_url1,profileMessage,emailverified,lastSeen,photoUpload,userToken,userType,dateCreated,migrated,domain) VALUES
	('$name','$phonenumber','$email','$emailcode','$country','$location','$gender','$birthDate','$photo_url1','$profileMessage','$emailverified','$lastSeen','$photoUpload','$userToken','$userType','$dateCreated','1','$domain')";

	$queryresponse = updateQuery($query);
        echo $queryresponse;

   
   //echo $elem;
}
}
 //$last_error = json_last_error_msg();
   //if(strtolower($last_error) != "No Error") {
 //     echo "ERROR: " . $last_error; die; 
 // }

?>