Trouble with parsing XML data from cURL POST in PHP

Question

I am working on integrating a catalog functionality to our company website that I have designed, akserigraphics.com. I can get the response from the cURL POST but I can't seem to get it to format properly to create the catalog view on the .php page.

Here is the layout that I am attempting to have the XML data populate in PHP. Below is the code that I am using and below that is the output I am receiving.

CODE

<?php
    $url = 'https://www.promoplace.com/ws/ws.dll/XMLDataStream';
    $xml_input = '<?xml version="1.0" encoding="utf-8"?>
        <XMLDataStreamRequest>
        <Ver>3.2</Ver>
        <Auth>
            <AcctID>xxx</AcctID>
            <LoginID>yyy</LoginID>
            <Password>zzz</Password>
        </Auth>
        <Search>
            <Category>Shirts</Category> <SPC>S:50042,S:50316,S:50609,S:63196,S:64202,S:69820,S:69813,S:69783,S:50007,S:50066,S:50673,S:51080,S:51118,S:51625,S:67821,S:62358,S:67591,S:66971,S:63758,S:65046,S:66312,S:67336,S:67466,S:68866</SPC>
            <QuickSearch>t-shirt</QuickSearch>
            <Sort>POPULARITY</Sort>
            <StartNum>1</StartNum>
            <MaxRecs>12</MaxRecs>
            <MaxTotalItems>2500</MaxTotalItems>
            <ExtraReturnFields>ITEMNUM</ExtraReturnFields>
        </Search>
        </XMLDataStreamRequest>';

    $ch = curl_init();

    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_VERBOSE, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/xml'));
    curl_setopt($ch, CURLOPT_POSTFIELDS, $xml_input);

    if(curl_errno($ch)) {
        echo curl_errno($ch);
        echo curl_error($ch);
    }
    else {
        $parsed = array();
        parse_str(curl_exec($ch), $parsed);
        print_r($parsed);
        curl_close($ch);
        foreach ($parsed as $value => $item): ?>
            <a href="/products/garments/t-shirts/productview/">
              <div id="shirt_<?php $item->Count; ?>'" class="portfolio-box-1 three-col-por">
                <div class="mask"></div>
                <h3><span><?php $item->ItemNum; ?></span><br><?php $item->PrName; ?></h3>
			          <img src="<?php $item->ThumbPicLink; ?>" alt="<?php $item->PrName; ?>">
              </div>
			      </a>
        <?php endforeach;        
    }
?>

OUTPUT

Array ( [ "1.0" encoding="UTF-8"?>
3.2 USE SUBJECT TO TERMS OF YOUR AGREEMENT. UNAUTHORIZED USE PROHIBITED. SUPPLIER INFORMATION IS CONFIDENTIAL. (C) 2018 QUICK TECHNOLOGIES INC. 1 1000 1 343212964 HVKQF-HAUXO
Port [amp;_Company®_5_4_Oz__100_percent_Cotton_Tee_Shirt PC54 5_02_-_7_02 http://www_promoplace_com/ws/ws_dll/QPic?SN] =>
50042 [amp;P] => 122090667 [amp;RS] =>
150 [amp;_Company®_Core_Blend_Short_Sleeve_T-Shirt PC55 5_62_-_7_62 http://www_promoplace_com/ws/ws_dll/QPic?SN] =>
50042 [amp;_Company®_Essential_T-Shirt PC61 5_96_-_7_96 http://www_promoplace_com/ws/ws_dll/QPic?SN] => 50042 )

I have been searching high and low on the internet for several days and can't seem to identify what I am doing wrong. I am only a beginner when it comes to PHP so any help would be greatly appreciated.

user9189147 · Accepted Answer · 2018-02-12 23:02:58Z

Hope this helps. You also may want to remove your API credentials from this request? If this API is restricted just for your usage? I have removed them from my answer below and replaced with ####. Also, I am using PHP's simplexml_load_string to get the response into an object for iteration. I have tested this locally and it worked. Let me know if you have any questions?

<?php
    $url = 'https://www.promoplace.com/ws/ws.dll/XMLDataStream';
    $xml_input = '<?xml version="1.0" encoding="utf-8"?>
        <XMLDataStreamRequest>
        <Ver>3.2</Ver>
        <Auth>
            <AcctID>#####</AcctID>
            <LoginID>#####</LoginID>
            <Password>#####</Password>
        </Auth>
        <Search>
            <Category>Shirts</Category> <SPC>S:50042,S:50316,S:50609,S:63196,S:64202,S:69820,S:69813,S:69783,S:50007,S:50066,S:50673,S:51080,S:51118,S:51625,S:67821,S:62358,S:67591,S:66971,S:63758,S:65046,S:66312,S:67336,S:67466,S:68866</SPC>
            <QuickSearch>t-shirt</QuickSearch>
            <Sort>POPULARITY</Sort>
            <StartNum>1</StartNum>
            <MaxRecs>12</MaxRecs>
            <MaxTotalItems>2500</MaxTotalItems>
            <ExtraReturnFields>ITEMNUM</ExtraReturnFields>
        </Search>
        </XMLDataStreamRequest>';

    $ch = curl_init();

    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_VERBOSE, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/xml'));
    curl_setopt($ch, CURLOPT_POSTFIELDS, $xml_input);

if (curl_errno($ch)) {
    echo curl_errno($ch);
    echo curl_error($ch);
} else {
    $parsed = array();
    $response = curl_exec($ch);
    $object = simplexml_load_string($response);

    curl_close($ch);
    foreach ($object -> SearchResults -> Items -> Item as $key => $item) : ?>
            <a href="/products/garments/t-shirts/productview/">
              <div id="shirt_<?php print $item->Count; ?>'" class="portfolio-box-1 three-col-por">
                <div class="mask"></div>
                <h3><span><?php print $item->ItemNum; ?></span><br><?php print $item->PrName; ?></h3>
                      <img src="<?php print $item->ThumbPicLink; ?>" alt="<?php print $item->PrName; ?>">
              </div>
                  </a>
    <?php endforeach;
}

That fixed it! Like I said, I'm a beginner so it was pretty easy for me to miss the "print" part of the code. Thank you for your help--I really appreciate it!
I need 4 more for my reputation before it gives it to you. I clicked on it so it should show up as soon as my reputation goes up.

Collectives™ on Stack Overflow

Trouble with parsing XML data from cURL POST in PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related