<?php
            echo "<div class='wrapper'>";
            echo "<div class='prvi'>";

            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "test_db_1";

            class generate_random_output{
                public static function number($length) {
                    $chars = "1234567890";
                    $clen = strlen( $chars ) - 1;
                    $result = '';
                    for($i = 0; $i < $length; $i++) {
                        $result .= $chars[mt_rand(0, $clen)];
                    }
                    return $result;
                }

                public static function text($length) {
                    $chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
                    $clen = strlen( $chars ) - 1;
                    $result = '';
                    for($i = 0; $i < $length; $i++) {
                        $result .= $chars[mt_rand(0, $clen)];
                    }
                    return $result;
                }

                public static function text_number($length) {
                    $chars = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
                    $clen = strlen( $chars ) - 1;
                    $result = '';
                    for($i = 0; $i < $length; $i++) {
                        $result .= $chars[mt_rand(0, $clen)];
                    }
                    return $result;
                }
            }

            try {
                /* Connect to database */
                $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
                $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                echo "Connected successfully to database <b>{$dbname}</b>";

                /* Prepare to input data into the table */
                $statement = $conn->prepare("INSERT INTO table_warehouse (item_ID, item_name, item_quantity, item_description) VALUES (:item_ID, :item_name, :item_quantity, :item_description)");
                $statement->bindParam(':item_ID', $item_ID);
                $statement->bindParam(':item_name', $item_name);
                $statement->bindParam(':item_quantity', $item_quantity);
                $statement->bindParam(':item_description', $item_description);

                /* Generate stupid names and values for each table cell */
                for($i = 0;$i < mt_rand(1, 10);$i++){
                    /* Check for duplicate primary keys */
                    $check = $conn->prepare("SELECT item_ID FROM table_warehouse");
                    $check->execute();
                    $result = $check->setFetchMode(PDO::FETCH_ASSOC); //Associative array
                    $result_array = $check->fetchAll();

                    $values_array = array();

                    foreach($result_array as $key => $value){
                        array_push($values_array,$value["item_ID"]);
                    }

                    $item_ID = generate_random_output::number(3);
                    while(in_array($item_ID, $values_array)) {
                        $item_ID = generate_random_output::number(3);
                    }

                    $item_name = generate_random_output::text(mt_rand(2, 10));
                    $item_quantity = generate_random_output::number(mt_rand(1, 4));
                    $item_description = generate_random_output::text(mt_rand(10, 50));
                    $statement->execute();
                }

                /* Select data and prepare the script to draw a table */
                $statement = $conn->prepare("SELECT * FROM table_warehouse");
                $statement->execute();
                $result = $statement->setFetchMode(PDO::FETCH_ASSOC); //Associative array
                $result_array = $statement->fetchAll();
            }catch(PDOException $e){
                echo "Connection failed: " . $e->getMessage();
            }

            $conn = null; //Terminate the instance

            echo ◄;

            /* Start drawing the table */
            $create_table->start_table("center");

            reset($result_array);
            $first_key_result = key($result_array);

            foreach($result_array as $key_table_outer => $value_table_outer){
                if($key_table_outer == $first_key_result) {
                    foreach($value_table_outer as $key_table_inner => $value_table_inner){
                        $cell_header = new table_display($key_table_inner);
                        $create_table->start_header();
                        $cell_header->display_value();
                        $create_table->end_header();
                    }
                }

                foreach($value_table_outer as $key_table_inner => $value_table_inner) {
                    $cell_value = new table_display($value_table_inner);
                    $last_key = key(array_slice($value_table_outer, -1, 1, TRUE ));
                    reset($value_table_outer);
                    $first_key = key($value_table_outer);
                    if($key_table_inner == $first_key){
                        $create_table->start_row();
                        $create_table->start_cell();
                        $cell_value->display_number();
                        $create_table->end_cell();
                    }elseif($key_table_inner == $last_key){
                        $create_table->start_cell();
                        $cell_value->display_number();
                        $create_table->end_cell();
                        $create_table->end_row();
                    }else{
                        $create_table->start_cell();
                        $cell_value->display_number();
                        $create_table->end_cell();
                    }
                }
            }

            $create_table->end_table();

            foreach($result_array[$first_key_result] as $key => $value){
                $create_table->start_table("left");

                $column_cut = new table_display("",$key,$result_array);
                $column = $column_cut->cut_column();

                foreach($column as $column_key => $column_value){
                    if($column_key == $first_key_result){
                        $cell_header = new table_display($key);
                        $create_table->start_header();
                        $cell_header->display_value();
                        $create_table->end_header();
                    }
                    $cell_value = new table_display($column_value);
                    $create_table->start_row();
                    $create_table->start_cell();
                    $cell_value->display_value();
                    $create_table->end_cell();
                    $create_table->end_row();
                }
                $create_table->end_table();
            }

            echo "</div>";
            echo "</div>";

            echo("</pre>");
        ?>