Extract JSON from HTML using PHP

Trying to extract specific data from json directly with regexp is normally always a bad idea due to the way json is encoded. The best way is to regexp the whole json data, then decode using the php function json_decode.

The issue with the missing data is due to a missing required cookie. See my comments in the code below.

<?php

function getHtmlFromDresslinkUrl($url)
{
    $ch = curl_init();
    curl_setopt($ch,CURLOPT_URL,$url);
    curl_setopt($ch,CURLOPT_RETURNTRANSFER,true);

    //You must send the currency cookie to the website for it to return the json you want to scrape
    curl_setopt($ch, CURLOPT_HTTPHEADER, array(
        'Cookie: currencies_code=USD;',
    ));

    $output=curl_exec($ch);

    curl_close($ch);
    return $output;
}

$html = getHtmlFromDresslinkUrl("http://www.dresslink.com/womens-candy-color-basic-coat-slim-suit-jacket-blazer-p-8131.html");

//Get the specific arguments for this js function call only
$items = preg_match("/DL\.items\_list\.initItemAttr\((.+)\)\;/", $html, $matches);
if (count($matches) > 0) {
    $arguments = $matches[1];

    //Split by argument seperator.  
    //I know, this isn't great but it seems to work.
    $args_array = explode(", ", $arguments);

    //You need the 5th argument
    $fourth_arg = $args_array[4];

    //Strip quotes
    $fourth_arg = trim($fourth_arg, "'");

    //json_decode
    $qty_data = json_decode($fourth_arg, true);

    //Then you can work with the php array
    foreach ($qty_data as $name => $qtty) {
        echo "Found " . $qtty . " of " . $name . "<br />";
    }
}

?>

Special thanks to @chris85 for making me read the question again. Sorry but I couldn't undo my downvote.

You will want to use preg_match_all() to perform the regex matching operation (documentation here).

The following should do it for you. It will match each substring beginning with "sku" and ending with ",".

preg_match_all("/sku\-.+?:[0-9]*/", $input)

Working example here.

Alternatively, if you want to extract the entire string, you can use:

preg_match_all("/{.sku\-.*}/, $input")

This will grab everything between the opening and closing brackets.

Working example here.

Please note that $input denotes the input string.

A simple /'(\{"[^\}]+\})'/ will match all these JSON strings. Demo: https://regex101.com/r/wD5bO4/2

The first element of the returned array will contain the JSON string for json_decode:

preg_match_all ("/'(\{\"[^\}]+\})'/", $html, $matches);

$html is the HTML to be parsed, the JSON will be in $matches[0][1], $matches[1][1], $matches[2][1] etc.