How to change json_encode API format laravel?

Question

code:

$prop_map = DB::table('jk_property_map_jpm')->select('jpm_location','jpm_longitude','jpm_latitude')->where('jpm_location','like','%'.$par2.'%')->get();
foreach($prop_map as $k)
{
    $array = array(
                    $k->jpm_location,
                    $k->jpm_latitude,
                    $k->jpm_longitude
                    );
    $data['map'] = json_encode($array);
    echo $data['map'];
}

API:

[
  "California Frazier Park 93222 15501 Nesthorn Way",
  "34.852633",
  "-119.149963"
][
  "Oakhurst,Gold Country,California,United States",
  "37.3392607",
  "-119.7114921"
][
  "Club de Golf Fonatur, San Jos\u00c3\u00a9 del Cabo, Baja California Sur, Mexico",
  "23.0522956",
  "-109.6987974"
]

In this code I am simply used json_encode to create an API and here I am getting unexpected output as I mention above. I want data as mention below:

[   
    [
      "California Frazier Park 93222 15501 Nesthorn Way",
      "34.852633",
      "-119.149963"
    ],
    [
      "Oakhurst,Gold Country,California,United States",
      "37.3392607",
      "-119.7114921"
    ],
    [
      "Club de Golf Fonatur, San Jos\u00c3\u00a9 del Cabo, Baja California Sur, Mexico",
      "23.0522956",
      "-109.6987974"
    ]
]

So, How can I create like this? Please help me.

Thank You

Salim Djerbouh · Accepted Answer · 2019-08-28 09:54:44Z

1

Use laravel collection mapping function to format and return your results instead of iterating via loop and echoing out

$prop_map = DB::table('jk_property_map_jpm')->select('jpm_location','jpm_longitude','jpm_latitude')->where('jpm_location','like','%'.$par2.'%')->get();
$prop_map = $prop_map->map(function ($k) {
        return [
            $k->jpm_location,
            $k->jpm_latitude,
            $k->jpm_longitude, // viva trailing commas
            ];
    });
return $prop_map; // laravel automatically serializes arrays to JSON

answered Aug 28, 2019 at 9:54

Salim Djerbouh

11.1k6 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

omkara Over a year ago

Thank you @Caddy DZ. I had a problem man i.e. I put $prop_map in $data like this $data['locations'] = $prop_map in my view file like {{ $location }} then it show " instead of double quots ` " ` So, How can I fix them?

Salim Djerbouh Over a year ago

Tha's because Blade echo directive {{ }} uses html_escape so you would have to trim the quotes in your php code before it reaches the view i.e trim($location, '"');

omkara Over a year ago

In case of jquery what will I do @Caddy DZ

Salim Djerbouh Over a year ago

In plain JS location.replace(/\"/g, "")

omkara Over a year ago

look I am fetching like var data = {{ $location }} and I am trying to replace " with " but nothing happen

|

Script47 · Accepted Answer · 2019-08-28 09:38:36Z

1

You can use array_values to turn your associative array into a numeric array.

Change,

$data['map'] = json_encode($v);

To,

$data['map'] = json_encode(array_values($v));

answered Aug 28, 2019 at 9:38

Script47

14.6k4 gold badges49 silver badges69 bronze badges

1 Comment

omkara Over a year ago

look my code once again I have changes something in my code @Script47

Collectives™ on Stack Overflow

How to change json_encode API format laravel?

2 Answers 2

8 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Linked

Related