How get value from json_encoded formate using PHP?

Asked Aug 20 '18 at 13:30

Active Aug 20 '18 at 13:34

Viewed 34 times

In the MySQL table, I have 3 column which is tour_from, tour_to, and pickup.

I have saved these value as json_encode formate.

tour_from

[["one","three","five"],["seven","nine","eleven"],["thirteen","fifteen","seventeen"]]

tour_to

[["two","four","six"],["eight","ten","twelve"],["fourteen","sixten","eighteen"]]

pickup

[["01:00","01:00","01:00"],["01:00","01:00","01:00"],["01:00","01:00","01:00"]]

Now I want to output the these as below:

one        two       01:00
thre       four      01:00
five       six       01:00
seven      eight     01:00
nine       ten       01:00
eleven     twelve    01:00
thirteen   fourteen  01:00
fifteen    sixteen   01:00
seventeen  eighteen  01:00

I can output the tour_from value but can't output the other 2 column value

$from             =  json_decode($data['tour_from'], true);
$to               =  json_decode($data['tour_to'], true);
$pickup           =  json_decode($data['pickup'], true);

foreach ($from[$gKey] as $key1 => $value1) {

$html .=<<<EOD
    <tr>
        <td>From</td>
        <td>$value1</td>
        <td>To</td>
        <td>$to[$gKey][$key1]</td>
        <td>Pickup</td>
        <td></td>
    </tr>

EOD;    
}

My head is going to break but can't find the way :(

Visual Output:

edited Aug 20 '18 at 13:34

asked Aug 20 '18 at 13:30

Shibbir

1,963
2
25
48

Where is the $data array being formed (that you're using json_decode on)? – Adam Aug 20 '18 at 13:32
Have you tried *helping* PHP to decide where variable ends with `{$to[$gKey][$key1]}` – Justinas Aug 20 '18 at 13:33
1

maybe cut down on useless complexity ... – Martin Zeitler Aug 20 '18 at 13:33
Not sure how you create those 3 JSON's but I am sure there must be a better way – RiggsFolly Aug 20 '18 at 13:34
@Justinas I have used but ti's showing me this error: Notice: Array to string conversion in D:\xampp\htdocs\freelancer\job\process\download.php on line 17 – Shibbir Aug 20 '18 at 13:35
@MartinZeitler may be you are right :( – Shibbir Aug 20 '18 at 13:35
@RiggsFolly Yes, may be :( – Shibbir Aug 20 '18 at 13:36
@RiggsFolly caching responses which won't change much in the file-system would probably make more sense, than to request them from a database, in order to `json_decode()` them. – Martin Zeitler Aug 20 '18 at 13:36
I have live url if you want then I can share with you. – Shibbir Aug 20 '18 at 13:36
think about restructuring how you safe your data... – Jeff Aug 20 '18 at 13:36
Strange!!!!!: Using `var_dump($to[$gKey][$key1]);` it's showing D:\xampp\htdocs\.....\download.php:175:string 'two' (length=3) – Shibbir Aug 20 '18 at 13:45
but when I use $to[$gKey][$key1] it's showing array to string conversation error message :( :( :( – Shibbir Aug 20 '18 at 13:46
@TarasV I don't understand. – Shibbir Aug 20 '18 at 13:47
1

https://repl.it/repls/RunnyPlumpCallback – TsV Aug 20 '18 at 13:53
@TarasV Yes, it's showing output. – Shibbir Aug 20 '18 at 14:55

How get value from json_encoded formate using PHP?

0 Answers0