PHP Webservice and API

on

Webservice for Select data.

  • I am assuming you have connection file for connect mysql.
<?php
include('conn.php');
// API for list data
$id = isset($_GET['id']) ? mysql_real_escape_string($_GET['id']) :  "";
if(!empty($company_id) && isset($company_id)){
    $qur = mysql_query("SELECT * FROM `tablename` WHERE `id`='$id' ");
    if(mysql_num_rows($qur) > 0){
    $result =array();
    while($r = mysql_fetch_array($qur)){
        $result[] = array("id" => $r['id'], "id" => $r['id'], 'name' => $r['name'],"status"=>$r['status']); 
    }
    $json = array("status" => 1, "success" => $result);
    }
    else{
    $json = array("status" => 0, "msg" => "Invalid data");
    }
}else{
    $json = array("status" => 0, "msg" => "data not define");
}

/* Output header */
header('Content-type: application/json');
echo json_encode($json);
?>
________________________________________________________

Webservice for Insert data.

<?php
error_reporting(0);
if($_SERVER['REQUEST_METHOD']=='POST'){
include('conn.php');
// API for submit form
date_default_timezone_set('Asia/Kolkata');
$company_id = $_POST['company_id'];
$user_id=$_POST['userid'];
$bank_id=$_POST['bank_id'];
$name=$_POST["name"];
$contact=$_POST["contact"];
$address = $_POST['address'];
$description = $_POST['description'];
$add_datetime = date("Y-m-d H:i:s");
$whome_meet = $_POST['whome_meet'];
$status = $_POST['status'];
$submitted_date = date("Y-m-d H:i:s");
$form_type = '0';
if(!empty($company_id) && isset($company_id) && !empty($user_id) && isset($user_id)){
    // submit form data
    $sqlForm = "INSERT INTO `formlist`(`company_id`, `user_id`, `bank_id`, `name`, `contact`, `address`, `description`, `add_datetime`, `whome_meet`, `status`, `submitted_date`, `form_type`) VALUES ('".$company_id."','".$user_id."','".$bank_id."','".$name."','".$contact."','".$address."','".$description."','".$add_datetime."','".$whome_meet."','".$status."','".$submitted_date."','".$form_type."')";
if(mysql_query($sqlForm))
{
$resultForm[] = array("company_id" => $company_id, "userid" => $user_id, "bank_id" => $bank_id, "name" =>$name, "contact" =>$contact, "address" =>$address, "description" =>$description, "add_datetime" =>$add_datetime, "whome_meet" => $whome_meet, "status"=>$status, "submitted_date" => $submitted_date, "form_type"=>$form_type);
$json = array("status" => 1, "success" => $resultForm);
$lastID =mysql_insert_id();
}
// insert formdata with photo

if(isset($_FILES['filename'])){
foreach($_FILES['filename']['tmp_name'] as $key => $tmp_name)
{
    $file_name = $_FILES['filename']['name'][$key];
    $file_size =$_FILES['filename']['size'][$key];
    $file_tmp =$_FILES['filename']['tmp_name'][$key];
    $file_type=$_FILES['filename']['type'][$key];  
    move_uploaded_file($file_tmp,"/home/thetracking360/public_html/uploadedimages/".$file_name);
    $sql = "INSERT INTO `formlist_photo`(`formlist_id`, `photo`,`created_date`) VALUES ('".$lastID."','".$file_name."','".$submitted_date."')";
if(mysql_query($sql))
{
$result[] = array("formlist_id" => $id, "photo" => $file_name, 'created_date' => $submitted_date);
$json = array("status" => 1, "success" => $result);
}
}
}
}
else{
    $json = array("status" => 0, "msg" => "Form data not define");
}
}
echo json_encode($json);
?>
_____________________________________________________________

Webservice for Update data.

<?php
error_reporting(0);
include('conn.php');
// API for update user appoinment status
$id = isset($_GET['id']) ? mysql_real_escape_string($_GET['id']) :  "";
$user_id = isset($_GET['userid']) ? mysql_real_escape_string($_GET['userid']) :  "";
$status = isset($_GET['status']) ? mysql_real_escape_string($_GET['status']) :  "";

if(isset($user_id) && !empty($user_id) && isset($status) && !empty($status) && isset($id) && !empty($id)){
$success=0;
date_default_timezone_set('Asia/Kolkata');
$sql = "UPDATE `formlist` SET `status`='".$status."' WHERE `user_id`='".$user_id."' AND `id`='".$id."'";
$result =array();
if(mysql_query($sql))
{
$result[] = array('id' => $id, 'userid' => $user_id, 'status' => $status);
$json = array("status" => 1, "success" => $result);
}
else
{
    $json = array("status" => 0, "msg" => "status not define");
}
}
else{
$json = array("status" => 0, "msg" => "missing User id or status");
}
echo json_encode($json);
?>

Comments

Post a Comment