<%@include file="include/dbconnection.jsp"%> <%@include file="include/utilities.jsp"%> <%@include file="include/search-engine.jsp"%> <%@include file="include/header.jsp"%> <% String id=""; if(request.getParameter("id")!=null) { id=request.getParameter("id"); } int count_i=0; String query_product="SELECT page_name,id,page_rate,page_sp_rate,page_title,page_short,other_info,size_1,my_value,size_2,size_3,page_category FROM product_tab where status='YES' and id='"+id+"'"; Statement st_product=con.createStatement(); ResultSet rs_product=st_product.executeQuery(query_product); while(rs_product.next()) { String image_name="",image_name_status=""; String query_product_image="SELECT image_1,image_1_status FROM upload_tab where image_id='"+rs_product.getString("id")+"' order by modified_date asc"; Statement st_product_image=con.createStatement(); ResultSet rs_product_image=st_product_image.executeQuery(query_product_image); if(rs_product_image.next()) { image_name=rs_product_image.getString("image_1"); image_name_status=rs_product_image.getString("image_1_status"); } rs_product_image.close(); st_product_image.close(); String category_name="",category_id=""; String query_product_category="SELECT category_name,id FROM category_tab where id='"+rs_product.getString("page_title")+"' order by modified_date asc"; Statement st_product_category=con.createStatement(); ResultSet rs_product_category=st_product_category.executeQuery(query_product_category); if(rs_product_category.next()) { category_name=rs_product_category.getString("category_name"); category_id=rs_product_category.getString("id"); } rs_product_category.close(); st_product_category.close(); String brand_name="",brand_id=""; String query_product_brand="SELECT category_name,id FROM category_tab where id='"+rs_product.getString("page_category")+"' order by modified_date asc"; Statement st_product_brand=con.createStatement(); ResultSet rs_product_brand=st_product_brand.executeQuery(query_product_brand); if(rs_product_brand.next()) { brand_name=rs_product_brand.getString("category_name"); brand_id=rs_product_brand.getString("id"); } rs_product_brand.close(); st_product_brand.close(); %>

<%=rs_product.getString("page_name")%>

Brand : <%=brand_name%>

Description

<%=rs_product.getString("page_short")%>

<%=rs_product.getString("other_info")%>

<% if((rs_product.getString("my_value").length()>0)&&(!rs_product.getString("my_value").equals("0"))) { %>
Size
<% String[] words=rs_product.getString("my_value").split(","); for(String w:words){ //out.println("
"+w+" "); %>
<% } } %>
<% if(rs_product.getString("page_sp_rate").equals("0")) { %> AED <%=rs_product.getString("page_rate")%> <%}else{%> AED <%=rs_product.getString("page_sp_rate")%> AED <%=rs_product.getString("page_rate")%> <% } %>
<%@include file="include/related.jsp"%>
<% count_i=count_i+1; } rs_product.close(); st_product.close(); %> <%@include file="include/footer.jsp"%>