PHP - Convert HTML ul list into json format

Question

I would like to convert an HTML ul list into a json format.

The html list is in this format:

<li><span class="orgname">Adams Center Free Library</span> <span class="status">Closed</span></li>

<li><span class="orgname">Weight Watchers Watertown</span> <span class="status">Delayed</span></li>

I'd like it to be in a json format like this:

{
  "meta": {
    "closed_count": "1",
    "delayed_count": "1"
  },
  "list": [
    {
      "data": {
        "orgname": "Adams Center Free Library",
        "status": "Closed"
      }
    },
    {
      "data": {
        "orgname": "Weight Watchers Watertown",
        "status": "Delayed"
      }
    }
  ]
}

Can someone help me out with this?

use this stackoverflow.com/questions/2817242/… kind of solution to get ul/li in php array the use json_encode function to get it in json formatt. — Adil Abbasi
– Adil Abbasi, Commented Sep 17, 2014 at 9:43

Justinas · Accepted Answer · 2014-09-17 09:49:23Z

0

I assume you are outputting data from some database. So add values to array and than encode to json:

$delayed = 0;
$close = 0;
$data = [];

echo "<ul>";
foreach ($myArray as $row) {
   echo "<li><span class='orgname'>{$row['orgname']}</span> <span class='status'>{$row['status']}</span></li>";
   $data[] = ['data' => ['orgmane' => $row['orgname'], 'status' => $row['status']]];
   // or if $row only has 'orgname' and 'status'
   $data[] = ['data' => $row];

   if (strtolower($row['status']) == 'delayed') {
       $delayed++;
   } else {
       $closed++;
   }
}
echo "</ul>";

json_encode(
    [
        'meta' => ['closed_count' => $closed, 'delayed_count' => $delayed],
        'list' => $data,
    ]
);

answered Sep 17, 2014 at 9:49

Justinas

43.9k5 gold badges72 silver badges108 bronze badges

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

4 Comments

Dalton Sutton Over a year ago

I love the set up of the code you provided me, however I can't use it yet. I'm actually not using a database at all. I've been forced to use a basic HTML page.

Justinas Over a year ago

@DaltonSutton Can you expand your question explaining origin of this data data and how you gonna use this json?

Dalton Sutton Over a year ago

Here is basically what I've already converted from an HTML Table into an HTML List. From the list, I wanna convert into the json feed which I can't do yet because of the foreach function. If you could help me on this, I'd appreciate it so much! snipet.co.uk/Bfh

Dalton Sutton Over a year ago

This is pretty much it. I believe there is an if statement in the link above that I forgot to delete but other than that, this is the main thing. I was planning on writing a function that counted the delayed and closed events later.

Collectives™ on Stack Overflow

PHP - Convert HTML ul list into json format

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related