<?php

    $mysql_database = "eurosale";
    $mysql_username = "eurosale";
    $mysql_password = "eurosale1test";
    $mysql_host = "localhost";

    $start = microtime(true);

    $connect = mysql_connect($mysql_host, $mysql_username, $mysql_password);

    mysql_select_db($mysql_database, $connect);

    $order_operation = isset( $_POST['order_operation'] ) ? $_POST['order_operation'] : '';

    if( $order_operation == 'add_order' )
        {

            $order_name = isset( $_POST['order_name'] ) ? $_POST['order_name'] : '';
            $order_date = date('Y-m-d H:i:s');
            $order_additional = isset( $_POST['order_additional'] ) ? $_POST['order_additional'] : '';
            $order_total = isset( $_POST['order_total'] ) ? $_POST['order_total'] : '';


            $add_order_result = mysql_query(
            "
                INSERT INTO
                    `orders` (`order_name`, `order_date`, `order_additional`, `order_total`)
                VALUES
                    ('$order_name', '$order_date', '$order_additional', '$order_total')
            "
            );

            if ($add_order_result)
                {
                    $last_id = mysql_insert_id();
                    $duration = microtime(true) - $start;
                    echo '<p>Заказ под номером «' . $last_id . '» успешно добавлен! </p>';
                    echo "<p>Время обработки запроса: " . $duration . "</p>";
                }
            else
                {

                    echo 'Ошибка запроса: ' . mysql_error();
                    exit;
                }
        }

    if( $order_operation == 'get_order' )
        {
            $order_number = isset( $_POST['order_number'] ) ? $_POST['order_number'] : '';

            $get_order_result = mysql_query(
            "
                SELECT * FROM orders WHERE id = '" . $order_number . "';
            "
            );

            if ( $get_order_result )
                {
                    $duration = microtime(true) - $start;

                    echo "<p>Время обработки запроса: " . $duration . "</p>";

                    if ( mysql_num_rows( $get_order_result ) == 0 )
                        {
                            echo '<p style="color: red;"><b>Заказ с номером не найден :(</b><p>';
                        }
                    else
                        {
                            while ( $get_order_results = mysql_fetch_assoc( $get_order_result ) )
                                {
                                    echo '<b>Информация о заказе №' . $get_order_results['id'] . '</b><br />';
                                    echo 'Название заказа: <i>' . $get_order_results['order_name'] . '</i><br />';
                                    echo 'Стоимость заказа: <i>' . $get_order_results['order_total'] . '</i><br />';
                                    echo 'Дата заказа: <i>' . $get_order_results['order_date'] . '</i><br />';
                                    echo 'Дополнительная информация: <i>' . $get_order_results['order_additional'] . '</i><br />';
                                }
                        }

                }
            else
                {
                    echo 'Ошибка запроса: ' . mysql_error();
                    exit;
                }
        }
/*
    if( $order_operation == 'get_order' )
    {
        $sql='
            CREATE TABLE clients (
                id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
                client_company VARCHAR(20),
                client_first_name VARCHAR(20),
                client_last_name VARCHAR(20),
                client_phone VARCHAR(20)
            );
            CREATE TABLE orders (
                id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
                order_name VARCHAR(50),
                order_date DATE,
                order_additional VARCHAR(200),
                order_total INT(20)
            );
        ';
    }
*/

    mysql_close($connect);

?>