$dateEnd = array();
$date = explode('-', $datenow);
if ($date[1] < 12) {
$dateEnd[0] = $date[0];
$dateEnd[1] = $date[1] + 1;
$dateEnd[2] = $date[2];
$dateending = implode("-", $dateEnd);
$result = subscriptionforTrail($datenow, $dateending);
echo $result;
} else {
if ($date[1] == 12) {
$dateEnd[0] = $date[0] + 1;
$dateEnd[1] = 1;
$dateEnd[2] = $date[2];
$dateending = implode("-", $dateEnd);
$result = subscriptionforTrail($datenow, $dateending);
echo $result;
}
}
} elseif ($action == "getImageFromGallary") {
$id = $_GET['id'];
$result = getImageFromGallary($id);
header('content-type:application/json');
echo json_encode($result);
} elseif ($action == "deleteFromGalary") {
$id = $_GET['id'];
$result = deleteFromGalary($id);
echo $result;
} elseif ($action == "getInterestID") {
$result = getInterestID();
echo $result;
function serviceProviderRegistration($data)
{
$db = db();
$sql = "INSERT INTO user_accounts(UserName,Password,UserStatus,UserType)VALUES(?,?,?,?)";
$cmd = $db->prepare($sql);
$cmd->execute(array($data['own_reg_username'], md5($data['own_reg_password']), 1, "service provider"));
$id = $db->LastInsertId();
$sql2 = "INSERT INTO service_providers(OwnerName,SPName,SPAddress,SPType,SPEmail,SPContactNo,Spmobile,SPStatus,UserID)VALUES(?,?,?,?,?,?,?,?,?)";
$cmd2 = $db->prepare($sql2);
$cmd2->execute(array($data['own_reg_first_name'], $data['own_reg_club_name'], $data['own_reg_address'], $data['own_reg_type'], $data['own_reg_email'], $data['own_reg_telephone'], $data['own_reg_phone'], 1, $id));
$db = null;
$datenow = date('Y-m-d');
$date = array();
$dateEnd = array();
$date = explode('-', $datenow);
if ($date[1] < 12) {
$dateEnd[0] = $date[0];
$dateEnd[1] = $date[1] + 1;
$dateEnd[2] = $date[2];
$dateending = implode("-", $dateEnd);
subscriptionforTrail($datenow, $dateending, $id);
} else {
if ($date[1] == 12) {
$dateEnd[0] = $date[0] + 1;
$dateEnd[1] = 1;
$dateEnd[2] = $date[2];
$dateending = implode("-", $dateEnd);
subscriptionforTrail($datenow, $dateending, $id);
}
}
return "You are successfully registered as an owner. Please login to continue";
}
