Create an array based on array key

stublackett · January 15, 2015

Hi,

I am working on a betting API, The data comes from an XML Feed.

I am using a PHPPhar file to iterate the XML data, Seems to work really well. What I need to do now is iterate each "outcome" type and order it by the highest decimal to lowest decimal value (Best odds)

My current array of data from the XML looks like this (See pastebin for full version) :

Is it possible build an array of outcomes, Then sort by the best decimal price. (I have a function built that can convert the "currentPrice" to decimal.

Thnak You!

Barand · January 15, 2015

If you had posted the original xml then I would look at it. I am not prepared to spend all evening editing print_r() output into something that can be processed.

stublackett · January 16, 2015

If you had posted the original xml then I would look at it. I am not prepared to spend all evening editing print_r() output into something that can be processed.

Hi Barand,

Totally agree with your comment there and apologies! If I could have edited my original post I would have added a couple of things, Such as my actual PHP code.

An example of the XML feed is here

My current PHP code looks like :

foreach($array->Outcome as $outcome)
        {
            $outcometypes = $outcome->attributes();
            $outcomename = $outcometypes['name'];

            foreach($outcome->Bookmaker as $bookmaker)
            {
                $bookmakers = $bookmaker->attributes();
                $bookmaker_name = $bookmaker['name'];

                // Replace Spaces, William Hill Now = WilliamHill
                $bookmaker_name = str_replace( ' ', '', $bookmaker_name);

                foreach($bookmaker->Odds as $odds)
                {
                    $odds_types = $odds->attributes();
                    $currentprice = $odds_types['currentPrice'];
                    $decimalprice = $this->convert_decimal($currentprice);
                    $odds_types->addAttribute('decimal', $decimalprice);
                    

                    foreach($odds_types['bet'] as $bet)
                    {
                        
                    }
                }
            }
        }

Thank You!

Edited January 16, 2015 by stublackett

Barand · January 16, 2015

I don't know the output you want but this should get you on your way

$xml = new SimpleXMLElement($_xml_string);

foreach ($xml->xpath("//Outcome") as $out) {
    $oid = $out['id'];
    foreach ($out->Bookmaker as $bk) {
        $bkname = $bk['name'];
        $bklu = $bk['lastUpdate'];
        foreach ($bk->Odds as $odd) {
            $outcomes[] = array (
                'Outcome'   => (string)$oid,
                'Bookmaker' => (string)$bkname,
                'Updated'   => (string)$bklu,
                'Bet'       => (string)$odd['bet'],
                'SP'        => (string)$odd['startPrice'],
                'CP'        => (string)$odd['currentPrice'],
                'Decimal'   => convertPrice ((string)$odd['currentPrice'])
            );
        }
    }
}

function convertPrice($price) {
    list ($a,$b) = explode('/', $price);
    return $a/($a+$b);
}

function priceSort($a, $b)
{
    return strcmp($a['Decimal'], $b['Decimal']) ;
}

usort($outcomes, 'priceSort');

echo '<pre>',print_r($outcomes, true),'</pre>';

stublackett · January 16, 2015

Hi, appreciate the answer! Looks like its going to send me in the right direction. Just wondering what I set "$_xml_string" as?

stublackett · January 16, 2015

Hi Barand,

Really appreciate your help on this one. Now I have the array in some form I need, I just need to split down based on market type to then do an sort on it. This has left me with something to go off. Many Thanks!

Sign In

Create an array based on array key

Recommended Posts

stublackett

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

stublackett

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

stublackett

Link to comment

Share on other sites

stublackett

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information