<?php
$start = $_GET['start'];
$token = $_GET['tok'];
require_once 'query.php';
$q = new Query();
$sql = "select distinct USERID from session where ACCESS_TOKEN={$token}";
$val = $q->getallentires($sql);
//var_dump($val);
//$v=$val['USERID'];
foreach ($val as $value) {
# code...
$v = $value['USERID'];
//echo $v;
}
error_reporting(E_ALL);
ini_set("display_errors", "1");
require_once 'Http2.php';
$r = new HttpRequest("post", "http://52.76.14.6:8080/BaatnaServer/rest/wish/get?start={$start}&count=15&type=1&another_user=6", array("access_token" => $token));
if ($r->getError()) {
echo "sorry, an error occured";
} else {
// parse json
//var_dump($r->getResponse());
$js = json_decode($r->getResponse());
$obj = $js->{"response"};
$obj2 = $obj->wishes;
echo json_encode($obj2);
}
<?php
require_once 'query.php';
$q2 = new Query();
$id = $_GET['WISHID'];
$sql2 = "SELECT * from USERWISH where WISHID={$id}";
$val2 = $q2->getallentires($sql2);
foreach ($val2 as $value2) {
$sql3 = "SELECT USER.USERID ,USER.FACEBOOKDATA, USER.FACEBOOKID , USER.PhoneNumber , USER.EMAIL from USER where USER.USERID=" . $value2['USER_TWO_ID'];
$val3 = $q2->getallentires($sql3);
$ans = array();
foreach ($val3 as $value) {
array_push($value, $value2['WISH_STATUS']);
array_push($value, $value2['WISHID']);
array_push($ans, $value);
}
}
echo json_encode($ans);
<th class=" cell" width="50">Return delivery addr</th>
<th class=" cell" width="50">Return Logistic Id</th>
<th class=" cell" width="50">Returned Date</th>
<th class=" cell" width="50">Amount Collected</th>
</tr>
</thead>
<tbody id="t1">
<?php
require_once 'query.php';
$WISHID = $_GET['wishid'];
$USERID = $_GET['userid'];
$q = new Query();
$sql = "SELECT USER.* , WISH.*\nFROM WISH\nINNER JOIN USER\nON WISH.USERID=USER.USERID\nwhere WISH.WISHID={$WISHID}";
$val = $q->getallentires($sql);
foreach ($val as $value) {
?>
<tr class="row">
<td class="cell"><?php
echo $WISHID;
?>
</a> </td>
<td class="cell"><?php
echo $value['TITLE'];
?>
</td>
<td class="cell comment more"><?php
echo $value['DESCRIPTION'];
?>
</td>
$q = new Query();
if ($status == "DELETED") {
$status = 0;
} elseif ($status == "ACTIVE") {
$status = 1;
} elseif ($status == "ACCEPTED") {
$status = 2;
} elseif ($status == "OFFERED") {
$status = 3;
} elseif ($status == "RECEIVED") {
$status = 4;
} elseif ($status == "FULFILLED") {
$status = 5;
}
$sql = "SELECT USER.USERID , USER.USER_NAME ,USER.FACEBOOKDATA, USER.PhoneNumber ,USER.FACEBOOKDATA, USER.EMAIL , USER.FACEBOOKID , WISH.STATUS,WISH.Required_For, WISH.WISHID , WISH.TITLE , WISH.DESCRIPTION , WISH.TIME_OF_POST \r\nFROM WISH\r\nINNER JOIN USER\r\nON WISH.USERID=USER.USERID \r\nwhere WISH.STATUS=" . $status;
$values = $q->getallentires($sql);
$ans = array();
foreach ($values as $value) {
$temp = array();
$obj = json_decode($value['FACEBOOKDATA']);
$data = $obj->name;
// Get timestamp from somewhere and assume it's $timestamp
$timestamp = (int) ($value['TIME_OF_POST'] / 1000);
// MySQL takes year-month-day hour:minute:second format
$mysql_datetime = date('Y-m-d H:i:s', $timestamp);
//echo $data;
//echo $mysql_datetime;
array_push($temp, $value['WISHID']);
array_push($temp, $value['TITLE']);
array_push($temp, $value['DESCRIPTION']);
array_push($temp, $value['Required_For']);
} elseif ($value['STATUS'] == 5) {
echo "FULFILLED";
}
?>
</td>
<td class="rem cell">
<input type="submit" qual="r" value="remove"></input>
</td>
<td class="cell"> <?php
$q3 = new Query();
$sql3 = "SELECT LOGISTICID from LOGISTIC where USERID_ONE={$id} ";
$val3 = $q3->getallentires($sql3);
echo $value['logisticid'];
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<!-- for remove button -->
<script>
jQuery(function($){
<thead>
<tr class=" row header blue">
<th width="150" class="cell">MESSAGES</th>
<th width="150" class="cell">TIMESTAMP</th>
<th width="150" class="cell">FROM</th>
<th width="150" class="cell">TO</th>
</tr>
</thead>
<tbody>
<?php
require_once "query.php";
$WISHID = $_GET['wishid'];
$USERID = $_GET['userid'];
$q = new Query();
$sql = "SELECT USER_TWO_ID from USERWISH where USERWISH.WISHID=" . $WISHID;
$val = $q->getallentires($sql);
//Constant User's username
$sql = "select FACEBOOKDATA from USER where USERID={$USERID}";
$val2 = $q->getallentires($sql);
foreach ($val2 as $name) {
// $USERNAME=$name['USER_NAME'];
$obj = json_decode($name['FACEBOOKDATA']);
$USERNAME = $obj->name;
}
//End
foreach ($val as $value) {
$u1 = $USERID;
$u2 = $value['USER_TWO_ID'];
//Constant User_TWO_id's username
$sql = "select FACEBOOKDATA,USER_NAME from USER where USERID={$u2}";
$val3 = $q->getallentires($sql);
