<%@ page language="java" import="java.sql.*" %> <%@ include file="../../Connections/db.jsp" %> <% String inputUrl=request.getRequestURI(); String url=inputUrl.substring(inputUrl.lastIndexOf("/")+1,inputUrl.length()); if (url.length()==0) { url="index.jsp"; } int vProductID=funcCallStoredFunction("select ProductID from tblProduct where visible=1 and url='"+ url +"'",MM_db_USERNAME, MM_db_PASSWORD, MM_db_STRING); int vCategorieID=funcCallStoredFunction("select CategoryID from tblCategoryProduct where visible=1 and ProductID=" + vProductID ,MM_db_USERNAME, MM_db_PASSWORD, MM_db_STRING); %> <% Driver DriverrsCatProd = (Driver)Class.forName(MM_db_DRIVER).newInstance(); Connection ConnrsCatProd = DriverManager.getConnection(MM_db_STRING,MM_db_USERNAME,MM_db_PASSWORD); PreparedStatement StatementrsCatProd = ConnrsCatProd.prepareStatement("SELECT * FROM qryProductList_new where Visible=1 and ProductID=" + vProductID + ""); ResultSet rsCatProd = StatementrsCatProd.executeQuery(); boolean rsCatProd_isEmpty = !rsCatProd.next(); boolean rsCatProd_hasData = !rsCatProd_isEmpty; Object rsCatProd_data; int rsCatProd_numRows = 0; %> <% Driver DriverrsProduseCategorie = (Driver)Class.forName(MM_db_DRIVER).newInstance(); Connection ConnrsProduseCategorie = DriverManager.getConnection(MM_db_STRING,MM_db_USERNAME,MM_db_PASSWORD); PreparedStatement StatementrsProduseCategorie = ConnrsProduseCategorie.prepareStatement("SELECT * FROM tblCategoryProduct join tblProduct on tblCategoryProduct.ProductID=tblProduct.ProductID where tblProduct.Visible=1 and tblCategoryProduct.visible=1 and tblCategoryProduct.ProductID<>" + vProductID + " and tblCategoryProduct.CategoryID=" + vCategorieID ); ResultSet rsProduseCategorie = StatementrsProduseCategorie.executeQuery(); boolean rsProduseCategorie_isEmpty = !rsProduseCategorie.next(); boolean rsProduseCategorie_hasData = !rsProduseCategorie_isEmpty; Object rsProduseCategorie_data; int rsProduseCategorie_numRows = 0; %> <% int Repeat3__numRows = -1; int Repeat3__index = 0; rsProduseCategorie_numRows += Repeat3__numRows; %> <%= rsCatProd.getString("ProductName") %> | Isotek Engineering SRL <%@ include file="../_functions.jsp" %> <%= getMetaTags( request.getRequestURI() ,"ro", "Pagina") %>

<%= rsCatProd.getString("ProductName") %>

Isotek <%= funcLocatieCategorii(rsCatProd.getInt("CategoryID")) %> > <%= rsCatProd.getString("ProductName")%>

<% if(rsCatProd.getString("ProductImgBig1") == null || rsCatProd.getString("ProductImgBig1").equals("")){ %>

<% } else { %> " rel="prod-group" class="img-gallery" title="Poza 1 - <%= rsCatProd.getString("ProductName") %>">

" height="260"/> <% } %>

<% if(rsCatProd.getString("ProductImgBig2") == null){ %> <% } else { %> " rel="prod-group" class="img-gallery" title="Poza 2 - <%= rsCatProd.getString("ProductName") %>">

"/> <% } %> <% if(rsCatProd.getString("ProductImgBig3") == null){ %> <% } else { %> " rel="prod-group" class="img-gallery" title="Poza 3 - <%= rsCatProd.getString("ProductName") %>">

"/> <% } %> <% if(rsCatProd.getString("ProductImgBig4") == null){ %> <% } else { %> " rel="prod-group" class="img-gallery" title="Poza 4 - <%= rsCatProd.getString("ProductName") %>">

"/> <% } %>

Mod de realizare
La comanda

Doriti detalii?

Sunati acum la:

Consultantii nostri sunt pregatiti
sa va raspunda la orice intrebare!

Detalii

<%=(((rsCatProd_data = rsCatProd.getObject("ProductDesc"))==null || rsCatProd.wasNull())?"":rsCatProd_data)%>

<% if(rsProduseCategorie_hasData){ %>

Produse din aceeasi categorie

" title="<%= rsProduseCategorie.getString("ProductName") %>"> <% if(rsProduseCategorie.getString("ProductImgSmall1") == null || rsProduseCategorie.getString("ProductImgSmall1").equals("")){ %> <% } else { %> " alt="<%= rsProduseCategorie.getString("ProductName") %>" /> <% } %>

<%= rsProduseCategorie.getString("ProductName") %>

" title="<%= rsProduseCategorie.getString("ProductName") %>">

<% rsCatProd.close(); StatementrsCatProd.close(); ConnrsCatProd.close(); %> <% rsProduseCategorie.close(); StatementrsProduseCategorie.close(); ConnrsProduseCategorie.close(); %>