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;
}
<?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;
}