Subversion-Projekte lars-tiefland.php_share

<?php
/*
 * Copyright 2010-2012 Amazon.com, Inc. or its affiliates. All Rights Reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License").
 * You may not use this file except in compliance with the License.
 * A copy of the License is located at
 *
 *  http://aws.amazon.com/apache2.0
 *
 * or in the "license" file accompanying this file. This file is distributed
 * on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either
 * express or implied. See the License for the specific language governing
 * permissions and limitations under the License.
 */

/*
        PREREQUISITES:
        In order to run this sample, I'll assume a few things:

        * You already have a valid Amazon Web Services developer account, and are
          signed up to use Amazon SimpleDB <http://aws.amazon.com/simpledb>.

        * You already understand the fundamentals of object-oriented PHP.

        * You've verified that your PHP environment passes the SDK Compatibility Test.

        * You've already added your credentials to your config.inc.php file, as per the
          instructions in the Getting Started Guide.

        TO RUN:
        * Run this file on your web server by loading it in your browser. It will generate HTML output.
*/


/*%******************************************************************************************%*/
// SETUP

        // Enable full-blown error reporting. http://twitter.com/rasmus/status/7448448829
        error_reporting(-1);

        // Set HTML headers
        header("Content-type: text/html; charset=utf-8");

        // Include the SDK
        require_once '../sdk.class.php';


/*%******************************************************************************************%*/
// ADD DATA TO SIMPLEDB

        // Instantiate the AmazonSDB class
        $sdb = new AmazonSDB();

        // Store the name of the domain
        $domain = 'php-sdk-getting-started';

        // Create the domain
        $new_domain = $sdb->create_domain($domain);

        // Was the domain created successfully?
        if ($new_domain->isOK())
        {
                // Add a batch of item-key-values to your domain
                $add_attributes = $sdb->batch_put_attributes($domain, array(
                        'Item_01' => array(
                                'Category'    => 'Clothes',
                                'Subcategory' => 'Sweater',
                                'Name'        => 'Cathair Sweater',
                                'Color'       => 'Siamese',
                                'Size'        => array('Small', 'Medium', 'Large')
                        ),
                        'Item_02' => array(
                                'Category'    => 'Clothes',
                                'Subcategory' => 'Pants',
                                'Name'        => 'Designer Jeans',
                                'Color'       => 'Paisley Acid Wash',
                                'Size'        => array('30x32', '32x32', '32x34')
                        ),
                        'Item_03' => array(
                                'Category'    => 'Clothes',
                                'Subcategory' => 'Pants',
                                'Name'        => 'Sweatpants',
                                'Color'       => array('Blue', 'Yellow', 'Pink'),
                                'Size'        => 'Large',
                                'Year'        => array('2006', '2007')
                        ),
                        'Item_04' => array(
                                'Category'    => 'Car Parts',
                                'Subcategory' => 'Engine',
                                'Name'        => 'Turbos',
                                'Make'        => 'Audi',
                                'Model'       => 'S4',
                                'Year'        => array('2000', '2001', '2002')
                        ),
                        'Item_05' => array(
                                'Category'    => 'Car Parts',
                                'Subcategory' => 'Emissions',
                                'Name'        => 'O2 Sensor',
                                'Make'        => 'Audi',
                                'Model'       => 'S4',
                                'Year'        => array('2000', '2001', '2002')
                        ),
                ));

                // Were the attributes added successfully?
                if ($add_attributes->isOK())
                {
                        // Add an additional size to Item_01
                        $append_attributes = $sdb->put_attributes($domain, 'Item_01', array(
                                'Size' => 'Extra Large'
                        ));

                        // Were the new attributes appended successfully?
                        if ($append_attributes->isOK())
                        {
                                // Use a SELECT expression to query the data.
                                // Notice the use of backticks around the domain name.
                                $results = $sdb->select("SELECT * FROM `{$domain}` WHERE Category = 'Clothes'");

                                // Get all of the <Item> nodes in the response
                                $items = $results->body->Item();

                                // Re-structure the data so access is easier (see helper function below)
                                $data = reorganize_data($items);

                                // Generate <table> HTML from the data (see helper function below)
                                $html = generate_html_table($data);
                        }
                }
        }


/*%******************************************************************************************%*/
// HELPER FUNCTIONS

        function reorganize_data($items)
        {
                // Collect rows and columns
                $rows = array();
                $columns = array();

                // Loop through each of the items
                foreach ($items as $item)
                {
                        // Let's append to a new row
                        $row = array();
                        $row['id'] = (string) $item->Name;

                        // Loop through the item's attributes
                        foreach ($item->Attribute as $attribute)
                        {
                                // Store the column name
                                $column_name = (string) $attribute->Name;

                                // If it doesn't exist yet, create it.
                                if (!isset($row[$column_name]))
                                {
                                        $row[$column_name] = array();
                                }

                                // Append the new value to any existing values
                                // (Remember: Entries can have multiple values)
                                $row[$column_name][] = (string) $attribute->Value;
                                natcasesort($row[$column_name]);

                                // If we've not yet collected this column name, add it.
                                if (!in_array($column_name, $columns, true))
                                {
                                        $columns[] = $column_name;
                                }
                        }

                        // Append the row we created to the list of rows
                        $rows[] = $row;
                }

                // Return both
                return array(
                        'columns' => $columns,
                        'rows' => $rows,
                );
        }

        function generate_html_table($data)
        {
                // Retrieve row/column data
                $columns = $data['columns'];
                $rows = $data['rows'];

                // Generate shell of HTML table
                $output = '<table cellpadding="0" cellspacing="0" border="0">' . PHP_EOL;
                $output .= '<thead>';
                $output .= '<tr>';
                $output .= '<th></th>'; // Corner of the table headers

                // Add the table headers
                foreach ($columns as $column)
                {
                        $output .= '<th>' . $column . '</th>';
                }

                // Finish the <thead> tag
                $output .= '</tr>';
                $output .= '</thead>' . PHP_EOL;
                $output .= '<tbody>';

                // Loop through the rows
                foreach ($rows as $row)
                {
                        // Display the item name as a header
                        $output .= '<tr>' . PHP_EOL;
                        $output .= '<th>' . $row['id'] . '</th>';

                        // Pull out the data, in column order
                        foreach ($columns as $column)
                        {
                                // If we have a value, concatenate the values into a string. Otherwise, nothing.
                                $output .= '<td>' . (isset($row[$column]) ? implode(', ', $row[$column]) : '') . '</td>';
                        }

                        $output .= '</tr>' . PHP_EOL;
                }

                // Close out our table
                $output .= '</tbody>';
                $output .= '</table>';

                return $output;
        }


?><!DOCTYPE html>
<html>
        <head>
                <meta http-equiv="Content-type" content="text/html; charset=utf-8">
                <title>sdb_create_domain_data</title>
                <style type="text/css" media="screen">
                body {
                        margin: 0;
                        padding: 0;
                        font: 14px/1.5em "Helvetica Neue", "Lucida Grande", Verdana, Arial, sans;
                        background-color: #fff;
                        color: #333;
                }
                table {
                        margin: 50px auto 0 auto;
                        padding: 0;
                        border-collapse: collapse;
                }
                table th {
                        background-color: #eee;
                }
                table td,
                table th {
                        padding: 5px 10px;
                        border: 1px solid #eee;
                }
                table td {
                        border: 1px solid #ccc;
                }
                </style>
        </head>
        <body>

                <!-- Display HTML table -->
                <?php echo $html; ?>

        </body>
</html>