$conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "SELECT *\n FROM control\n WHERE mac_address = '{$mac_address}'"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $control_type = $result_array[control_type]; $auto_control_command = $result_array[auto_control_command]; $manual_control_command = $result_array[manual_control_command]; $suspend_pwm1 = $result_array[suspend_pwm1]; $suspend_pwm2 = $result_array[suspend_pwm2]; $suspend_pwm3 = $result_array[suspend_pwm3]; $suspend_pwm4 = $result_array[suspend_pwm4]; $update_time = $result_array[update_time]; $response['control_type'] = $control_type; $response['auto_control_command'] = $auto_control_command; $response['manual_control_command'] = $manual_control_command; $response['suspend_pwm1'] = $suspend_pwm1; $response['suspend_pwm2'] = $suspend_pwm2; $response['suspend_pwm3'] = $suspend_pwm3; $response['suspend_pwm4'] = $suspend_pwm4; $response['update_time'] = $update_time; deliver_response(200, "The control commands have been got", $response); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
function add_new_user() { $conn = new mysqli($GLOBALS['db'], $GLOBALS['login'], $GLOBALS['pass'], $GLOBALS['dbname']); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $query = "INSERT INTO GS_USER (NICKNAME, PASSWORD, EMAIL) VALUES (\n '" . $_POST['name'] . "',\n '" . sha1($_POST['password']) . "',\n '" . $_POST['email'] . "'\n )"; if (mysqli_query($conn, $query)) { deliver_response(201, "Success", 2); } else { deliver_response(400, "Query error", 232); } }
function authenticate() { if (empty($_POST['email'])) { return false; } if (empty($_POST['password'])) { return false; } $conn = new mysqli($GLOBALS['db'], $GLOBALS['login'], $GLOBALS['pass'], $GLOBALS['dbname']); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $query = "SELECT NICKNAME FROM GS_USER WHERE EMAIL='" . $_POST['email'] . "' AND PASSWORD='******'password']) . "'"; $result = $conn->query($query); if ($result->num_rows == 1) { $row = mysqli_fetch_assoc($result); deliver_response(201, $query, $row['NICKNAME']); return true; } else { return false; } }
if ($sqlQ1 and $sqlQ2) { $response['success'] = true; $response['status'] = 200; $response['data'] = 'deleted'; } else { $response['success'] = false; $response['status'] = 404; } } else { $response['status'] = 404; $response['success'] = false; } } } else { $response['status'] = 404; $response['success'] = false; } } } } } } } } } } } deliver_response('json', $response); ?>
die; } } } } else { $res["status"] = false; $res["message"] = "No File Present"; deliver_response(200, 'Okay', $res); die; } $sql = "DELETE FROM frontcarouselgallery where ID = {$delid}"; $result = mysqli_query($conn, $sql); $res = array(); if ($conn->query($sql) === TRUE) { $res["status"] = true; $res["message"] = "okay"; } else { $res["status"] = false; $res["message"] = $conn->error; } deliver_response(200, 'Okay', $res); function deliver_response($status, $status_message, $data) { header("Content-Type:application/json"); header("HTTP/1.1 " . $status . " " . $status_message); $response["status"] = $status; $response["status_message"] = $status_message; $response["data"] = $data; $json_response = json_encode($data); echo $json_response; }
$response['data'] = setArciereStampato($tessera); } } // Method q: Restituisce informazioni sulla foto; if (strcasecmp($apiMethod, 'fotoinfo') == 0) { if (isset($_GET['file'])) { $file = $_GET['file']; } else { $file = null; } if (isset($_GET['tipo'])) { $tipo = $_GET['tipo']; } else { $tipo = null; } if ($file == null || $tipo == null) { $response['code'] = 0; $response['status'] = $api_response_code[$response['code']]['HTTP Response']; $response['data'] = "'Parametri obbligatori: file, il nome senza il percorso. Tipo: nonabbinate, abbinate"; } else { $response['code'] = 1; $response['status'] = $api_response_code[$response['code']]['HTTP Response']; $response['data'] = getFotoInfo($file, $tipo); } } // --- Step 4: Deliver Response // Return Response to browser deliver_response($apiFormat, $response); //echo json_encode($response); ?>
<?php include '../../session.php'; include '../response.php'; include '../db.php'; $conn = new mysqli($GLOBALS['db'], $GLOBALS['login'], $GLOBALS['pass'], $GLOBALS['dbname']); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $query = "SELECT * FROM GS_MATCH WHERE ID=" . $_GET['id']; $result = $conn->query($query); if ($result->num_rows == 0) { deliver_response(400, "No Match Found", NULL); } else { $query = "SELECT * FROM GS_HISTORY WHERE MATCH_ID =" . $_GET['id'] . " ORDER BY TURN"; $result = $conn->query($query); $array = array(); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { array_push($array, array('turn' => $row['TURN'], 'user' => $row['USER_ID'], 'date' => $row['DATESTAMP'], 'description' => $row['DESCRIPTION'])); } } deliver_response(200, 'Games', $array); }
{ echo $n; echo $find; echo $row['runtime']; return $row['runtime']; } else { echo " Error:".mysql_error(); } */ function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; } if (!empty($_GET['name'])) { $name = $_GET['name']; $price = get_price($name); if (empty($price)) { deliver_response(200, "Movie NOT found!", NULL); } else { deliver_response(200, "Movie found!", $price); } } else { deliver_response(404, "Invalid Request!", NULL); }
header("Content-Type:application/json"); // start the session session_start(); // close the session session_write_close(); $conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "SELECT *\n FROM camera\n WHERE id = '1'"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $image = $result_array[image]; $video = $result_array[video]; $latitude = $result_array[latitude]; $longitude = $result_array[longitude]; $update_time = $result_array[update_time]; $response['image'] = $image; $response['video'] = $video; $response['latitude'] = $latitude; $response['longitude'] = $longitude; $response['update_time'] = $update_time; deliver_response(200, "The camera commands have been got", $response); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
header("Content-Type:application/json"); // start the session session_start(); $status = $_POST['status']; $is_pwm_change = $_POST['is_pwm_change']; $conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "UPDATE `general`\n SET status = '{$status}', is_pwm_change = '{$is_pwm_change}', update_time = now()\n WHERE id = '1'"; $result = mysql_query($query); // close the session session_write_close(); $query = "SELECT id, status, is_pwm_change, update_time\n FROM `general`\n WHERE id=1"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $status = $result_array[status]; $is_pwm_change = $result_array[is_pwm_change]; $update_time = $result_array[update_time]; $response['status'] = $status; $response['is_pwm_change'] = $is_pwm_change; $response['update_time'] = $update_time; deliver_response(200, "The general info has been updated", $response); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
$result = mysql_query($query); $result_array = mysql_fetch_array($result); $last_time_image = $result_array[image]; $last_time_video = $result_array[video]; if ($image == NULL) { $image = $last_time_image; } if ($video == NULL) { $video = $last_time_video; } $query = "UPDATE camera\n SET image = '{$image}', video = '{$video}', update_time = now()\n WHERE id = '1'"; $result = mysql_query($query); $query = "SELECT *\n FROM camera\n WHERE id = '1'"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $image = $result_array[image]; $video = $result_array[video]; $update_time = $result_array[update_time]; $response['image'] = $image; $response['video'] = $video; $response['update_time'] = $update_time; deliver_response(200, "The camera commands have been updated", $response); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
$result = mysqli_query($con, $sql); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_array($result)) { $msg[] = array("title" => $row['title'], "price" => $row['price'], "year" => $row['year'], "category" => $row['category']); } $json = $msg; deliver_response(200, "Book Found", $json); } else { deliver_response(404, "Invalid Request", NULL); } mysqli_close($con); } else { $sql = "SELECT title from book"; $result = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($result)) { $msg[] = $row['title']; } $json = $msg; deliver_response(200, "List of Books", $json); mysqli_close($con); } @mysql_close($conn); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
$selectVisitorQuery1 = "select * from visitor where mobileNo='{$mobileNo}'"; $selectVisitor1 = mysql_query($selectVisitorQuery1, $conn) or die(mysql_error()); $selectVisitorRows1 = mysql_num_rows($selectVisitor1); if ($selectVisitorRows1 > 0) { deliver_response(203, "An Account With This Mobile Number Already Exists", "otp", $jsonresponse); } else { //Check if Email Id exists $selectVisitorQuery2 = "select * from visitor where emailId='{$email}'"; $selectVisitor2 = mysql_query($selectVisitorQuery2, $conn) or die(mysql_error()); $selectVisitorRows2 = mysql_num_rows($selectVisitor2); if ($selectVisitorRows2 > 0) { deliver_response(203, "An Account With This Email Id Already Exists", "otp", $jsonresponse); } else { //Create OTP /*$digits_needed=4; $random_number=''; // set up a blank string $count=0; while ($count < $digits_needed ) { $random_digit = mt_rand(0, 3); $random_number .= $random_digit; $count++; }*/ //$jsonresponse=$random_number; $jsonresponse = "1234"; //Hardcoded for Testing, Remove Later json_encode($jsonresponse); deliver_response(200, "OTP Created", "otp", $jsonresponse); } } }
<?php require_once "connection.php"; $sql = "SELECT * FROM frontcarouselgallery order by ID desc"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { // output data of each row $retarray = array(); $objects = array(); while ($row = mysqli_fetch_assoc($result)) { $retarray["id"] = $row["ID"]; $retarray["path"] = $row["Image"]; $retarray["title"] = $row["Title"]; $retarray["caption"] = $row["Caption"]; array_push($objects, $retarray); } } deliver_response(200, 'Okay', $objects); function deliver_response($status, $status_message, $data) { header("Content-Type:application/json"); header("HTTP/1.1 " . $status . " " . $status_message); $response["status"] = $status; $response["status_message"] = $status_message; $response["data"] = $data; $json_response = json_encode($data); echo $json_response; }
// Turn the error reporting on while debugging error_reporting(0); // Instance of the Connection class is used to perform the database related operations. For any database related error check $root/models/connection.php $db = new Connection(); if (!$db || !$db->checkConnection()) { // Database connection error deliver_response(500, "Internal Server Error", null); } else { // Validate the URL before passing it to the database if (filter_var($_GET['url'], FILTER_VALIDATE_URL)) { // Get the token for the particular URL and call deliver_response() with the status code, the status message and the data accordingly $result = $db->getToken($_GET['url']); if (!$result) { deliver_response(404, "Not Found", null); } else { deliver_response(201, "Created", $result); } } else { deliver_response(400, "Bad Request", null); } } // This function is used to prepare the response and deliver it in the JSON format function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['token'] = $data; $json_response = json_encode($response); echo $json_response; }
// header("Content-Type: text/plain"); // error_reporting(E_ALL); // ini_set('display_errors', 1); if (isset($_GET['sparql'])) { $format = "nt"; //$_GET['format']; $sparql = $_GET['sparql']; $result = get_pyresponse($format, $sparql); if (empty($result)) { deliver_response(200, "OK", NULL); } else { deliver_response(200, "NOT OK", $result); } } else { deliver_response(200, "invalid request", NULL); } function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; //echo json_encode($response); } function get_pyresponse($format, $sparql) { $data["format"] = $format; $data["sparql"] = $sparql; $result = system('python3 ../sparqlservice.py ' . escapeshellarg(json_encode($data))); return $result;
<?php require_once "../classes/bank_operations.php"; require_once "../classes/api_operations.php"; $response = array(); $p = $_POST; if (isset($_POST) && !empty($_POST)) { if (validate_request($_POST, $response)) { $response['status'] = 200; $banklink = create_banklink($_POST['api_key'], $_POST['amount'], htmlspecialchars($_POST['description'])); $response['banklink'] = "http://localhost/banklink/{$banklink}"; } else { $response['status'] = 400; http_response_code(400); } deliver_response($response); } else { require_once 'instructions.php'; }
<?php header("Content-Type:application/json"); // start the session session_start(); // I can read/write to session $_SESSION['latestRequestTime'] = time(); // close the session session_write_close(); $conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "SELECT id, led_status, led_on_ms, led_off_ms\n FROM led\n WHERE id = '1'"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $led_status = $result_array[led_status]; $led_on_ms = $result_array[led_on_ms]; $led_off_ms = $result_array[led_off_ms]; $response['led_status'] = $led_status; $response['led_on_ms'] = $led_on_ms; $response['led_off_ms'] = $led_off_ms; deliver_response(200, "The ip address has been got", $response); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
header('Access-Control-Allow-Credentials: true'); header('Access-Control-Allow-Headers: Content-Type'); include 'jsonFormat.php'; include 'jsonDeliver.php'; include 'config.php'; //$josn = '{"signUp":[{"name":"abc","password":"******","mobileNo":789456124,"emailId":"*****@*****.**"}]}'; //var data = {"profile":[{"visitorId":visitorId}]}; $json = file_get_contents("php://input"); $data = json_decode($json, true); $jsonresponse = ""; $visitorid1 = $data['profile'][0]['visitorId']; //Cheking visitor entry in Visitor table $selectVisitorQuery = "select v.name,v.mobileNo,v.emailId,vp.image from visitor v,visitorProfile vp where v.id='{$visitorid1}' and vp.createdBy=v.id"; //$selectVisitorQuery="select vp.name,vp.gender,vp.dob,vp.city,vp.photoLink,v.mobileNumber,v.email from visitorprofile vp,visitor v where vp.createdBy='$visitorid1' and vp.createdBy=v.id"; $selectVisitor = mysql_query($selectVisitorQuery, $conn) or die(mysql_error()); $visitorResultRows = mysql_num_rows($selectVisitor); if ($visitorResultRows > 0) { while ($selectVisitorResult = mysql_fetch_assoc($selectVisitor)) { /* $jsonresponse['name']=$selectVisitorResult['name']; $jsonresponse['gender']=$selectVisitorResult['gender']; $jsonresponse['dob']=$selectVisitorResult['dob']; $jsonresponse['city']=$selectVisitorResult['city']; $jsonresponse['photoLink']=$selectVisitorResult['photoLink']; json_encode($jsonresponse); */ $jsonresponse[] = $selectVisitorResult; } json_encode($jsonresponse); deliver_response(200, "Record found", "visitor", $jsonresponse); } else { deliver_response(203, "No data found", "visitor", $jsonresponse); }
$led_on_ms = $_GET['led_on_ms']; $led_off_ms = $_GET['led_off_ms']; $conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "UPDATE led\n SET led_status = '{$led_status}', led_on_ms = '{$led_on_ms}', led_off_ms = '{$led_off_ms}'\n WHERE id = '1'"; $result = mysql_query($query); $query = "SELECT id, led_status, led_on_ms, led_off_ms\n FROM led\n WHERE id = '1'"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $led_status = $result_array[led_status]; $led_on_ms = $result_array[led_on_ms]; $led_off_ms = $result_array[led_off_ms]; $response['led_status'] = $led_status; $response['led_on_ms'] = $led_on_ms; $response['led_off_ms'] = $led_off_ms; deliver_response(200, "The LED status has been changed on server", $response); //$json_response=json_encode($response); //echo $json_response; //if(!empty($_GET['led_status'])){ //$led_status = $_GET['led_status']; //$led_status = process($led_status); //$led_on_ms = $_GET['led_on_ms']; //deliver_response(200,"Thank you for your request","Welcome to the GPS part, the led_status is: $led_status, the led_on_ms is: $led_on_ms"); //}else{ //deliver_response(400,"Bad Request",NULL); //} function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message;
header("Content-Type:application/json"); // start the session session_start(); $face_direction = $_POST['face_direction']; $latitude = $_POST['latitude']; $longitude = $_POST['longitude']; // close the session session_write_close(); $conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "INSERT INTO `gps_ubidots`\n (face_direction, latitude, longitude, update_time)\n VALUES ('{$face_direction}', '{$latitude}', '{$longitude}', now())"; $result = mysql_query($query); $query = "UPDATE `camera`\n SET latitude = '{$latitude}', longitude = '{$longitude}', update_time = now()\n WHERE id = '1'"; $result = mysql_query($query); deliver_response(200, "The gps_ubidots commands have been updated", NULL); post_data_to_ubidots($latitude, $longitude); function post_data_to_ubidots($latitude, $longitude) { $data['value'] = 1; $context['lat'] = $latitude; $context['lng'] = $longitude; $data['context'] = $context; $json_data = json_encode($data); $url = "http://things.ubidots.com/api/v1.6/variables/5663284176254275509fc2ad/values"; $headers = array("Content-Type: application/json", "Accept: application/json; indent=4", "X-Auth-Token: 55QTnmUYv4kLQERtSqD3XAa27n8qnX"); $ch = curl_init(); $timeout = 30; curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
$selectVisitorRows1 = mysql_num_rows($selectVisitor2); if ($selectVisitorRows1 > 0) { //id1 has the current id from auto incremented column $id1 = mysql_insert_id(); } //inserting data into visitorProfile $insertVisitorProfileQuery = "insert into visitorProfile (name,createdOn,modifiedOn,createdBy,modifiedBy) values('{$name}','{$createdOn}','{$createdOn}','{$id1}','{$id1}')"; $insertVisitorProfile = mysql_query($insertVisitorProfileQuery, $conn) or die(mysql_error()); $selectVisitorQuery1 = "select id,name from visitor where mobileNo='{$mobileNo}'"; $selectVisitor1 = mysql_query($selectVisitorQuery1, $conn) or die(mysql_error()); $visitorResultRows = mysql_num_rows($selectVisitor1); while ($selectVisitorResult = mysql_fetch_assoc($selectVisitor1)) { $jsonresponse[] = $selectVisitorResult; } json_encode($jsonresponse); deliver_response(200, "visitor created", "visitor", $jsonresponse); //Create OTP /*$digits_needed=4; $random_number=''; // set up a blank string $count=0; while ($count < $digits_needed ) { $random_digit = mt_rand(0, 3); $random_number .= $random_digit; $count++; }*/ //select visitorId from Visitor table /*$selectVisitorQuery3="select id from visitor where mobileNumber='$mobileNo' and email='$email'"; $selectVisitor3=mysql_query($selectVisitorQuery3,$conn)or die(mysql_error()); $selectVisitorResult=mysql_fetch_assoc($selectVisitor3); $jsonresponse=array("visitorId"=>$selectVisitorResult['id'],"OTP"=>$random_number);
<?php header("Content-Type:application/json"); include "functions.php"; //process client request if (!empty($_GET['name'])) { # //throw invalid request code... $name = $_GET['name']; $price = get_price($name); if (empty($price)) { # book not found deliver_response(200, "Book not found", NULL); } else { deliver_response(200, "Book found", $price); //respond book found } } else { deliver_response(400, "Invalid Request", NULL); //throw invalid request } function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
<?php include '../../session.php'; include '../response.php'; include '../db.php'; header("Content-Type:application/json"); $conn = new mysqli($db, $login, $pass, $dbname); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $query = "INSERT INTO GS_MATCH (GAME, DATESTAMP) VALUES ('warcaby',NOW())"; if (mysqli_query($conn, $query)) { deliver_response(201, "Success", mysqli_insert_id($conn)); } else { deliver_response(400, "Query error", 232); }
<?php header('Content-Type:application/json'); include 'function.php'; if (!empty($_GET['movie'])) { $movie = $_GET['movie']; $actor = getData($movie); if (empty($actor)) { deliver_response(200, 'movie not found', NULL); } else { deliver_response(200, 'movie found', $actor); } } else { deliver_response(400, 'invalid request', NULL); } function deliver_response($status, $statusText, $data) { header("HTTP/1.1 {$status} {$statusText}"); $response['status'] = $status; $response['statusText'] = $statusText; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
/** * Get the reading by time * * @param String $type * @param Date $from * @param Date $to * @return json */ function get_reading_by_time($type, $from, $to) { // get data from db $result = pg_query("SELECT readings.readings,readings.time,sensores.id,meshes.mesh_name \n FROM readings \n LEFT JOIN sensores ON sensores.id = readings.sensor_id \n LEFT JOIN nodes ON nodes.id = sensores.node_id \n LEFT JOIN meshes ON meshes.id = nodes.mesh_id \n WHERE sensores.reading_type = '{$type}' AND readings.time >= '{$from}' AND readings.time <= '{$to}'\n ORDER BY readings.time"); // check for error if ($result === FALSE) { die("Error in get_reading(): " . mysql_error()); } $data = []; while ($row = pg_fetch_assoc($result)) { // Get the deta from the row $temp["sensor_id"] = $row["id"]; $temp["mesh_name"] = $row["mesh_name"]; $temp["time"] = $row["time"]; $temp["reading"] = $row["readings"]; // populate the data array_push($data, $temp); } if (empty($data)) { deliver_response(404, "Not Found", NULL); } else { deliver_response(200, "Ok", $data); } }
<?php header("Content-Type:application/json"); include "functions.php"; if (!empty($_GET['name'])) { $name = $_GET['name']; $price = get_price($name); if (empty($price)) { deliver_response(200, "book not found", NULL); } else { deliver_response(200, "book found", $name); } } else { //throw invalid request deliver_response(400, 'Invalid request', null); } function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status}.{$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }
header('Access-Control-Allow-Credentials: true'); header('Access-Control-Allow-Headers: Content-Type'); include 'jsonFormat.php'; include 'jsonDeliver.php'; include 'config.php'; //var data = {"profile":[{"visitorId":visitorId,"pname":pname,"profilePicture":profilePicture,"pemail":pemail,"pphone":pphone,"pgender":pgender,"pbirthdate":pbirthdate,"pcity":pcity}]}; //$json = {"events":[{"eventId":eventId}]}; $json = file_get_contents("php://input"); $data = json_decode($json, true); $jsonresponse = array(); $pname = $data['profile'][0]['pname']; $visitorId = $data['profile'][0]['visitorId']; $pemail = $data['profile'][0]['pemail']; $pphone = $data['profile'][0]['pphone']; $pGender = $data['profile'][0]['pGender']; $pprofession = $data['profile'][0]['pProfession']; $pEducation = $data['profile'][0]['pEducation']; $pBirthDate = $data['profile'][0]['pBirthDate']; $image = $data['profile'][0]['profilePicture']; //echo $pbirthdate; //insert into comment table //$dob=strtotime('27-10-1987'); $dob = date('Y-m-d', strtotime($pBirthDate)); //@$createdon = date('Y-m-d h:i:s', time()); $updateVisitorProfileQuery = "update visitorProfile\nset name='{$pname}',\ngender='{$pGender}',\nimage='{$image}',\ndateOfBirth='{$dob}',\t\nprofession='{$pprofession}',\neducation='{$pEducation}'\nwhere createdBy='{$visitorId}'"; mysql_query($updateVisitorProfileQuery, $conn); $updateVisitorQuery = "update visitor\nset name='{$pname}',\nemailId='{$pemail}',\nmobileNo='{$pphone}',\nimage='{$image}'\t\nwhere id='{$visitorId}'"; mysql_query($updateVisitorQuery, $conn); $jsonresponse = $visitorId; deliver_response(200, "visitor profile updated", "visitor", $jsonresponse);
$response['code'] = 1; $response['status'] = $api_response_code[$response['code']]['HTTP Response']; $fetchMyListingPetList = new WishListDetails(); $listId = $_GET['id']; $email = $_GET['email']; $response['deleteWishListPetListResponse'] = $fetchMyListingPetList->deletingWishListPetList($listId, $email); deliver_response($_GET['format'], $response, false); } else { if (strcasecmp($_GET['method'], 'deleteWishListPetMateList') == 0) { $response['code'] = 1; $response['status'] = $api_response_code[$response['code']]['HTTP Response']; $fetchMyListingPetMateList = new WishListDetails(); $listId = $_GET['id']; $email = $_GET['email']; $response['deleteWishListPetMateListResponse'] = $fetchMyListingPetMateList->deletingWishListPetMateList($listId, $email); deliver_response($_GET['format'], $response, false); } } } } } } } } } } } } } } }
<?php header("Content-Type:application/json"); // start the session session_start(); // close the session session_write_close(); $conn = mysql_connect('localhost', 'webmaster', ''); mysql_select_db('edison', $conn); $query = "SELECT id, status, is_pwm_change, update_time\n FROM `general`\n WHERE id=1"; $result = mysql_query($query); $result_array = mysql_fetch_array($result); $status = $result_array[status]; $is_pwm_change = $result_array[is_pwm_change]; $update_time = $result_array[update_time]; $response['status'] = $status; $response['is_pwm_change'] = $is_pwm_change; $response['update_time'] = $update_time; deliver_response(200, "The general info has been got", $response); function deliver_response($status, $status_message, $data) { header("HTTP/1.1 {$status} {$status_message}"); $response['status'] = $status; $response['status_message'] = $status_message; $response['data'] = $data; $json_response = json_encode($response); echo $json_response; }