<%
    Connection conn;
    try {
            Class.forName("com.mysql.jdbc.Driver");
        }
    catch (ClassNotFoundException e1)
        {
                // TODO Auto-generated catch block
                e1.printStackTrace();
        }
    try {
                String email = login.getEmail();
                System.out.println(email);
                Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/project", "root", "");
                Statement statement = connection.createStatement();
                ResultSet resultset = statement
                                        .executeQuery("SELECT * FROM test.work where EnjoyerID LIKE '%" + email + "%' ");
%>

<%
    while (resultset.next()) {
%>
<%System.out.println(resultset.getString(1)); %>
<div class="pin" id="<%=resultset.getString(1)%>">
        <p id="user"><a href="#">
            <span style="font-size:20px; text-decoration:none;">
                <!-- <i class="fa fa-user fa-lg"></i> -->
            <i class="fa fa-user fa-lg"></i>&nbsp &nbsp<%=resultset.getString(2) %>
            </span>
        </a></p>





     <span class="containerslide">
                <div id="slides">
                    <img src="workuploadpic/pic1/<%=resultset.getString(9) %>"/>
                    <img src="workuploadpic/pic2/<%=resultset.getString(11)%>"/>
                    <img src="workuploadpic/pic3/<%=resultset.getString(13)%>"/>
                    <!-- <a href="#" class="slidesjs-previous slidesjs-navigation"><i class="icon-chevron-left"></i></a>
                    <a href="#" class="slidesjs-next slidesjs-navigation"><i class="icon-chevron-right"></i></a> -->
                </div>
        </span>






        <div id="word">
        <p>
            <%=resultset.getString(5) %> - $<%=resultset.getString(7) %>
            <br>
            <%=resultset.getString(6) %>
            <br><br>
            <i class="fa fa-street-view fa-lg"></i> At:  <%=resultset.getString(3) %>
            <br>
            <i class="fa fa-scissors fa-lg"></i> By:  <%=resultset.getString(2) %>
        </p>
        </div>
        <br>
        <!----------------------------------------------------------------------
        ***********************************************************************
        Comment still now working
        ***********************************************************************
        ----------------------------------------------------------------------->
        <form class="comment" method="post" action="">
                <input type="hidden" name="id" value="1" />
                <textarea placeholder="Add a comment..." maxlength="1000"></textarea>
                <button type="button" class="button1" id="but">Comment</button>
        </form>

    </div>

     <%
            }
                } catch (Exception e) {
                    e.printStackTrace();
            }
    %>