Hjælp til at opdatere database ved kald fra JavaScript
Hej Eksperter,Jeg har rodet mig ud på dybt vand med noget JavaScript, som bruges til at vælge nogle relaterede varer i en webshop.
Det virker på den måde at man på en siden relaterede produkter klikker på et link som hedder "Tilføj andre relaterede produkter".
Derefter åbner der en Popup, hvor man kan søge efter produkter.
Når man klikker på et produkt i popup-vinduet kommer det automatisk frem i hovedvinduet ved hjælp af noget JS og Inner HTML.
Mit problem er at jeg ikke ved hvordan jeg skal registrere de valgte produkter i databasen.
Håber I kan hjælpe - Min kode er nedenstående...
------------------------------------------------------------------
HOVEDVINDUE
------------------------------------------------------------------
<script type="text/javascript">
function delShopProductRelated(ProductID){
obj = document.getElementById('ShopProductRelated')
tmpString = obj.value.split(", ")
newString = ""
tmpDel = ""
for(var i=0;i < tmpString.length;i++){
if(tmpString[i].toString() != ProductID.toString()){
newString += tmpDel + tmpString[i]
tmpDel = ", "
}
}
obj.value = newString;
document.getElementById("RShopProductRelated" + ProductID).style.display = "none";
ok = document.getElementById("RShopProductRelated" + ProductID).removeAttribute("ID", 0);
}
</script>
<input type=hidden id="ShopProductRelated" name="ShopProductRelated" value="">
<div id=ShopProductRelatedList></div>
<br>
<a href="java script:void(0)" style="text-decoration: none" onclick="win=window.open('related_products.asp?ProductId=<%=Id%>','Zantiago','toolbar=no,height=500,width=600,location=no,directories=no,resizable=no,fullscreen=no,scrollbars=yes,menubar=no')"><strong>Klik her for at tilføje relaterede produkter</strong></a>
------------------------------------------------------------------
------------------------------------------------------------------
POP-UP VINDUE
------------------------------------------------------------------
<script language="JavaScript">
<!--
mac = false;
if(navigator.appVersion.toLowerCase().indexOf("mac") > 0){
mac = true;
}
function FieldSize(){
var height = document.body.clientHeight;
height = height-140
if(height > 425){
height = 425;
}
}
function Choose(ProductID, ProdcutName, ProductNumber, doClose){
var SelectionCount;
var arrProdIDs;
var blnTooMany;
blnTooMany = false;
SelectionCount = 0;
obj = top.opener.document.getElementById('ShopProductRelated');
objList = top.opener.document.getElementById('ShopProductRelatedList');
if(SelectionCount > 0) {
if(obj.value.length > 0) {
arrProdIDs = obj.value.split(",");
if(arrProdIDs.length >= SelectionCount) {
// alert('*Der_må_kun_vælges' + ' ' + SelectionCount + ' ' + '*varer\nSlet_en_vare_før_du_vælger_en_ny.');
alert('Der kan højst vælges %% genstande!'.replace("%%", SelectionCount) + '\nFjern en genstand før du tilføjer nye genstande.');
blnTooMany = true;
}
}
}
if(blnTooMany == false) {
if(!top.opener.document.getElementById("RShopProductRelated" + ProductID)){
if(obj.value.length > 0){
obj.value += ", " + ProductID;
}
else{
obj.value = ProductID;
}
objList.innerHTML += "<table class=style2 border=0 cellpadding=2 cellspacing=2 width=100% ID=RShopProductRelated" + ProductID + "><tr><td width=20%>" + ProductNumber + "</td><td width=30%>" + ProdcutName + "</td><td width=50%><a href='java script:delShopProductRelated(" + ProductID + ");'><img src=img/Delete.gif border=0 /></a></td></tr></table>"
}
else{
alert("Den valgte vare blev tilføjet");
}
}
if(doClose){
self.close();
}
}
-->
</script>
</head>
<!-- #include file=includes.asp -->
<body onload="FieldSize();">
<div class="style2">
<table id="GetHtmlTableTop" border="0" cellpadding="0" width="600" cellspacing="0"><tr><td align="center"><strong> </strong></td></tr><tr height="4"><td height="4"><img src="img/x.gif" height="4" /></td></tr><tr><td align="left"><TABLE id="GetHtmlTableTabs" BORDER="0" CELLPADDING="0" CELLSPACING="0" width="600"><TR><TD ID="Tab1_head" CLASS="seltab" onclick="TabClick(this);" HEIGHT="20" ALIGN="CENTER" VALIGN="middle">Varer</TD><TD CLASS="hiddentab" HEIGHT="20" WIDTH="1"><BR>
</TD><TD CLASS="hiddentab" HEIGHT="20" WIDTH="523"><BR></TD></TR></table></td></tr></table>
<table border="0" cellpadding="0" cellspacing="0" class=tabTable>
<tr><td valign=top>
<div ID="Tab1" STYLE="display:;width:598;">
<table border="0" cellpadding="0" width="598">
<tr>
<td colspan="2">
<br>
<fieldset style='margin:5px;'><legend class='gbTitle'>Søg </legend>
<table cellpadding=2 cellspacing=0>
<form name="Search" action="module_shopv2_related_products.asp" Method=get>
<input type=hidden name="Action" value="Search">
<input type=hidden name="Search" value="True">
<input type=hidden name="Mode" value="Browse">
<input type=hidden name="Caller" value="ShopProductRelated">
<tr>
<td width=170>Varenavn</td>
<td><input type=text name="ProductName" value="<%=request.QueryString("ProductName")%>" class=std style="width:150px;"></td>
</tr>
<tr>
<td>Varenummer</td>
<td><input type=text name="ProductNumber" value="<%=request.QueryString("ProductNumber")%>" class=std style="width:150px;"> </td>
</tr>
<tr>
<td colspan=2 align=right><input type="submit" onClick="document.Search.submit();;return false;" value="Søg" class="buttonSubmit"></td>
</tr>
</form>
</table>
</fieldset>
</td>
</tr>
<tr>
<td width="150"><img src="img/x.gif" width="15" height="1" alt="" border="0"> <strong>Vare</strong></td>
<td width="90"><strong>Varenr.</strong></td>
</tr>
<tr>
<td colspan="2" bgcolor="#C4C4C4"><img src="img/x.gif" width=1 height=1 alt="" border="0"></td>
</tr>
<%
If request.QueryString("Search") = "True" Then
Set rs_find_product = Server.CreateObject("ADODB.RecordSet")
rs_find_product.open "Select * From [Shop_Products] where Site_Id = " & Site_Id & " AND varenummer like '%" & request.QueryString("ProductNumber") &"%'" , Conn
Do while not rs_find_product.EOF
ID = rs_find_product("ID")
Titel = rs_find_product("Titel")
Varenummer = rs_find_product("Varenummer")
%>
<TR>
<td><a href="java script:Choose(<%=ID%>, '<%=Titel%>', '<%=Varenummer%>', false)">
<span><%=Titel%>
</span></a>
</td>
<td>
<span><%=Varenummer%></span>
</td>
</TR>
<tr>
<td colspan="10" bgcolor="#C4C4C4"><img src="img/x.gif" width=1 height=1 alt="" border="0"></td>
</tr>
<%
rs_find_product.MoveNext
Loop
rs_find_product.Close
End If
%>
</TABLE>
</div>
</td></tr>
<tr>
<td align=right valign=bottom id=functionsbutton>
<table>
<tr>
<td>
<button onClick="self.close();;return false;">Luk vindue</button>
</td>
</tr>
</table>
</td>
</tr>
</table>
</span>
</div>
</body>
</html>
