Loop PHP Multidimensional Array and insert into MySQL

Hi All,

Having a heck of a time looping through a multidimensional array so I can insert values into a MySQL database.  I have read through foreach and it's just not sinking in (Coldfusion guy, sorry!)

I'm consuming a NuSOAP resource, and I'm getting a multidimensional array back.  I need to be able to loop each returned "record" and populate a MySQL table with the values.  This is the response I'm getting (print_r):

Array
(
    [count] => 1
    [data] => Array
        (
            [0] => Array
                (
                    [accountName] => Test User
                    [accountRef] => 24281.0.5672027
                    [attachments] => 
                    [createdDate] => 2014-02-26T21:43:32.796Z
                    [date] => 2014-02-26T05:00:00.000Z
                    [definedValues] => Array
                        (
                            [0] => Array
                                (
                                    [dataType] => 0
                                    [displayType] => 1
                                    [fieldName] => Reason 
                                    [fieldRef] => 24281.0.5693551
                                    [value] => General Use
                                    [valueRef] => 24281.0.5709983
                                )

                            [1] => Array
                                (
                                    [dataType] => 0
                                    [displayType] => 1
                                    [fieldName] => Type
                                    [fieldRef] => 24281.0.5686363
                                    [value] => Guest
                                    [valueRef] => 24281.0.5686365
                                )

                            [2] => Array
                                (
                                    [dataType] => 0
                                    [displayType] => 1
                                    [fieldName] => Room 
                                    [fieldRef] => 24281.0.5685410
                                    [value] => Training Room
                                    [valueRef] => 24281.0.5685412
                                )

                            [3] => Array
                                (
                                    [dataType] => 1
                                    [displayType] => 0
                                    [fieldName] => Check in Date
                                    [fieldRef] => 24281.0.5694549
                                    [value] => 2/25/2014
                                    [valueRef] => 24281.0.7318589
                                )

                            [4] => Array
                                (
                                    [dataType] => 1
                                    [displayType] => 0
                                    [fieldName] => Check Out Date
                                    [fieldRef] => 24281.0.5685368
                                    [value] => 2/26/2014
                                    [valueRef] => 24281.0.7318587
                                )

                            [5] => Array
                                (
                                    [dataType] => 1
                                    [displayType] => 0
                                    [fieldName] => Date Placed on Waiting List
                                    [fieldRef] => 24281.0.5685388
                                    [value] => 2/14/2014
                                    [valueRef] => 24281.0.7318588
                                )

                            [6] => Array
                                (
                                    [dataType] => 0
                                    [displayType] => 1
                                    [fieldName] => Guest Type
                                    [fieldRef] => 24281.0.5684375
                                    [value] => Vendor
                                    [valueRef] => 24281.0.5684377
                                )

                        )

                    [final] => 
                    [immutable] => 
                    [lastModifiedDate] => 2014-02-28T21:34:11.956Z
                    [note] => Guest
                    [ref] => 24281.0.7156819
                    [type] => 1
                )

        )

    [pages] => 1
    [start] => 0
    [total] => 1
    [usedCache] => 
)

Open in new window


For each returned record, I need to populate columns for accountName, createdDate, reason, type, room, checkInDate, checkOutDate, waitingListDate, and guestType.

The subarrays might not always be in the same order, depending on what is filled out in the web application and what is not, so I have to do some sort of check --> if fieldName = 'whatever' set thisValue = value.

Any help would be greatly appreciated!
LVL 1
Carlos ElguetaIT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Ray PaseurCommented:
<?php // demo/temp_newcoit.php
error_reporting(E_ALL);


// SEE http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28380000.html


/**
 * For each returned record, I need to populate columns for accountName, createdDate, reason, type, room, checkInDate, checkOutDate, waitingListDate, and guestType.
 */

// TEST DATA FROM THE POST AT EE
$soap = Array(
    'count' => '1',
    'data'  => Array(
            '0' => Array(
                    'accountName' => 'Test User',
                    'accountRef'  => '24281.0.5672027',
                    'attachments' => '',
                    'createdDate' => '2014-02-26T21:43:32.796Z',
                    'date'        => '2014-02-26T05:00:00.000Z',
                    'definedValues' => Array(
                            '0' => Array(
                                    'dataType' => '0',
                                    'displayType' => '1',
                                    'fieldName' => 'Reason',
                                    'fieldRef' => '24281.0.5693551',
                                    'value' => 'General Use',
                                    'valueRef' => '24281.0.5709983',
                                ),
                            '1' => Array(
                                    'dataType' => '0',
                                    'displayType' => '1',
                                    'fieldName' => 'Type',
                                    'fieldRef' => '24281.0.5686363',
                                    'value' => 'Guest',
                                    'valueRef' => '24281.0.5686365',
                                ),
                            '2' => Array(
                                    'dataType' => '0',
                                    'displayType' => '1',
                                    'fieldName' => 'Room ',
                                    'fieldRef' => '24281.0.5685410',
                                    'value' => 'Training Room',
                                    'valueRef' => '24281.0.5685412',
                                ),
                            '3' => Array(
                                    'dataType' => '1',
                                    'displayType' => '0',
                                    'fieldName' => 'Check in Date',
                                    'fieldRef' => '24281.0.5694549',
                                    'value' => '2/25/2014',
                                    'valueRef' => '24281.0.7318589',
                                ),
                            '4' => Array(
                                    'dataType' => '1',
                                    'displayType' => '0',
                                    'fieldName' => 'Check Out Date',
                                    'fieldRef' => '24281.0.5685368',
                                    'value' => '2/26/2014',
                                    'valueRef' => '24281.0.7318587',
                                ),
                            '5' => Array(
                                    'dataType' => '1',
                                    'displayType' => '0',
                                    'fieldName' => 'Date Placed on Waiting List',
                                    'fieldRef' => '24281.0.5685388',
                                    'value' => '2/14/2014',
                                    'valueRef' => '24281.0.7318588',
                                ),
                            '6' => Array(
                                    'dataType' => '0',
                                    'displayType' => '1',
                                    'fieldName' => 'Guest Type',
                                    'fieldRef' => '24281.0.5684375',
                                    'value' => 'Vendor',
                                    'valueRef' => '24281.0.5684377',
                                ),
                        ),
                    'final' => '',
                    'immutable' => '',
                    'lastModifiedDate' => '2014-02-28T21:34:11.956Z',
                    'note' => 'Guest',
                    'ref' => '24281.0.7156819',
                    'type' => '1',
                ),
        ),
    'pages' => '1',
    'start' => '0',
    'total' => '1',
    'usedCache' => NULL,
)
;

// DOES IT LOOK RIGHT?
echo '<pre>';
print_r($soap);

// POPULATE THE FIELDS
$data = $soap['data'][0];
$qry = new StdClass;

// accountName
$qry->accountName = $data['accountName'];

// createdDate
$qry->createdDate = $data['createdDate'];

// reason
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Reason') continue;
    $qry->reason = $arr['value'];
    break;
}

// type
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Type') continue;
    $qry->type = $arr['value'];
    break;
}

// room
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Room') continue;
    $qry->room = $arr['value'];
    break;
}

// checkInDate
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Check in Date') continue;
    $qry->checkInDate = $arr['value'];
    break;
}

// checkOutDate
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Check Out Date') continue;
    $qry->checkOutDate = $arr['value'];
    break;
}

// waitingListDate
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Date Placed on Waiting List') continue;
    $qry->waitingListDate = $arr['value'];
    break;
}

// guestType
foreach ($data['definedValues'] as $arr)
{
    if ($arr['fieldName'] != 'Guest Type') continue;
    $qry->guestType = $arr['value'];
    break;
}

// HAVE WE GOT THEM ALL?  YES.
print_r($qry);

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
Carlos ElguetaIT ManagerAuthor Commented:
That is fantastic!  And fast!

Dumb question though - I need to loop the top level also.  What would that syntax look like?  And where do I declare the index? (Meaning how do I change $data = $soap['data'][0] to be $data = $soap['data'][x] depending on the number of top level records returned?


Thank you so much for your help!
0
Ray PaseurCommented:
Yes, I think you're on firm ground there.  Something like foreach ($soap['data'] as $data) {
1
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Carlos ElguetaIT ManagerAuthor Commented:
great - thank you.
0
Carlos ElguetaIT ManagerAuthor Commented:
Perfect.
0
Ray PaseurCommented:
Thanks for the points and thanks for using EE, ~Ray
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.