php arrays for inserting into one database field

[delia]

I'm pretty sure this is more a php question than a zen cart question, but I've been wrestling with this for hours now.

I've created an array with this:

while(!$productsMagic->EOF ) {
    $productsMagicArray = array();
$productMagicArray[] = array('products_model'=>$productsMagic->fields['products_model'],
                                                        
);

$productsMagic->MoveNext();
} 

Then I want to take the results and separate them with commas to insert into another table.

The array is:

Array
(
[0] => Array
(
[products_model] => 51064
)

[1] => Array
(
[products_model] => 11111
)

)

I want to have 51064,11111 to insert in order to be able to send that to an API.

I suspect it's going to be obvious once I see it but right now I'm just missing it....

Thanks in advance for any assistance.

[delia]

A little more information might be needed.

I need to send order information to an API (this is not a payment module by the way).

Once the order is created, I get the products_model numbers out of the order - and create an array as above. There will more more info to send to the api, but their requirement is to have the model numbers as one value with each product model separated by commas.

Sorry if my terminology is a little off. I learned php from Zen Cart and don't always know what things are supposed to be called - one of the reasons for my research failure on this one.

[lhungil]

If you are only capturing the model numbers in the while loop...

$productsModelArray = array();
while(!$productsQueryResult->EOF ) {
  $productsModelArray[] = $productsQueryResult->fields['products_model'];

  $productsQueryResult->MoveNext();
}
$csvModelList = implode(',',$productsModelArray);

Otherwise alot depends upon the format you need to the data to be in for the 3rd party API... Depending upon their API (and any functions / methods you may need to call), you'll probably want to adjust how you are capturing the data in the while loop to avoid needing to "loop" through the data multiple times...

[responsivezc]

Use the following code:

$separate_with_commas = implode(',', $productMagicArray);

[delia]

Yup, and I've tried that - instead of the product model numbers it does Array,Array

Implode the first thing I tried.

Now I did have the $productsMagicArray = array(); inside the while statement but moving it outside made no difference.

[lhungil]

Yup, and I've tried that - instead of the product model numbers it does Array,Array

implode operates on a single dimensional array, such as in my example ;)

Knowing the data set you need (and how it will be used / sent) would be useful... That way the data can be manipulated in the while loop to be in a complimentary format to the later use of the data...

For example if you needed to send a csv of just model numbers... but wanted access to all fields later (and assuming model numbers are unique)...

$productsModelArray = array();
while(!$productsQueryResult->EOF ) {
  $productsModelArray[$productsQueryResult->fields['products_model']] = $productsQueryResult->fields;

  $productsQueryResult->MoveNext();
}
$csvModelList = implode(',',array_keys($productsModelArray));

[delia]

The final result will be a array sent using JSON

$saleArray[] =  array('EmailAddress'=>$selectSend->fields['EmailAddress'],
                                'FirstName'=>$selectSend->fields['FirstName'],
                                'LastName'=>$selectSend->fields['LastName'],            
                            'ProductIDs'=>$selectSend->fields['ProductIds']        
        ); 

and the ProductIDs is to be a comma separated list of the model numbers in the order.

Is there another way to pull that array to start with besides that while statement? I just need the list of model numbers from the order. (not that it matters but the query only pulls the ordered products that are in one category - not all)

[delia]

Oh, wait, I missed one thing when I tried your last suggestion and now it works. The array looks like this now and does implode. Thank you, thank you, thank you. I never ever would have come up with that on my own!
Array
(
[51064] => Array
(
[products_id] => 538
[products_model] => 51064
[master_categories_id] => 4
)

[11111] => Array
(
[products_id] => 539
[products_model] => 11111
[master_categories_id] => 4
)

)

[lhungil]

Oh, wait, I missed one thing when I tried your last suggestion and now it works. ... Thank you, thank you, thank you. ...

No problem. There are other ways to do the same thing, but glad the quick mock up was useful :)