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

$username =$_POST["name"];
$email =$_POST["email"];
$phonenumber =$_POST['msisdn'];
$location =$_POST["location"];
$profile =$_POST["profile"];
$country =$_POST["country"];
$sex =$_POST["sex"];
$age =$_POST["age"];

date_default_timezone_set('africa/lagos');


$username = str_replace("'","^",$username);
$location = str_replace("'","^",$location);
$profile = str_replace("'","^",$profile);
$country = str_replace("'","^",$country);


//check if phonenumber already exists
$query = "Select msisdn from penpalsubscriber where msisdn ='$phonenumber'";
$response =getQuery1($query);

if ($response == "#"){
//	echo $phonenumber;

if (($phonenumber !="") && ($email != "") && ($username != "")){
$query ="insert into penpalsubscriber (nickname,msisdn,email,country,location,age,sex,profile) VALUES
('$username','$phonenumber','$email','$country','$location','$age','$sex','$profile')";
//echo "Insert";
}}
else{
	if (($phonenumber !="") && ($email != "") && ($username != "")){
//	echo "update";
	$query ="update penpalsubscriber set nickname='$username',email='$email',country='$country',location='$location',age='$age',sex='$sex',profile='$profile' where msisdn ='$phonenumber'";
}
}

echo "success";

$queryresponse = updateQuery($query);



?>