Item.php

<?php

    if(isset($_GET['number'])) {

        //Include database configuration file
        include('vendors/php/dbConfig.php');

        // Check connection
        if ($db->connect_error) {
            die('Connection failed: ' . $db->connect_error);
        }


        $sql = "
            SELECT
                number,
                image1,
                image2,
                wt,
                length,
                width,
                CASE
                    WHEN stonelab1 = '' THEN 'Not Certified'
                    ELSE stonelab1
                END AS 'stonelab1',
                CASE
                    WHEN stonelab2 = '' THEN ''
                    ELSE stonelab2
                END AS 'stonelab2',
                CASE
                    WHEN stonelab3 = '' THEN ''
                    ELSE stonelab3
                END AS 'stonelab3',
                CASE
                    WHEN stonelab4 = '' THEN ''
                    ELSE stonelab4
                END AS 'stonelab4',
                CASE
                    WHEN stoneshape = 'CU' THEN 'Cushion'
                    WHEN stoneshape = 'OV' THEN 'Oval'
                    WHEN stoneshape = 'RD' THEN 'Round'
                    WHEN stoneshape = 'EC' THEN 'Emerald Cut'
                    WHEN stoneshape = 'RA' THEN 'Radiant Cut'
                    WHEN stoneshape = 'PS' THEN 'Pear Shape'
                    WHEN stoneshape = 'HS' THEN 'Heart Shape'
                    WHEN stoneshape = 'CC' THEN 'Cabochon'
                    WHEN stoneshape = 'PR' THEN 'Princess Cut'
                    WHEN stoneshape = 'ST' THEN 'Star'
                    WHEN stoneshape = 'CE' THEN 'Cats Eye'
                    WHEN stoneshape = 'TI' THEN 'Trillion'
                    WHEN stoneshape = 'OTH' THEN 'Other'
                    ELSE 'n/a'
                END AS 'stoneshape',
                CASE
                    WHEN stonecolor = 'BL' THEN 'Blue'
                    WHEN stonecolor = 'PK' THEN 'Pink'
                    WHEN stonecolor = 'PH' THEN 'Peach'
                    WHEN stonecolor = 'PU' THEN 'Purple'
                    WHEN stonecolor = 'YL' THEN 'Yellow'
                    WHEN stonecolor = 'OR' THEN 'Orange'
                    WHEN stonecolor = 'RE' THEN 'Red'
                    WHEN stonecolor = 'WH' THEN 'White'
                    WHEN stonecolor = 'GR' THEN 'Green'
                    WHEN stonecolor = 'OTH' THEN 'Other'
                    ELSE 'n/a'
                END AS 'stonecolor',
                CASE
                    WHEN stonetype = 'SA' THEN 'Sapphire'
                    WHEN stonetype = 'RU' THEN 'Ruby'
                    WHEN stonetype = 'TML-P' THEN 'Paraiba'
                    WHEN stonetype = 'EM' THEN 'Emerald'
                    WHEN stonetype = 'TS' THEN 'Tsavorite'
                    WHEN stonetype = 'SI' THEN 'Spinel'
                    WHEN stonetype = 'GT' THEN 'Garnet'
                    WHEN stonetype = 'BER' THEN 'Beryl'
                    WHEN stonetype = 'TML' THEN 'Tourmaline'
                    WHEN stonetype = 'KO' THEN 'Kornerupine'
                    ELSE 'n/a'
                END AS 'stonetype',
                CASE
                    WHEN enhcode = 'H' THEN 'Heated'
                    WHEN enhcode = 'N' THEN 'Unheated'
                    ELSE 'n/a'
                END AS 'enhcode'
            FROM
                stones
            WHERE
                number = " . $_GET['number']. "
        ";

        $result = $db->query($sql);

        if ($result->num_rows > 0) {

            // output data of each row
            while($row = $result->fetch_assoc()) {

                echo '
                    <div class="LoadItem">

                        <img src="../../imgs/loader.gif">

                    </div>

                    <div class="StoneIMGcontainer">

                        <main class="ItemTab">

                            <!-- image tab -->
                            <input id="tab1" type="radio" name="tabs" class="ItemTab" checked>
                            <label for="tab1" class="ItemTab">Image</label>


                ';
                            if ($row['image2'] > 0) {
                                echo '
                                <!-- certificate #1 tab -->
                                <input id="tab2" type="radio" name="tabs" class="ItemTab">
                                <label for="tab2" class="ItemTab">'. $row['stonelab']. ' Certificate</label>
                                ';
                            }
                            else {
                                echo '';
                            }

                            // image
                            echo '
                            <section id="content1" class="ItemTab">
                                <img src="../' . $row['image1']. '">
                                <div class="StoneIMGdisclaimer">Image may be slightly skewed</div>
                            </section>
                            ';

                            // certificate #1
                            echo'
                            <section id="content2" class="ItemTab">
                            ';

                                if ($row['image2'] > 0) {
                                    echo '
                                        <iframe src="../' . $row['image2']. '#view=FitH&toolbar=0&scrollbar=1"></iframe>
                                        <br />
                                        <a class="Download" href="../' . $row['image2']. '" target="_blank">
                                        <span class="mdi mdi-arrow-down-bold mdi-18px"></span>Download PDF</a>
                                        <br /><br />
                                    ';
                                }
                                else {
                                    echo '<div class="NoMedia">stone not certified</div>';
                                }

                            echo '
                            </section>

                        </main>

                </div>

                <div class="StoneDatacontainer">

                    <!-- item number -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">item number(#):</div>
                            <div class="StoneDataInfoContent">
                                <span class="number">' . $row['number']. '</span>
                            </div>
                    </div>

                    <!-- weight -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">weight(ct): </div>
                            <div class="StoneDataInfoContent">
                                <span class="wt">' . $row['wt']. '</span>
                            </div>
                    </div>

                    <!-- dimensions -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">dimension(MM): </div>
                            <div class="StoneDataInfoContent">
                                <span class="length">'. $row['length']. '</span>x<span  class="width">'. $row['width']. '</span>
                            </div>
                    </div>

                    <!-- shape -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">shape:</div>
                            <div class="StoneDataInfoContent">
                                <span class="stoneshape">'. $row['stoneshape']. '</span>
                            </div>
                    </div>

                    <!-- type -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">type:</div>
                            <div class="StoneDataInfoContent">
                                <span class="stonetype">'. $row['stonetype']. '</span>
                            </div>
                    </div>

                    <!-- color -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">color:</div>
                            <div class="StoneDataInfoContent">
                                <span class="stonecolor">'. $row['stonecolor']. '</span>
                            </div>
                    </div>

                    <!-- enhancement -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->
                        <div class="StoneDataInfoHead">enhancement:</div>
                            <div class="StoneDataInfoContent">
                                <span class="enhcode">'. $row['enhcode']. '</span>
                            </div>
                    </div>

                    <!-- lab -->
                    <div class="DataBlock"> <!-- This is a surrounding div for stylizing when need be -->

                        <div class="StoneDataInfoHead">laboratory:</div>

                            <div class="StoneDataInfoContent">

                                <span class="stonelab">
                                    '
                                    //Certificates
                                    if (
                                            $row['stonelab1'] > 0
                                        or
                                            $row['stonelab2'] > 0
                                        or
                                            $row['stonelab3'] > 0
                                        or
                                            $row['stonelab4'] > 0
                                    ) {
                                        echo $row['stonelab1'] or $row['stonelab2'] or $row['stonelab3'] or $row['stonelab4'];
                                    }
                                    else {
                                        echo '';
                                    }
                                    '
                                </span>

                            </div>
                    </div>

                </div>

            ';

            }

        }

        else {

            echo '
                <div  class="errorRefresh">
                    <h1>
                        <span class="mdi mdi-folder-search mdi-48px"></span>
                        NO RESULTS
                        <button class="errorRefresh" onclick="location.reload();" alt="Refresh">
                            <span class="mdi mdi-refresh mdi-18px"></span>
                        </button>
                    </h1>
                </div>
            ';

        }

    }

?>