Tikky Tikky - 1 year ago 77
PHP Question

How to gather company data from VIES database via SOAP

I am using the VIES database to gather company data, based on European VAT number for my PHP application.

The things that I need are:

  • city

  • street name

  • house number

  • postcode

  • comapny name

as separate data but the VIES database is giving me all of it as a one string.

Working example:

try {
$opts = array(
'http' => array(
'user_agent' => 'PHPSoapClient'
$context = stream_context_create($opts);

$client = new SoapClient(
array('stream_context' => $context,
'cache_wsdl' => WSDL_CACHE_NONE)

$result = $client->checkVat(
'countryCode' => 'PL',
'vatNumber' => '5242106963'
} catch (Exception $e) {
echo $e->getMessage();

I am receiving:

stdClass Object (
[countryCode] => PL
[vatNumber] => 5242106963
[requestDate] => 2015-02-20+01:00
[valid] => 1
[address] => ANNOPOL 20 03-236 WARSZAWA

But I need the address like this:


Also please keep in mind that for other companies, the street name or city can have more then one word, like "New York", so an easy solution to divide the data based on space between words doesn't work for me.

Answer Source

As you have stated that postal code will be in 99-999 format and assuming the street number (+ any flat identification) will always start with a number, you can use a preg_match to parse the address string:

$result = new stdClass();
$result->address = 'Wita Stwosza 15 M5 31-042 Kraków';

    . '(.*?)'             // Match as many chars as possible (street)
    . '\s+(\d+(?:.*?))'   // Space, then number and possibly flat (number)
    . '\s+(\d\d\-\d\d\d)' // Space, then digits/dash/digits (postcode)
    . '\s(.*)'            // Space, then everything after that (city)
    . '#',
list ($street, $number, $postcode, $city) = array_slice($matches, 1);

echo "Street:   $street", PHP_EOL;
echo "Number:   $number", PHP_EOL;
echo "Postcode: $postcode", PHP_EOL;
echo "City:     $city", PHP_EOL;


Street:   Wita Stwosza
Number:   15 M5
Postcode: 31-042
City:     Kraków
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download