Alexandria

Show Code: piece-detail.php


<?php include 'session.php'; ?>

<?php include 'db-connect.php'; ?>

<!DOCTYPE html>

<html>



<head>

    <title>Alexandria</title>

    <link href="style1.css" rel="stylesheet" type="text/css">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

</head>



<?php

    

    $piece_id=$_GET['piece_id'];



    $sql='SELECT * FROM t_pieces JOIN t_artists ON artist_id=artist_fk LEFT JOIN t_location ON location_id=location_fk JOIN t_mediums ON medium_id=medium_fk WHERE piece_id='.$piece_id;





    $result=mysqli_query($con,$sql);     

    $row=mysqli_fetch_array($result);

    

    $piece_name=$row['piece_name'];

    $piece_image=$row['piece_image'];

    $piece_longitude=$row['piece_longitude'];

    $piece_latitude=$row['piece_latitude'];

    

    ?>





<body onload="initMap(<?php 

        if($piece_longitude!='' && $piece_latitude!=''){

            echo $piece_longitude.','.$piece_latitude; 

        }

        ?>)">

    <?php include 'nav.php'; ?>











    <main id="piece-detail">







        <?php

        echo '<figure>'; 

        echo '<img src="'.$row['piece_image'].'">';

        echo '</figure>';

        ?>





        <article>

            <?php 

            

                echo '<h2>'.htmlentities($row['piece_name']).'</h2>';



            

        echo '<h3>' ;   

          



           echo $row['medium_name'].' ';

           

           

            

            echo '<h3>' ;  

            echo 'year: ';

             //handle BC for piece dates before year 0

            if($row['piece_year']>=0){

            echo $row['piece_year'];

            }

            else{

            echo $row['piece_year']*(-1).'BC - '.$row['piece_year']*(-1).'BC';

            }

              echo '</h3>' ;        

            

            



            ?>



            <h3>location: <?php echo $row['city'];?></h3>

        </article>



        <div id="map"></div>









        <?php mysqli_close($con);  //Close Connection?>

    </main>

    <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyANqabCeXfuvJLMFOmswsDin9bAJzOSGF8"></script>

    <script src="alexandria-maps.js"></script>

</body>



</html>