Jump to content

Parse JSON Response Array to option value


kphpm
 Share

Go to solution Solved by Ch0cu3r,

Recommended Posts

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

Link to comment
Share on other sites

What do you mean "fill it automatically in an option value"?  Are you using that array to BUILD a drop-down list and you wish to pre-select a specific one for the user?  If so, you want to put selected="selected" inside the <option> tag right next to the value.

 

If you mean something else, please elaborate.

Link to comment
Share on other sites

Hello .

i need this to fill in a dropdown, one approach i tryed was this

<?php
ini_set("display_errors",1);

include('directvps.php');

$directvps = new directvps('./test.crt','./client.key','./ca.crt');
$vpslists = $directvps->go('get_isolist');
$vpslists = json_decode($vpslists, true);
$data = $vpslists;
echo "<select name='isoid'>";
foreach($data as $iso => $name)
{
echo "<option value='$iso'>$name</option>";
}
echo "</select>";

i know i am missing the form but this was just a try to see if it populates correctly

Edited by kphpm
Link to comment
Share on other sites

  • Solution

So $directvps->go() returns a json encoded array posted in your first post? If that the case your foreach should read

foreach($data as $iso)
{
   printf"<option value='%s'>%s</option>", $iso['isoid']
                                           $iso['omschrijving']);
}
Edited by Ch0cu3r
  • Like 1
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.