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