storing API data array somehow

Question

storing API data array somehow

203 Views Asked by david cox At 02 April 2013 at 18:54

I have figured out how to insert my data array into the mysql table. (Thank you Hunsman). Im wondering if there is neater tighter code that would accomplish what im doing. I notice that the way Im doing it only lets me insert top level of array results. The array displays correctly but unable to get sub level nodes with same name.Any Recommendations? Also wanted to post for anyone having similar problem. Took me some time to just find you guys.

<?php
function upsTrack($trackingNumber) {
$data ="<?xml version=\"1.0\"?>
    <AccessRequest xml:lang='en-US'>
            <AccessLicenseNumber>AccessNumber</AccessLicenseNumber>
            <UserId>username</UserId>
            <Password>Password</Password>
    </AccessRequest>
    <?xml version=\"1.0\"?>
    <TrackRequest>
            <Request>
                    <TransactionReference>
                            <CustomerContext>
                                    <InternalKey>blah</InternalKey>
                            </CustomerContext>
                            <XpciVersion>1.0</XpciVersion>
                    </TransactionReference>
                    <RequestAction>Track</RequestAction>
            </Request>
    <TrackingNumber>$trackingNumber</TrackingNumber>    
    </TrackRequest>";
$ch = curl_init("https://www.ups.com/ups.app/xml/Track");
curl_setopt($ch, CURLOPT_HEADER, 1);
curl_setopt($ch,CURLOPT_POST,1);
curl_setopt($ch,CURLOPT_TIMEOUT, 60);
curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt ($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch,CURLOPT_POSTFIELDS,$data);
$result=curl_exec ($ch);
// echo '<!-- '. $result. ' -->';
$data = strstr($result, '<?');
$xml_parser = xml_parser_create();
xml_parse_into_struct($xml_parser, $data, $vals, $index);
xml_parser_free($xml_parser);
$params = array();
$level = array();
foreach ($vals as $xml_elem) {
if ($xml_elem['type'] == 'open') {
if (array_key_exists('attributes',$xml_elem)) {
     list($level[$xml_elem['level']],$extra) = array_values($xml_elem['attributes']);
} else {
     $level[$xml_elem['level']] = $xml_elem['tag'];
}
}
if ($xml_elem['type'] == 'complete') {
$start_level = 5;
$php_stmt = '$params';
while($start_level < $xml_elem['level']) {
     $php_stmt .= '[$level['.$start_level.']]';
     $start_level++;
}
$php_stmt .= '[$xml_elem[\'tag\']] = $xml_elem[\'value\'];';
eval($php_stmt);
}
}
curl_close($ch);
return $params;
}

if ($_POST['af0'] == 'xx1') {
if (preg_match('/^[a-z\d_]{4,80}$/i', $_POST['trackingNumber'])) {
    $cleanTrackingNumber = $_POST['trackingNumber'];
    $someArray = upsTrack("$cleanTrackingNumber");
    echo $someArray['RESPONSESTATUSDESCRIPTION'],    $someArray['SHIPPERNUMBER'],  $someArray['ADDRESSLINE1'],$someArray['CITY'],  $someArray['STATEPROVINCECODE'], $someArray['POSTALCODE'], $someArray['COUNTRYCODE'],$someArray['CODE'], $someArray['DESCRIPTION'], $someArray['VALUE'], $someArray['SHIPMENTIDENTIFICATIONNUMBER'], $someArray['PICKUPDATE'], $someArray['TRACKINGNUMBER'], $someArray['ACTIVITYLOCATION']['ADDRESS'] ['STATEPROVINCECODE'], $someArray['DATE'], $someArray['TIME'], $someArray['WEIGHT'];
} else {
    echo 'Invalid tracking number... sigh...';
}
}

?>
<?php
/*** mysql hostname ***/
$hostname = 'localhost';

/*** mysql username ***/
$username = 'testdb';

/*** mysql password ***/
$password = 'test123';

/*** database name ***/
$dbname = 'test';

try {
$dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
/*** echo a message saying we have connected ***/
echo 'Connected to database<br />';

/*** set the PDO error mode to exception ***/
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
/*** begin the transaction ***/
$dbh->beginTransaction();


/***  INSERT statements ***/
$dbh->exec("INSERT INTO upstrackdb ( RESPONSESTATUSDESCRIPTION, SHIPPERNUMBER,   ADDRESSLINE1, CITY, STATEPROVINCECODE, POSTALCODE, COUNTRYCODE, CODE, DESCRIPTION, VALUE, SHIPMENTIDENTIFICATIONNUMBER, PICKUPDATE, TRACKINGNUMBER, ACTIVITYLOCATION, DELIVERYDATE, DELIVERYTIME, WEIGHT) VALUES ( '$someArray[RESPONSESTATUSDESCRIPTION]',  '$someArray[SHIPPERNUMBER]', '$someArray[ADDRESSLINE1]', '$someArray[CITY]', '$someArray[STATEPROVINCECODE]', '$someArray[POSTALCODE]', '$someArray[COUNTRYCODE]', '$someArray[CODE]', '$someArray[DESCRIPTION]', '$someArray[VALUE]', '$someArray[SHIPMENTIDENTIFICATIONNUMBER]', '$someArray[PICKUPDATE]', '$someArray[TRACKINGNUMBER]', '$someArray[STATEPROVINCECODE]',  '$someArray[DATE]', '$someArray[TIME]', '$someArray[WEIGHT]')");

/*** commit the transaction ***/
$dbh->commit();

/*** echo a message to say the database was created ***/
echo 'Data entered successfully<br />';
}
catch(PDOException $e)
{
/*** roll back the transaction if we fail ***/
$dbh->rollback();

/*** echo the sql statement and error message ***/
echo $sql . '<br />' . $e->getMessage();
}
?>

Below are the results i get.

Original Q&A

There are 1 best solutions below

**Husman** · Answer 1 · 2013-04-02T19:09:29.097000

It sounds like you have everything you need. Parse the results, read in the list of email addresses and then INSERT them into the database (double check for duplicates first).

That array looks easily accessible. Its just a simple "INSERT INTO ... VALUES( $array['DATE'], $array['TIME'] ...)"

Heres a good intro to PDO in PHP: http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html#7.1

storing API data array somehow

There are 1 best solutions below

Related Questions in PHP

Related Questions in MYSQL

Related Questions in XML

Trending Questions

Popular # Hahtags

Popular Questions