31 Jan 2017

Android API Sample Code -

Android API Sample Code -

<?php
//echo "<pre>".print_r($_SERVER); exit;
// get the HTTP method, path and body of the request
$method = $_SERVER['REQUEST_METHOD'];
$request = explode('/', trim($_SERVER['PATH_INFO'],'/'));
$input = json_decode(file_get_contents('php://input'),true);

if(isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD']=="POST")
{

    $varReqStr = $input;
    $keywords = preg_split("/[\[\]]/", $input["name"]);
    $varReqArr= explode(',', $keywords[1]);
}

$link = mysqli_connect('localhost', 'root', '', 'amlkocpu_maindb');
mysqli_set_charset($link,'utf8');

if($link)
{
    $table = preg_replace('/[^a-z0-9_]+/i','',array_shift($request));
    $key = array_shift($request)+0;
    $columns = preg_replace('/[^a-z0-9_]+/i','',array_keys($input));
    $values = array_map(function ($value) use ($link) {
        if ($value===null) return null;
        return mysqli_real_escape_string($link,(string)$value);
    },array_values($input));

$set = '';
for ($i=0;$i<count($columns);$i++) {
  $set.=($i>0?',':'').'`'.$columns[$i].'`=';
  $set.=($values[$i]===null?'NULL':'"'.$values[$i].'"');
}

// create SQL based on HTTP method
switch ($method) {
  case 'GET':
      $sql = "select * from `$table`".($key?" WHERE id=$key":''); break;
  case 'PUT':
      $sql = "update `$table` set $set where id=$key"; break;
  case 'POST':

      //print_r($link);
      foreach($varReqArr as $indVal){
         //$indValPart=array();

         $indValPart = explode('-', $indVal);
         //$columns = preg_replace("'",'',array_keys($input));

         //print_r($indValPart); exit;
         echo $sql2 = "INSERT INTO `tbl_contact` ( `name`, `mobile`) VALUES    
              ('".str_replace("'",'',$indValPart[1])."', '".str_replace("'",'',$indValPart[0])."')";
              //exit;
         $resultSaved= mysqli_query($link, $sql2);
      }
       break;

  case 'DELETE':
    $sql = "delete `$table` where id=$key"; break;
}

 if($resultSaved){
   echo '{"code":"success","msg":"record inserted successfully"}';
 }else if($result = mysqli_query($link, $sql)){
    echo '{"code":"success","msg":"Task completed"}';
}else{
     echo '{"code":"303","msg":"error found"}';
}
exit;
/*
if ($method == 'GET') {
  if (!$key) echo '[';
  for ($i=0;$i<mysqli_num_rows($result);$i++) {
    echo ($i>0?',':'').json_encode(mysqli_fetch_object($result));
  }
  if (!$key) echo ']';
} elseif ($method == 'POST') {
  echo mysqli_insert_id($link);
} else {
  echo mysqli_affected_rows($link);
}*/

// close mysql connection
    mysqli_close($link);
}else{
    echo "error"; exit;
}

25 Jan 2017

Convertkit subscription through API Subscription


Convertkit subscription through API -

function handle_custom_registration_complete_event($member_data,$custom_fields)
{
//print_r($member_data);
$param= array();
$param['api_key'] = 'U7MAIGT9J4LF51bm_kP3Og';
$param['name'] = $user = $member_data['user_name'];
  $param['email'] = $email = $member_data['email'];
$url = 'https://api.convertkit.com/v3/forms/32338/subscribe';

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($param));
$results = curl_exec($ch);
curl_close($ch);
//print_r(json_decode($results));
if(isset($results->subscription->id) && $results->subscription->id>0){

}else{
}
}