Add an unknown number of strings to DynamoDB

Question

In my PHP script, I get a POST reaction from an HTML form. One of the texts, is a list of things, separated by a comma (for example: "apple, banana, orange").

I want to upload this text, among with other texts which got POSTed to a table on Amazon DynamoDB, but I don't want to upload it as a string, but as a string set (for example: ["apple", "banana", "orange"]).

Now, I know how to split the string:

$list = "apple, banana, orange";
$fruits = explode(", ", $list);
echo $fruits[0]; // apple
echo $fruits[1]; // banana
echo $fruits[2]; // orange

And, I also know how to upload a string array to DynamoDB:

$sdk = new Aws\Sdk([
    'region'   => 'us-west-2',
    'version'  => 'latest'
]);

$dynamodb = $sdk->createDynamoDb();

$response = $dynamodb->putItem([
    'TableName' => 'ProductCatalog',
    'Item' => [
        'Id'       => ['N'      => '104'      ], // Primary Key
        'Title'    => ['S'      => 'Book 104 Title' ],
        'ISBN'     => ['S'      => '111-1111111111' ],
        'Price'    => ['N'      => '25' ],
        'Authors'  => ['SS'  => [$authorA, $authorB] ]
                ]
]);

But, how to upload the strings, if I don't know the exact number?

If I knew the number of items then it would be like:

'Fruits' => ['SS' => [$fruits[0], $fruits[1], $fruits[2]]

But the problem is that I don't know.
How can I upload the string array to DynamoDB although I don't know the exact number of strings in the array?

Are you sure this won't work: 'Fruits' => ['SS' => $fruits]? — xtx
– xtx, Commented Mar 10, 2017 at 9:31
@xtx I don't know. I saw this code on AWS website. I'll check it now. — Ido Naveh
– Ido Naveh, Commented Mar 10, 2017 at 9:31

LuFFy · Accepted Answer · 2017-03-10 13:12:40Z

1

You can directly use $fruits as value as below :

 $response = $dynamodb->putItem([
 ....
 ....
 'Fruits' => ['SS' => $fruits]

It is already an array, So it will be automatically stored as document / json structure.

answered Mar 10, 2017 at 13:12

LuFFy

9,37310 gold badges43 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add an unknown number of strings to DynamoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related