[converting json to php]

please I have this after i sent an sms. 

=== HTTP Request ===
0 : HTTP/1.1 401 Unauthorized
Keep-Alive : true
Content-Length : 14
Content-Type : application/json; charset=utf-8
Server : Microsoft-IIS/8.5
WWW-Authenticate : Bearer error="invalid_token"
Date : Tue, 08 Mar 2016 14:10:41 GMT
Connection : close
Request Method :POST
Content : Content=this+is+from+a+function&From=FBR-PACE&RegisteredDelivery=true&To=%2B233246022602&Direction=out
Accept : application/json
=== HTTP Response ===
Receive url :http://api.smsgh.com/v3/messages/
Status : 201
POST /v3/messages/ HTTP/1.1
Host: api.smsgh.com
Authorization: Basic Y2V4Z3hwZXg6dnZkcWVwenM=
Accept: */*
Content-Length: 102
Content-Type: application/x-www-form-urlencoded

{"Rate":1,"MessageId":"437d6a60-87a8-4551-b751-c05eed4f5849","Status":0,"NetworkId":"62001"}array(0) {
}

please how can i convert this to php array.

[Help on Select data from mysqli using an array in WHERE clause]

 <?php
          $array = array(
              "FBR-15","FBR-16","FBR-17","FBR-18","FBR-19","FBR-20","FBR-500"
          );

          $array =

            
            $q = mysqli_query($dbc,"SELECT * FROM tree_tbl WHERE `id` IN (array_map('intval','$array'))");
            while($data = mysqli_fetch_array($q)){
              echo "<li>".$data['tree_code']."</li></br>";
            }
          ?>

Please I heed helpin solving this 

[Difference between only time]

Please Can someone help

me on this

 

Am creating a timetable system and i want to check only the time difference

 

Am collect a time only from the html form thus

$startTime = 13:30:00

$endTime = 14:00:00

How can i find the deference between this time from the html in php.

Thanks

[Selecting all data of a specific date from mysql datetime]

SELECT * FROM `booking_tbl` WHERE booking_status = 'Check In' AND departure_date_time = NOW()"

I use the datetime datatype for the departure_date_time so i can get data from that data because it checking the date and time

 

but i want it to check on the date from the datetime datatype

 

So how can i get the data only with that date without the time in the mysql datetime datatype

[How to select the last 24 hours from a table with DATATIME column]

Thank you very much

[How to select the last 24 hours from a table with DATATIME column]

Please I want get data from mysql; 

1. The last 24 hours. 
2 the last 7 days 
3. the last Months 

4. Last 12 hours

please try and help me