ASP, PHP, or XML Question

We need to create XML parsing. Company XYZ has developed a program for us to use. We are supposed to have replicated sites and Company XYZ controls the backend database. We have to create something to get their data. We have to program a code to pull the url to get a repid(user id)  from the rename(user name), and the repid has to imported into the website so that the repid can be associated to an iframe and edi.asp calls.

Example: http://mywebsite.com/myname myname has to be pulled from the url, get the associated repid, then associate a name, email, order data, and such with it. After the data is pulled in storage, we needto hold it storage and use it later that session in an iframe or page to associate repid with sales, signups, and pull contact info into a page.
The edi.asp link points to XML data. We need to extract that that based on repid and display it into a webpage and associate sales to distributor that sent them to the site.
Sample url we have to extract xml data from. http://shop.mywebsite.com/EDI.asp?companyid=111&apikey=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa&type=countries (numbers have been changed for security)
here is a sample code they sent us:
VBScript as your scripting language: Can this be translated from asp to PHP in order to use on a linux server to get the xml data from a sql database using asp.net?

VBScript as your scripting language:
 
            function fcnGetXML(RepURL) 
 
                        DataToSend = "companyid=111&apikey=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA&type=reps&sitename=" & RepURL
                        servername = cstr(request.ServerVariables("Server_Name"))
 
                        postUrl = "http://subdomain.mywebsite.com/EDI.asp"
 
                        'Set url to send request to including web service name.
 
                        postUrl = postUrl                  
 
                        Set xmlhttp = server.Createobject("MSXML2.XMLHTTP")
 
                        'Prepare request header.
 
                        xmlhttp.Open "POST",postUrl,false
 
                        xmlhttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"                      
 
                        'Send request:
 
                        xmlhttp.send DataToSend
 
                        If cstr(xmlhttp.Status) = "200" then
 
                                    'Success, parse result
 
                                    fcnGetXML = xmlhttp.responseText
 
                        Else
 
                                    'failure handle failure
 
                                    fcnGetXML = "0"
 
                        End if
 
            end function

Open in new window

itsmedttAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

golfDoctorCommented:
0
Ray PaseurCommented:
This teaches the way to translate your function into PHP.  HTH, ~Ray
<?php // RAY_temp_fcnGetXML.php with PHP as your scripting language:
error_reporting(E_ALL);
 
// DECLARE THE FUNCTION
function fcnGetXML($RepURL)
{
// THE SITE WE WANT TO TALK TO
    $server_url  = "subdomain.mywebsite.com";
 
// THE PAGE INSIDE THE WEB SITE
    $request_uri = "/EDI.asp";
 
// THE POST DATA THAT WE WANT TO SEND
    $dat = array(
      'companyid' => '111',
      'apikey'    => 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA',
      'type'      => 'reps',
      'sitename'  => $RepURL
     );
 
// CONSTRUCT THE POST STRING URLENCODED AND SEPARATED BY AMPERSANDS
    $postdata  = '';
    foreach ($dat as $key => $val)
    {
        $postdata .= '&' . $key . '=' . urlencode($val);
    }
    $postdata = ltrim($postdata, '&');
 
// CONSTRUCT THE HEADERS
    $header = '';
    $header .= "POST $request_uri HTTP/1.0\r\n";
    $header .= "Content-Type: application/x-www-form-urlencoded\r\n";
    $header .= "Content-Length: " . strlen($postdata) . "\r\n\r\n";
 
// SHOW WHAT WE ARE GOING TO DO - OMIT THIS SEGMENT IN PRODUCTION CODE
    echo "<pre>\n";
    echo "REQUEST DATA FOLLOWS:\n";
    var_dump($server_url);
    var_dump($request_uri);
    var_dump($postdata);
    var_dump($header);
    echo "</pre>\n";
 
 
// OPEN THE SOCKET TO THE PAGE
    $fp = fsockopen ($server_url, 80, $errno, $errstr, 30);
 
// TEST FOR VERIFICATION
    if (!$fp)
    {
        die("HTTP ERROR $server_url $request_uri fsockopen() FAILED ERRNO=$errno ERRSTR=$errstr");
    }
 
// HTTP OPEN - WRITE HEADER AND REQUEST
    fputs ($fp, $header . $postdata);
 
// HTTP OPEN - READ RESPONSE
    $reply = '';
    while (!feof($fp))
    {
        $reply .= fgets($fp, 1024);
    }
 
// SEE WHAT THE FOREIGN SITE SAID  - OMIT THIS SEGMENT IN PRODUCTION CODE
    echo "<pre>\n";
    echo htmlentities($reply);
    echo "</pre>\n";
 
// RETURN THE DATA
    return $reply;
 
} // END OF FUNCTION
 
 
// SAMPLE CALLING SEQUENCE
$rep_identity = 'Billy';
$xml_response = fcnGetXML($rep_identity);
echo $xml_response;

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
itsmedttAuthor Commented:
Thanks for your replies. Let me check these out and I will get back to you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.