PHP - How To Echo Data Response Json?

I got a response from an api in json. How do i echo out the account_name in string. Thanks as usual. The response is below...

 

{ "status": true, "message": "Account number resolved", "data": { "account_number": "2067483918", "account_name": "BABALOLA MAYOWA ABEL", "bank_id": 18 } }

"status": true, "message": "Account number resolved", "data": { "account_number": "2067483918", "account_name": "BABALOLA MAYOWA ABEL", "bank_id": 18 } }

 

Evening everyone and Merry X-Mas (Happy Holidays) or whatever fits you best....   I have been trying over and over for about 12 hours to figure out how to get data from a specific JSON response and assign the specific values to a new array key/value pair. The various ways I have tried to figure this out are  numerous so i'm going to avoid the runnig list of "I trieid this...and this...and this... etc etc." just understand I have reached a dead end point where I need help badly.   Here is what our end goal is:   "The company" is a "service industry" provider (plumbing, electrical etc. etc.) who wants to dispatch its technicians to new jobs based on which technician has the shortest travel time from any existing address where they already have a scheduled appointment that day and has available time in there schedule. Thus the dispatching system when a new service call is entered is going to give "recommended" technicians (up to 4) to be assigned the new service call based on the above mentioned criteria. (Efficient routing to save company gas cost)   1.) We have a "New service" street address assigned to the $to variable: $to = "4813 River Basin Dr S, Jacksonville FL 32207";
    2.) We will have "records" array which containes a series of records, each record consists of a ticket# a technician id# and a street address: $records = array(
array("DV1012","30453423","9890 Hutchinson Park Dr Jacksonville, FL 32225"),
array("DB3434","30404041","821 Orange Ave Crescent City, FL 32112"),
array("DB3434","30605060","1972 Wells Road, Orange Park FL 32073"),
array("DB4578","30605060","2 Independent Drive, Jacksonville FL 32202"),
array("DB7841","30605060","5000 Norwood Avenue, Jacksonville FL 32208"),
array("DB3235","30605060","9501 Arlington Expressway, Jacksonville FL 32225"),
array("DB7894","30605060","Massey Avenue, Jacksonville, FL 32227"),
array("DB2020","30121212","11200 Central Pkwy Jacksonville, FL 32224")
                );   3.) We are going to prepare the records array for submission to Google's Distance Matrix API by URL encoding each array value into a single variable and then submit it:   foreach ($records as $key => $value) {$from = $from.urlencode($value[2])."|";} $to = urlencode($to);
$data = file_get_contents("//maps.googleapis.com/maps/api/distancematrix/json?origins=$from&destinations=$to&language=en-EN&units=imperial&mode=driving&sensor=false");
$res=json_decode($data) or die("Error: Cannot read object");
  You may look at the ACTUAL live Google response from this he http://tiny.cc/i6eerx  (We have applied <pre> and var_dump($res) to the output)   We are looking to get the following information back: The distance and travel time between the "New Service" address ($to) and each of the address' in the $records array ($from), now once that information is returned from Google (JSON response) we need to parse the response and narrow it down to 4 or less (Based on the 4 lowest drive times) to form a new array which ends like this:   $results = array(
array("DV1012","30453423","2.3 Miles","8 mins"),
array("DB3434","30404041","2.8 Miles","9 mins"),
array("DB3434","30605060","4.6 Miles","13.8 mins"),
array("DB4578","30605060","5.7 Miles","15.2 min")
                ); OUR PROBLEM: Everything up until the the Google API response is fine, but iterating over the multidimensional arrays within multidimensional arrays of the JSON response is just not coming together in my head (or 2 dozen code attempts). I am able to ECHO an individual value like ( echo $res->rows[0]->elements[0]->distance->text; ) but this has no value for the end result i need to get to. My last thoughts and efforts was that that I was going to have to embed foreach statements within foreach statements to drill down through the various arrays but that hasn't worked very well and it seems like it shouldn't be how it has to be done. I would appreciate any help in showing me how the iteration code should be written and any explanation about the code so i can wrap my head around it.

Hello.   I am new here.   I have a sligh problem, i saw a few results here which however did not lead to the desired result.   The problem is , i have this Json Response from a API:

Array
(
    [0] => Array
        (
            [isoid] => 0
            [omschrijving] => - leeg -
        )

    [1] => Array
        (
            [isoid] => 64
            [omschrijving] => ArchLinux 2013.5
        )

    [2] => Array
        (
            [isoid] => 75
            [omschrijving] => AsteriskNOW 3.0.0 64b
        )

    [3] => Array
        (
            [isoid] => 67
            [omschrijving] => CentOS 5.9 32b
        )

    [4] => Array
        (
            [isoid] => 2
            [omschrijving] => CentOS 6.3 64b
        )

    [5] => Array
        (
            [isoid] => 96
            [omschrijving] => CentOS 7.0 64b
        )

    [6] => Array
        (
            [isoid] => 4
            [omschrijving] => Clear OS 5.2 64b
        )

    [7] => Array
        (
            [isoid] => 93
            [omschrijving] => CloudLinux 6.4
        )

    [8] => Array
        (
            [isoid] => 1
            [omschrijving] => Debian GNU/Linux 6.0 / Squeeze 64b
        )

    [9] => Array
        (
            [isoid] => 79
            [omschrijving] => Debian GNU/Linux 7.0 / Wheezy 32b
        )

    [10] => Array
        (
            [isoid] => 71
            [omschrijving] => Debian GNU/Linux 7.0 / Wheezy 64b
        )

    [11] => Array
        (
            [isoid] => 63
            [omschrijving] => Fedora 18 64b
        )

    [12] => Array
        (
            [isoid] => 82
            [omschrijving] => FreeBSD 10 64b
        )

    [13] => Array
        (
            [isoid] => 77
            [omschrijving] => FreeBSD 9.2 64b
        )

    [14] => Array
        (
            [isoid] => 10
            [omschrijving] => FreePBX 5.211.65-12
        )

    [15] => Array
        (
            [isoid] => 76
            [omschrijving] => GParted Live CD
        )

    [16] => Array
        (
            [isoid] => 3
            [omschrijving] => KVM Virtio drivers voor Windows
        )

    [17] => Array
        (
            [isoid] => 66
            [omschrijving] => MailCleaner 2012v6 64b
        )

    [18] => Array
        (
            [isoid] => 68
            [omschrijving] => Manjaro KDE 0.8.6 64b
        )

    [19] => Array
        (
            [isoid] => 78
            [omschrijving] => Microsoft Windows 7 Pro 64b
        )

    [20] => Array
        (
            [isoid] => 69
            [omschrijving] => Microsoft Windows Server 2003 EN
        )

    [21] => Array
        (
            [isoid] => 8
            [omschrijving] => Microsoft Windows Server 2008R2 EN
        )

    [22] => Array
        (
            [isoid] => 7
            [omschrijving] => Microsoft Windows Server 2008R2 NL
        )

    [23] => Array
        (
            [isoid] => 70
            [omschrijving] => Microsoft Windows Server 2012 NL 64b
        )

    [24] => Array
        (
            [isoid] => 84
            [omschrijving] => Microsoft Windows Server 2012R2 NL
        )

    [25] => Array
        (
            [isoid] => 83
            [omschrijving] => NOC PS 1.0r11
        )

    [26] => Array
        (
            [isoid] => 11
            [omschrijving] => OpenBSD 5.2
        )

    [27] => Array
        (
            [isoid] => 80
            [omschrijving] => OpenBSD 5.4
        )

    [28] => Array
        (
            [isoid] => 94
            [omschrijving] => OpenBSD 5.5 64b
        )

    [29] => Array
        (
            [isoid] => 72
            [omschrijving] => OpenSUSE 12.3 64b
        )

    [30] => Array
        (
            [isoid] => 95
            [omschrijving] => Slackware 13.37
        )

    [31] => Array
        (
            [isoid] => 12
            [omschrijving] => System Rescue CD
        )

    [32] => Array
        (
            [isoid] => 18
            [omschrijving] => Turnkey Appflower
        )

    [33] => Array
        (
            [isoid] => 19
            [omschrijving] => Turnkey ASP.net/Apache
        )

    [34] => Array
        (
            [isoid] => 20
            [omschrijving] => Turnkey Bugzilla
        )

    [35] => Array
        (
            [isoid] => 21
            [omschrijving] => Turnkey CodeIgniter
        )

    [36] => Array
        (
            [isoid] => 22
            [omschrijving] => Turnkey Django
        )

    [37] => Array
        (
            [isoid] => 23
            [omschrijving] => Turnkey Dokuwiki
        )

    [38] => Array
        (
            [isoid] => 24
            [omschrijving] => Turnkey DomainControler
        )

    [39] => Array
        (
            [isoid] => 25
            [omschrijving] => Turnkey Drupal7
        )

    [40] => Array
        (
            [isoid] => 26
            [omschrijving] => Turnkey Fileserver
        )

    [41] => Array
        (
            [isoid] => 27
            [omschrijving] => Turnkey Gallery
        )

    [42] => Array
        (
            [isoid] => 28
            [omschrijving] => Turnkey Gitlab
        )

    [43] => Array
        (
            [isoid] => 15
            [omschrijving] => Turnkey Google AppEngine Go
        )

    [44] => Array
        (
            [isoid] => 16
            [omschrijving] => Turnkey Google AppEngine Java
        )

    [45] => Array
        (
            [isoid] => 17
            [omschrijving] => Turnkey Google AppEngine Python
        )

    [46] => Array
        (
            [isoid] => 29
            [omschrijving] => Turnkey IceScrum
        )

    [47] => Array
        (
            [isoid] => 30
            [omschrijving] => Turnkey Joomla2.5
        )

    [48] => Array
        (
            [isoid] => 31
            [omschrijving] => Turnkey LAMP
        )

    [49] => Array
        (
            [isoid] => 32
            [omschrijving] => Turnkey Lighttpd/PHP/FastCGI
        )

    [50] => Array
        (
            [isoid] => 33
            [omschrijving] => Turnkey Magento
        )

    [51] => Array
        (
            [isoid] => 34
            [omschrijving] => Turnkey Mediawiki
        )

    [52] => Array
        (
            [isoid] => 35
            [omschrijving] => Turnkey MongoDB
        )

    [53] => Array
        (
            [isoid] => 36
            [omschrijving] => Turnkey MySQL
        )

    [54] => Array
        (
            [isoid] => 37
            [omschrijving] => Turnkey NGINX/PHP/FastCGI
        )

    [55] => Array
        (
            [isoid] => 38
            [omschrijving] => Turnkey OpenLDAP
        )

    [56] => Array
        (
            [isoid] => 39
            [omschrijving] => Turnkey OpenPhoto
        )

    [57] => Array
        (
            [isoid] => 40
            [omschrijving] => Turnkey OSCommerce
        )

    [58] => Array
        (
            [isoid] => 41
            [omschrijving] => Turnkey OTRS
        )

    [59] => Array
        (
            [isoid] => 42
            [omschrijving] => Turnkey Owncloud
        )

    [60] => Array
        (
            [isoid] => 43
            [omschrijving] => Turnkey PHPBB
        )

    [61] => Array
        (
            [isoid] => 44
            [omschrijving] => Turnkey PHPList
        )

    [62] => Array
        (
            [isoid] => 45
            [omschrijving] => Turnkey PHPNuke
        )

    [63] => Array
        (
            [isoid] => 46
            [omschrijving] => Turnkey Postgresql
        )

    [64] => Array
        (
            [isoid] => 47
            [omschrijving] => Turnkey Prestashop
        )

    [65] => Array
        (
            [isoid] => 48
            [omschrijving] => Turnkey Rails
        )

    [66] => Array
        (
            [isoid] => 49
            [omschrijving] => Turnkey Redmine
        )

    [67] => Array
        (
            [isoid] => 50
            [omschrijving] => Turnkey SiTracker
        )

    [68] => Array
        (
            [isoid] => 51
            [omschrijving] => Turnkey StatusNET
        )

    [69] => Array
        (
            [isoid] => 52
            [omschrijving] => Turnkey SugarCRM
        )

    [70] => Array
        (
            [isoid] => 53
            [omschrijving] => Turnkey Symfony
        )

    [71] => Array
        (
            [isoid] => 54
            [omschrijving] => Turnkey Tomcat
        )

    [72] => Array
        (
            [isoid] => 55
            [omschrijving] => Turnkey Tomcat/Apache
        )

    [73] => Array
        (
            [isoid] => 56
            [omschrijving] => Turnkey TRAC
        )

    [74] => Array
        (
            [isoid] => 57
            [omschrijving] => Turnkey TWiki
        )

    [75] => Array
        (
            [isoid] => 58
            [omschrijving] => Turnkey Typo3
        )

    [76] => Array
        (
            [isoid] => 59
            [omschrijving] => Turnkey Wordpress
        )

    [77] => Array
        (
            [isoid] => 60
            [omschrijving] => Turnkey Zencart
        )

    [78] => Array
        (
            [isoid] => 13
            [omschrijving] => Ubuntu 10.04 32b
        )

    [79] => Array
        (
            [isoid] => 6
            [omschrijving] => Ubuntu 10.04 64b
        )

    [80] => Array
        (
            [isoid] => 14
            [omschrijving] => Ubuntu 12.04 32b
        )

    [81] => Array
        (
            [isoid] => 61
            [omschrijving] => Ubuntu 12.04 64b
        )

    [82] => Array
        (
            [isoid] => 62
            [omschrijving] => Ubuntu 12.10 64b	
        )

    [83] => Array
        (
            [isoid] => 89
            [omschrijving] => Ubuntu 14.04 LTS 64b
        )

    [84] => Array
        (
            [isoid] => 5
            [omschrijving] => Windows Password Reset
        )

    [85] => Array
        (
            [isoid] => 81
            [omschrijving] => Zen Loadbalancer 3.03
        )

    [86] => Array
        (
            [isoid] => 74
            [omschrijving] => Zentyal 3.2
        )

)

how would i go to fill it automatically in a option value like

<option value='74'>Zentyal 3.2</option>

Thank you in advance

The array. Output of the variable $v
Code: [Select]
xmlrpcval Object
(
    [me] => Array
        (
            [struct] => Array
                (
                    [sec] => xmlrpcval Object
                        (
                            [me] => Array
                                (
                                    [string] => 349955dd5d3156af95cb4e75a13cffaa
                                )

                            [mytype] => 1
                        )
          )
)

examples of what I have tried

echo $v->string;


How could I get the value of [string]. I know that its an object but cannot find how to get the value.

Hello everyone. I'm a self learner that is very new to programming. I'm trying to print out the value of ["mid"]  from a json_decode variable in the code shown below: 

I'm trying to use for each to access the value of "mid'. using foreach function. I know I'm not doing it the right way. please help me or show me an easy was to go around it.

/////the json resopnd form the url is  :

{"terms":"http://www.xe.com/legal/dfs.php","privacy":"http://www.xe.com/privacy.php","from":"USD","amount":1.195,"timestamp":"2021-02-09T16:52:00Z","to":[{"quotecurrency":"NGN","mid":454.6559871014}]}
/////////////////////////////////////////////////

<?php
$auth = base64_encode("username:password");
$context = stream_context_create([
    "http" => [
        "header" => "Authorization: Basic $auth"
    ]
]);
$homepage = file_get_contents("https://xecdapi.xe.com/v1/convert_from?to=NGN&amount=1.195", false, $context );
$json = json_decode($homepage, TRUE);
foreach ($json as $price){
    echo $price['mid'];
};

?>

 

Hi All,

I'm trying to echo the response from an SLA query, the query works and returns the data when I test it on an SQL application.. but when I run it on my webpage it won't echo the result.

Please help?

<?php   
$mysqli = mysqli_connect("removed", "removed", "removed", "removed");  
$sql = "SELECT posts.message FROM posts INNER JOIN threads ON posts.pid=threads.firstpost WHERE threads.firstpost='1'";  
$result = mysqli_query($mysqli, $sql);   
echo {$result['message']}; 
?>

I am also trying to extract the "address_components" from the JSON data, but the array index changes if you do not submit an address line for example.

I am trying to get the "sublocality" and "administrative_area_level_1" from the "address_components" below.

The API sample is as follows:

{
   "results" : [
      {
         "access_points" : [],
         "address_components" : [
            {
               "long_name" : "10",
               "short_name" : "10",
               "types" : [ "street_number" ]
            },
            {
               "long_name" : "Gillespie Street",
               "short_name" : "Gillespie St",
               "types" : [ "route" ]
            },
            {
               "long_name" : "South Beach",
               "short_name" : "South Beach",
               "types" : [ "political", "sublocality", "sublocality_level_1" ]
            },
            {
               "long_name" : "Durban",
               "short_name" : "Durban",
               "types" : [ "locality", "political" ]
            },
            {
               "long_name" : "Durban Metro",
               "short_name" : "Durban Metro",
               "types" : [ "administrative_area_level_2", "political" ]
            },
            {
               "long_name" : "KwaZulu-Natal",
               "short_name" : "KZN",
               "types" : [ "administrative_area_level_1", "political" ]
            },
            {
               "long_name" : "South Africa",
               "short_name" : "ZA",
               "types" : [ "country", "political" ]
            },
            {
               "long_name" : "4001",
               "short_name" : "4001",
               "types" : [ "postal_code" ]
            }
         ],
         "formatted_address" : "10 Gillespie St, South Beach, Durban, 4001, South Africa",
         "geometry" : {
            "location" : {
               "lat" : -29.859728,
               "lng" : 31.039773
            },
            "location_type" : "ROOFTOP",
            "viewport" : {
               "northeast" : {
                  "lat" : -29.8583790197085,
                  "lng" : 31.0411219802915
               },
               "southwest" : {
                  "lat" : -29.8610769802915,
                  "lng" : 31.0384240197085
               }
            }
         },
         "place_id" : "ChIJGRCdW0mo9x4RcIwU_7S1xa8",
         "plus_code" : {
            "compound_code" : "42RQ+4W Durban, South Africa",
            "global_code" : "5G2H42RQ+4W"
         },
         "types" : [ "street_address" ]
      }
   ],
   "status" : "OK"
}

If you submit a full address to the API, you can use the hard coded index like below: [7]

$json_a['results'][0]['address_components'][7]['long_name']

But it is not reliable to hard code the index [7] in this case.

So I tested some sample code from above post, it is working, but in some cases it does not return the "long_name" of the "sublocality" or "administrative_admin_level_1":

/* if no address, then the array index change */
//  $json_a['results'][0]['address_components'][7]['long_name']
$area = array();
foreach ($json_a['results'][0]['address_components'] as $addrObj) {
    foreach($addrObj['types'] as $type) {
         if (substr_count($type, 'sublocality')>0) {
             $area['short_name'] = $addrObj['short_name'];
             $area['long_name'] = $addObj['long_name'];
						  // var_dump($addrObj);
         } 
         if (substr_count($type, 'administrative_area_level_1')>0) {
             $area['short_admin'] = $addrObj['short_name'];
             $area['long_admin'] = $addObj['long_name'];
						  var_dump($addrObj);
         } 
    }
}

In the var_dump() I do get the long_name value though: In this sample it must be "Kwazulu-Natal", but from the code above, it returns a NULL value.

array(3) { ["long_name"]=> string(13) "KwaZulu-Natal" ["short_name"]=> string(3) "KZN" ["types"]=> array(2) { [0]=> string(27) "administrative_area_level_1" [1]=> string(9) "political" } } 

Below is the full script I am trying to get to work. The lon, lng and format name is working 100%, it is just this array index problem.

/*  get google result in JSON*/
$googleString = file_get_contents($googleUrl); // get json content
$json_a = json_decode($googleString, true); //json decoder

// response status will be 'OK', if able to geocode given address 
if($json_a['status']=='OK'){
// get the important data
$lati = isset($json_a['results'][0]['geometry']['location']['lat']) ? $json_a['results'][0]['geometry']['location']['lat'] : "";
$longi = isset($json_a['results'][0]['geometry']['location']['lng']) ? $json_a['results'][0]['geometry']['location']['lng'] : "";
$formatted_address = isset($json_a['results'][0]['formatted_address']) ? $json_a['results'][0]['formatted_address'] : "";

/* if no address, then the array index change */
//  $json_a['results'][0]['address_components'][7]['long_name']
$area = array();
foreach ($json_a['results'][0]['address_components'] as $addrObj) {
    foreach($addrObj['types'] as $type) {
         if (substr_count($type, 'sublocality')>0) {
             $area['short_name'] = $addrObj['short_name'];
             $area['long_name'] = $addObj['long_name'];
						  // var_dump($addrObj);
         } 
         if (substr_count($type, 'administrative_area_level_1')>0) {
             $area['short_admin'] = $addrObj['short_name'];
             $area['long_admin'] = $addObj['long_name'];
						  var_dump($addrObj);
         } 
    }
}

Is there a better way to get the "sublocality" and "administrative_area_level_1" from the array $area array above. Any pointers will be much appreciated.

Hi,

Anybody can help me to extract data from son using php

 

{"location":{"woeid":2293962,"city":"Kasaragod","region":" KL","country":"India","lat":12.5174,"long":74.990662,"timezone_id":"Asia/Kolkata"},"current_observation":{"wind":{"chill":80,"direction":338,"speed":11.81},"atmosphere":{"humidity":70,"visibility":10.0,"pressure":29.8,"rising":0},"astronomy":{"sunrise":"6:54 am","sunset":"6:35 pm"},"condition":{"text":"Clear","code":31,"temperature":80},"pubDate":1549638000},"forecasts":[{"day":"Fri","date":1549564200,"low":76,"high":85,"text":"Sunny","code":32},{"day":"Sat","date":1549650600,"low":76,"high":85,"text":"Sunny","code":32},{"day":"Sun","date":1549737000,"low":75,"high":85,"text":"Sunny","code":32},{"day":"Mon","date":1549823400,"low":76,"high":87,"text":"Mostly Sunny","code":34},{"day":"Tue","date":1549909800,"low":76,"high":89,"text":"Sunny","code":32},{"day":"Wed","date":1549996200,"low":77,"high":88,"text":"Partly Cloudy","code":30},{"day":"Thu","date":1550082600,"low":76,"high":89,"text":"Mostly Sunny","code":34},{"day":"Fri","date":1550169000,"low":76,"high":86,"text":"Sunny","code":32},{"day":"Sat","date":1550255400,"low":76,"high":85,"text":"Sunny","code":32},{"day":"Sun","date":1550341800,"low":74,"high":85,"text":"Sunny","code":32}]}

 

How to extract data of "current_observation"

 

Thanks

A HTTP request is made to the server, Slim creates a Request and Response object, content in the Request is sent to another server using cURL via Guzzle, Guzzle returns its own Response,  and content from Guzzle's response must be returned by the original Slim response.

Would you recommend white-listing or black-listing response headers, and which specific headers?

Similarly, would you recommend white-listing or black-listing the request headers sent via cURL, and which specific headers?

Thanks

<?php
use Psr\Http\Message\ResponseInterface as Response;
use GuzzleHttp\Psr7\Response as CurlResponse;

class ApiResponder
{
    public function delete(Response $httpResponse, CurlResponse $curlResponse) {
        return $this->proxy($httpResponse, $curlResponse);
    }
    //other public methods...

    private function proxy(Response $httpResponse, CurlResponse $curlResponse) {
        foreach($this->getResponseHeaders($curlResponse) as $name=>$value) {
            $httpResponse=$httpResponse->withHeader($name, $value);
        }
        return $httpResponse->withBody($curlResponse->getBody())->withStatus($curlResponse->getStatusCode());
    }

    private function getResponseHeaders(Response $httpResponse):array
    {
        //Blacklist headers which should be returned to original client.  TBD whether I should whitelist headers instead.
        $blacklist=['Date'=>null, 'Server'=>null, 'X-Powered-By'=>null, 'Access-Control-Allow-Origin'=>null, 'Access-Control-Allow-Methods'=>null, 'Access-Control-Allow-Headers'=>null, 'Set-Cookie'=>null];
        return array_diff_key($curlResponse->getHeaders(), $blacklist);
    }

    /**
    * This method doesn't really exist in this class, but is just included to show which headers I am forwarding in the cURL request.
    */
    private function getRequestHeaders($clientRequest):array
    {
        $whitelist=['connection'=>null,'accept'=>null,'accept-encoding'=>null,'accept-language'=>null,'content-type'=>null,'content-length'=>null];
        return array_intersect_key($clientRequest->getHeaders(), $whitelist);
    }
}

 

So when I load my paginator it returns No Results Found. 1) My query is only returning 1 array entry, should be hundreds, maybe I'm not builing it correctly, 2) There is at least 1 array set but its still saying data not found.

Heres the template array:
Code: [Select]
array('id'=>'0', 'name'=>'xmlqoyzgmykrphvyiz', 'date'=>'13-Sep-2002', 'price'=>'8370', 'number'=>'8056', 'address'=>'qdfbc', 'company'=>'taufrid', 'desc'=>'pppzhfhcdqcvbirw', 'age'=>'5512', 'title'=>'zticbcd', 'phone'=>'hvdkltabshgakjqmfrvxo', 'email'=>'eodnqepua', 'zip'=>'eodnqepua', 'country'=>'pdibxicpqipbsgnxyjumsza'),
array('id'=>'1', 'name'=>'rbdmbabficcre', 'date'=>'10-Sep-2004', 'price'=>'3075', 'number'=>'3627', 'address'=>'oxcm', 'company'=>'xyzwzv', 'desc'=>'rwndyoedxh', 'age'=>'2134', 'title'=>'lxxyfgdtdffjce', 'phone'=>'zeejvbwy', 'email'=>'ldcikhxwfuulaxeedkogpxftb', 'zip'=>'ldcikhxwfuulaxeedkogpxftb', 'country'=>'pcmobxrdfclcyrx'),
array('id'=>'2', 'name'=>'yr', 'date'=>'04-Mar-2007', 'price'=>'7129', 'number'=>'6614', 'address'=>'i', 'company'=>'gcpvrshftfxxlz', 'desc'=>'nyalrdjjl', 'age'=>'4728', 'title'=>'ddfl', 'phone'=>'mnhifzqltvirgiaug', 'email'=>'f', 'zip'=>'f', 'country'=>'epipbmtfsfxetenyedjxzsog'), etc
Here is my arry:
Code: [Select]
$echoarray =  array();
$resultsql = mysql_query("SELECT * FROM clients")or die(mysql_error());
while($row = mysql_fetch_array($resultsql)){
$echoarray['id'] = $row['ID'];
$echoarray['name'] = $row['First_Name'] . " " . $row['Last_Name'];
$echoarray['price'] = $row['Status'];
$echoarray['number'] = $row['Sex'];
$echoarray['address'] = $row['Phys_Street'];
$echoarray['company'] = $row['Agency'];
$echoarray['desc'] = $row['Notes'];
$echoarray['age'] = $row['Date_Birth'];
$echoarray['title'] = $row['Occupation'];
$echoarray['phone'] = $row['Phone'];
$echoarray['email'] = $row['Email'];
$echoarray['zip'] = $row['Phys_Zip'];
$echoarray['country'] = $row['Phys_City'];
}

Here is the template return:

Code: [Select]
function initArray() {
return array(
array('id'=>'0', 'name'=>'xmlqoyzgmykrphvyiz', 'date'=>'13-Sep-2002', 'price'=>'8370', 'number'=>'8056', 'address'=>'qdfbc', 'company'=>'taufrid', 'desc'=>'pppzhfhcdqcvbirw', 'age'=>'5512', 'title'=>'zticbcd', 'phone'=>'hvdkltabshgakjqmfrvxo', 'email'=>'eodnqepua', 'zip'=>'eodnqepua', 'country'=>'pdibxicpqipbsgnxyjumsza'),
array('id'=>'1', 'name'=>'rbdmbabficcre', 'date'=>'10-Sep-2004', 'price'=>'3075', 'number'=>'3627', 'address'=>'oxcm', 'company'=>'xyzwzv', 'desc'=>'rwndyoedxh', 'age'=>'2134', 'title'=>'lxxyfgdtdffjce', 'phone'=>'zeejvbwy', 'email'=>'ldcikhxwfuulaxeedkogpxftb', 'zip'=>'ldcikhxwfuulaxeedkogpxftb', 'country'=>'pcmobxrdfclcyrx'),
array('id'=>'2', 'name'=>'yr', 'date'=>'04-Mar-2007', 'price'=>'7129', 'number'=>'6614', 'address'=>'i', 'company'=>'gcpvrshftfxxlz', 'desc'=>'nyalrdjjl', 'age'=>'4728', 'title'=>'ddfl', 'phone'=>'mnhifzqltvirgiaug', 'email'=>'f', 'zip'=>'f', 'country'=>'epipbmtfsfxetenyedjxzsog'),
array('id'=>'3', 'name'=>'bhqggvwolybfdtk', 'date'=>'26-Dec-2000', 'price'=>'1867', 'number'=>'4288', 'address'=>'jo', 'company'=>'goevufkvmbct', 'desc'=>'zhixinabyazbfleozrvovr', 'age'=>'3423', 'title'=>'b', 'phone'=>'odhh', 'email'=>'g', 'zip'=>'g', 'country'=>'idxvdztezvkkaz'));
}

And Mine:

Code: [Select]
function initArray() {
return $echoarray;
}
Where am I going wrong here?

<?php
ini_set('display_errors', 0);
function escapeArray($array)
{
        foreach ($array as $key => $val)
        {
			if(is_array($val)){
				$array[$key]=escapeArray($val);
			}
			else{
				$array[$key]=addslashes($val);
			}
        }

        return $array;
		
}





$request_type=$_SERVER['REQUEST_METHOD'];
$api_key=$_SERVER['HTTP_X_API_KEY'];
$res=array();
if($api_key!=="643256432"){
	$res['msg']="Failu Invalid API KEY";
	echo json_encode($res);
	die;
}
// Connects to the orcl service (i.e. database) on the "localhost" machine
//$conn = oci_connect('SCOTT', 'admin123', 'localhost/orcl');

$conn = oci_connect('test', 'test', '192.168.10.43/test.test.com');

if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$request=file_get_contents("php://input");
$request=escapeArray(json_decode($request,true));

 print_r($request);
// die;
if($request_type=="POST"){//for creation of invoice


echo	$CONTACT_ID=isset($request['CONTACT_ID'])?$request['CONTACT_ID']:"";
	$INV_SERIAL_NO=isset($request['INV_SERIAL_NO'])?$request['INV_SERIAL_NO']:"";
	$NAME=isset($request['NAME'])?$request['NAME']:"";
	$INV_DATE=isset($request['INV_DATE'])?$request['INV_DATE']:"";
	$DUE_DATE=isset($request['DUE_DATE'])?$request['DUE_DATE']:"";
	$CURRENCY=isset($request['CURRENCY'])?$request['CURRENCY']:"";
	$SUBTOTAL=isset($request['SUBTOTAL'])?$request['SUBTOTAL']:"";
	$TAX_TOTAL=isset($request['TAX_TOTAL'])?$request['TAX_TOTAL']:"";

echo $SHIP_SERIAL_NO=isset($request['SHIP_SERIAL_NO'])?$request['SHIP_SERIAL_NO']:"";
	$MASTER_NO=isset($request['MASTER_NO'])?$request['MASTER_NO']:"";
	$HOUSE_NO=isset($request['HOUSE_NO'])?$request['HOUSE_NO']:"";
	$shipment_data=isset($request['shipment_data'])?$request['shipment_data']:"";

	if($CONTACT_ID==""){
		$res['msg']="CONTACT_ID is required";
	}
	else if($INV_SERIAL_NO==""){
		$res['msg']="INV_SERIAL_NO is required";
	}
	else if($NAME==""){
		$res['msg']="NAME is required";
	}
	else if($INV_DATE==""){
		$res['msg']="INV_DATE is required";
	}
	else if($DUE_DATE==""){
		$res['msg']="DUE_DATE is required";
	}
	else if($CURRENCY==""){
		$res['msg']="CURRENCY is required";
	}
	else if($SUBTOTAL==""){
		$res['msg']="SUBTOTAL is required";
	}
	else if($TAX_TOTAL==""){
		$res['msg']="TAX_TOTAL is required";
	}

	
	else if($MASTER_NO==""){
		$res['msg']="MASTER_NO is required";
	}
	else if($HOUSE_NO==""){
		$res['msg']="HOUSE_NO is required";
	}
	else if($SHIP_SERIAL_NO==""){
		$res['msg']="SHIP_SERIAL_NO is required";
	}



	

	else{
		$stid = oci_parse($conn, "Select * from FL_HDR_INVOICE where CONTACT_ID='$CONTACT_ID'");
		(oci_execute($stid));
		oci_fetch_all($stid, $out);
		
		

		if(count($out['CONTACT_ID'])==0){

			$stid = oci_parse($conn, "Insert into FL_HDR_INVOICE (CONTACT_ID,INV_SERIAL_NO,NAME,INV_DATE,DUE_DATE,CURRENCY,SUBTOTAL,TAX_TOTAL) Values ('$CONTACT_ID','$INV_SERIAL_NO','$NAME',TO_DATE('$INV_DATE','YYYY-MM-DD'),TO_DATE('$DUE_DATE','YYYY-MM-DD'),'$CURRENCY','$SUBTOTAL','$TAX_TOTAL')");
			oci_execute($stid);

			$stid_2 = oci_parse($conn, "Insert into FL_SHIPMENT_DATA (CONTACT_ID,INV_SERIAL_NO,SHIP_SERIAL_NO,MASTER_NO,HOUSE_NO) Values ('$CONTACT_ID','$INV_SERIAL_NO','$SHIP_SERIAL_NO','$MASTER_NO','$HOUSE_NO')");
			oci_execute($stid_2);



			if(oci_num_rows($stid)>0){
				$res['msg']="Invoice created successfully against this contact_id:".$CONTACT_ID;
			}
			else{
				$res['msg']="Something going wrong please try again later";
				
			}
		}
		else{
			$res['msg']="contact_id must be unique";
		}
	}
	echo json_encode($res);
	die;
}

I need to read json data inside an array. Please help correct my code.. i am trying to do an API.

I am retrieving data from a third party's API using AJAX method. I would like to do two things.

1. Display the data records on a page.

2. Create a pagination on the page to display records more efficiently. I am expecting to retrieve possibly hundreds of records. I can normally do this using PHP but since I am retrieving the records using AJAX, the pagination is gonna be a challenge. 

First things first is to display the records. Here is my AJAX code.

It displays the log data fine. But it doesn't display any data in the "output" div. And it gives this error in the console.

Uncaught SyntaxError: Unexpected token o in JSON at position 1
at JSON.parse (<anonymous>)
at Object.success

<div class="output"></div>

<script>
  $.ajax ({
    type: 'GET',
    url: "https://3rdpartywebsite.com/api/GetCustomers",
    dataType: 'json',
    processData: false,
    contentType: false,
    success: function(data) {
      console.log(data)

      $newData = JSON.parse(data);
      $.each($newData, function(i, v) {
         $('.output').append(v.LastName);
         $('.output').append(v.FirstName);
      });
    }
  });
</script>

 

What am I doing wrong?

Edited November 14, 2020 by imgrooot

I am retrieving Google Books info in JSON format and displaying it inside a div. I would like to send the contents of this div (name, title, description) to my database using Ajax.   Currently only the ISBN field sends because I have it declared as a variable. However my question is, how do I send the other fields (name, title, author). How do I declare these also, I'm not sure what format they need to be in etc.   My JS

$(document).ready(function() {
$('#submit').click(function(ev) {
ev.preventDefault();
var isbn = $('#isbn_search').val(); //get isbn direct from input
var url='https://www.googleapis.com/books/v1/volumes?q='+isbn;
$.getJSON(url,function(data){
$.each(data.items, function(entryIndex, entry){
var html = '<div class="results well">'; 
html += '<h3>' + entry.volumeInfo.title + '</h3>';
html += '<div class="author">' + entry.volumeInfo.authors + '</div>';
html += '<div class="description">' + entry.volumeInfo.description + '</div>';
}); 
});
});
});

My Ajax;

        $.ajax({
             type: 'POST',
             url: 'addIsbnScript.php',
             data: {
                 'isbn' : isbn,
                 'title' : title
                 'subtitle' : subtitle,
                 'authors' : authors,
                 'description' : description
             },
             success: function () { 
            $.growl({
            message: " Record added"
});      
}
});

Note, if i manually set the vars like below they all do successfully send to my database, so I know my query is working ok

var title = "some text",
var author = "some text",
Var description = "some text"

Thanks in advance for any help, newbie here (incase it wasn't obvious!).   J  

Hi,


I have a problem with some code not working.

I need it to get the data from a mysql database and then export it as a json array in the format of id , title, author, date, imageUrl, text. (Please not that these are all variables )

PHP CODE:
Code: [Select]
<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

$arr = array();
$rs = ("SELECT `id`, `title`, `author`, `date`, `imageUrl`, `text` FROM `items`");
 
while($obj = mysql_query($rs)) {
$arr[0] =  $obj->id;
$arr[1] =  $obj->title;
$arr[2] =  $obj->author;
$arr[3] =  $obj->date;
$arr[4] =  $obj->imageUrl;
$arr[5] =  $obj->text;
}
 
echo '{"items":'.json_encode($arr).'}';
?>

Thanks For Your Help
borden0108

This is more of a database architect question.   I am building a CMS for website development. I am ready to use it for the first time on one of my clients. Now, my issue is is how to set up some or one of my table(s) for some areas that my client wants to be able to change in the admin section.   In their website on the front page, I put together this nice block slider. Its 6 blocks with text, a background image and nice effects. At first it was always going to be static, which was no issue at all, but later they came to me and asked if they could be able to change words in the boxes themselves in the admin section..   Of course this can be easily done by creating a table that is associated with this home page block thing and each row in the table will correspond to one of the blocks on the home page.   But I believe there might be an easier way to store this type of data without having to create another table for every feature the client wants to edit, for example they also want to be able to edit a slider on another page.   The WordPress database then came into my mind and how they store most of their data as JSON. So I was then thinking of creating a table named 'modules' for examples with three columns (id, title, data). Then inside the data column store the editable fields as a JSON string object.   For example a row could like like :   1, "Front Page Box Slider", {"slider-home" : [ {"data" : "value", "img_1", "value1"}, {"data" : "value", "img_2", "value2"} ]}   I've been doing a bit of research on this and people have just been saying, never do this if you do want your data to be searched through, which I don't.   Can anyone tell me why or why not I should do this, or maybe a better solution to my problem?   Thank you
Edited by carlosmoreeira, 17 September 2014 - 07:37 PM.