• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Week: 3 At a Glance > Day 20—Add To Cart (details.asp)

Day 20—Add To Cart (details.asp)

Adding items to the shopping cart in Day 20 posed a bit of a problem. Because the user's ID was stored in a session variable, it could not be added using the standard insert behavior. A quick and dirty way around this is by inserting the code to access the session variable directly in to the HTML. The user browsing the item must also be logged in to add an item. This means more Hide Region behavior modification. The source code of the details.asp page of the e-commerce catalog system:

<%@LANGUAGE="VBSCRIPT"%> <!--#include file="../Connections/connCatalog.asp" -->
<%
' *** Edit Operations: declare variables

MM_editAction = CStr(Request("URL"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Request.QueryString
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%> <%
' *** Insert Record: set variables

If (CStr(Request("MM_insert")) <> "") Then

  MM_editConnection = MM_connCatalog_STRING
  MM_editTable = "tblCart"
  MM_editRedirectUrl = "checkout.asp"
  MM_fieldsStr  = "prodID|value"
  MM_columnsStr = "prodID|',none,''"

  ' create the MM_fields and MM_columns arrays
  MM_fields = Split(MM_fieldsStr, "|")
  MM_columns = Split(MM_columnsStr, "|")

  ' set the form values
  For i = LBound(MM_fields) To UBound(MM_fields) Step 2
    MM_fields(i+1) = CStr(Request.Form(MM_fields(i)))
  Next

  ' set the redirect URL
  If (MM_editRedirectUrl = "") Then
    MM_editRedirectUrl = CStr(Request("URL"))
  End If
  If (Request.QueryString <> "") Then
    If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And
Request.QueryString <> "") Then
      MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
    Else
      MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
    End If
  End If

End If
%> <%
' *** Insert Record: construct a sql insert statement and execute it

If (CStr(Request("MM_insert")) <> "") Then

  ' create the sql insert statement
  MM_tableValues = ""
  MM_dbValues = ""
  For i = LBound(MM_fields) To UBound(MM_fields) Step 2
    FormVal = MM_fields(i+1)
    MM_typeArray = Split(MM_columns(i+1),",")
    Delim = MM_typeArray(0)
    If (Delim = "none") Then Delim = ""
    AltVal = MM_typeArray(1)
    If (AltVal = "none") Then AltVal = ""
    EmptyVal = MM_typeArray(2)
    If (EmptyVal = "none") Then EmptyVal = ""
    If (FormVal = "") Then
      FormVal = EmptyVal
    Else
      If (AltVal <> "") Then
        FormVal = AltVal
      ElseIf (Delim = "'") Then  ' escape quotes
        FormVal = "'" & Replace(FormVal,"'","''") & "'"
      Else
        FormVal = Delim + FormVal + Delim
      End If
    End If
    If (i <> LBound(MM_fields)) Then
      MM_tableValues = MM_tableValues & ","
      MM_dbValues = MM_dbValues & ","
    End if
    MM_tableValues = MM_tableValues & MM_columns(i)
    MM_dbValues = MM_dbValues & FormVal
  Next
  strUsername = Session("MM_Username")
  MM_editQuery = "insert into " & MM_editTable & " values (''," & MM_dbValues &
",'" & strUsername & "','')"

  If (Not MM_abortEdit) Then
    ' execute the insert
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute

    If (MM_editRedirectUrl <> "") Then
      Call Response.Redirect(MM_editRedirectUrl)
    End If
  End If

End If
%>
<%
Dim searchresults__formCat
searchresults__formCat = "%"
if (Request("category")  <> "") then searchresults__formCat = Request("category")

%> <%
Dim searchresults__formPrice
searchresults__formPrice = "9999"
if (Request("pricelimit")  <> "") then searchresults__formPrice =
Request("pricelimit")
%> <%
Dim searchresults__formKey
searchresults__formKey = "%"
if (Request("keyword")  <> "") then searchresults__formKey = Request("keyword")
%> <%
Dim RelatedItems__relatedID
RelatedItems__relatedID = "M004"
if (Request("id")  <> "") then RelatedItems__relatedID = Request("id")
%> <%
set searchresults = Server.CreateObject("ADODB.Recordset")
searchresults.ActiveConnection = MM_connCatalog_STRING
searchresults.Source = "SELECT *  FROM tblProduct  WHERE catID LIKE '" +
Replace(searchresults__formCat, "'", "''") + "' AND prodPrice<'" +
Replace(searchresults__formPrice, "'", "''") + "' AND prodDesc LIKE '%" +
Replace(searchresults__formKey, "'", "''") + "%'  ORDER BY catID"
searchresults.CursorType = 0
searchresults.CursorLocation = 2
searchresults.LockType = 3
searchresults.Open()
searchresults_numRows = 0
%>
<%
set RelatedItems = Server.CreateObject("ADODB.Recordset")
RelatedItems.ActiveConnection = MM_connCatalog_STRING
RelatedItems.Source = "SELECT tblProduct.*  FROM tblProduct,tblRelated  WHERE
tblProduct.prodID=tblRelated.prodID2 and tblRelated.prodID1='" +
Replace(RelatedItems__relatedID, "'", "''") + "';"
RelatedItems.CursorType = 0
RelatedItems.CursorLocation = 2
RelatedItems.LockType = 3
RelatedItems.Open()
RelatedItems_numRows = 0
%>
<%
set rsCart = Server.CreateObject("ADODB.Recordset")
rsCart.ActiveConnection = MM_connCatalog_STRING
rsCart.Source = "SELECT *  FROM tblCart"
rsCart.CursorType = 0
rsCart.CursorLocation = 2
rsCart.LockType = 3
rsCart.Open()
rsCart_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
RelatedItems_numRows = RelatedItems_numRows + Repeat1__numRows
%> <%
'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

' set the record count
searchresults_total = searchresults.RecordCount

' set the number of rows displayed on this page
If (searchresults_numRows < 0) Then
  searchresults_numRows = searchresults_total
Elseif (searchresults_numRows = 0) Then
  searchresults_numRows = 1
End If

' set the first and last displayed record
searchresults_first = 1
searchresults_last  = searchresults_first + searchresults_numRows - 1

' if we have the correct record count, check the other stats
If (searchresults_total <> -1) Then
  If (searchresults_first > searchresults_total) Then searchresults_first =
searchresults_total
  If (searchresults_last > searchresults_total) Then searchresults_last =
searchresults_total
  If (searchresults_numRows > searchresults_total) Then searchresults_numRows =
searchresults_total
End If
%> <%
' *** Move To Record and Go To Record: declare variables

Set MM_rs    = searchresults
MM_rsCount   = searchresults_total
MM_size      = searchresults_numRows
MM_uniqueCol = "prodID"
MM_paramName = "id"
MM_offset = 0
MM_atTotal = false
MM_paramIsDefined = false
If (MM_paramName <> "") Then
  MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "")
End If
%> <%
' *** Move To Record: handle 'index' or 'offset' parameter

if (Not MM_paramIsDefined And MM_rsCount <> 0) then

  ' use index parameter if defined, otherwise use offset parameter
  r = Request.QueryString("index")
  If r = "" Then r = Request.QueryString("offset")
  If r <> "" Then MM_offset = Int(r)
  ' if we have a record count, check if we are past the end of the recordset
  If (MM_rsCount <> -1) Then
    If (MM_offset >= MM_rsCount Or MM_offset = -1) Then  ' past end or move last
      If ((MM_rsCount Mod MM_size) > 0) Then         ' last page not a full
repeat region
        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
      Else
        MM_offset = MM_rsCount - MM_size
      End If
    End If
  End If

  ' move the cursor to the selected record
  i = 0
  While ((Not MM_rs.EOF) And (i < MM_offset Or MM_offset = -1))
    MM_rs.MoveNext
    i = i + 1
  Wend
  If (MM_rs.EOF) Then MM_offset = i  ' set MM_offset to the last possible record

End If
%> <%
' *** Move To Specific Record: handle detail parameter

If (MM_paramIsDefined And MM_rsCount <> 0) Then

  ' get the value of the parameter
  param = Request.QueryString(MM_paramName)

  ' find the record with the unique column value equal to the parameter value
  MM_offset = 0
  Do While (Not MM_rs.EOF)
    If (Cstr(MM_rs.Fields.Item(MM_uniqueCol).Value) = param) Then
      Exit Do
    End If
    MM_offset = MM_offset + 1
    MM_rs.MoveNext
  Loop

  ' if not found, set the number of records and reset the cursor
  If (MM_rs.EOF) Then
    If (MM_rsCount < 0) Then MM_rsCount = MM_offset
    If (MM_size < 0 Or MM_size > MM_offset) Then MM_size = MM_offset
    MM_offset = 0

    ' reset the cursor to the beginning
    If (MM_rs.CursorType > 0) Then
      MM_rs.MoveFirst
    Else
      MM_rs.Close
      MM_rs.Open
    End If
  End If

End If
%> <%
' *** Move To Record: if we dont know the record count, check the display range

If (MM_rsCount = -1) Then

  ' walk to the end of the display range for this page
  i = MM_offset
  While (Not MM_rs.EOF And (MM_size < 0 Or i < MM_offset + MM_size))
    MM_rs.MoveNext
    i = i + 1
  Wend

  ' if we walked off the end of the recordset, set MM_rsCount and MM_size
  If (MM_rs.EOF) Then
    MM_rsCount = i
    If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount
  End If

  ' if we walked off the end, set the offset based on page size
  If (MM_rs.EOF And Not MM_paramIsDefined) Then
    If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then
      If ((MM_rsCount Mod MM_size) > 0) Then
        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
      Else
        MM_offset = MM_rsCount - MM_size
      End If
    End If
  End If

  ' reset the cursor to the beginning
  If (MM_rs.CursorType > 0) Then
    MM_rs.MoveFirst
  Else
    MM_rs.Requery
  End If

  ' move the cursor to the selected record
  i = 0
  While (Not MM_rs.EOF And i < MM_offset)
    MM_rs.MoveNext
    i = i + 1
  Wend
End If
%> <%
' *** Move To Record: update recordset stats
' set the first and last displayed record
searchresults_first = MM_offset + 1
searchresults_last  = MM_offset + MM_size
If (MM_rsCount <> -1) Then
  If (searchresults_first > MM_rsCount) Then searchresults_first = MM_rsCount
  If (searchresults_last > MM_rsCount) Then searchresults_last = MM_rsCount
End If

' set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)
%> <%
' *** Go To Record and Move To Record: create strings for maintaining URL and
Form parameters

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName &
"="
MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone=""

' add the URL parameters to the MM_keepURL string
For Each Item In Request.QueryString
  NextItem = "&" & Item & "="
  If (InStr(1,MM_removeList,NextItem,1) = 0) Then
    MM_keepURL = MM_keepURL & NextItem &
Server.URLencode(Request.QueryString(Item))
  End If
Next

' add the Form variables to the MM_keepForm string
For Each Item In Request.Form
  NextItem = "&" & Item & "="
  If (InStr(1,MM_removeList,NextItem,1) = 0) Then
    MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item))
  End If
Next

' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) -
1)
if (MM_keepURL <> "")  Then MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)
if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) -
1)

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
  If (firstItem <> "") Then
    MM_joinChar = "&"
  Else
    MM_joinChar = ""
  End If
End Function
%> <%
' *** Move To Record: set the strings for the first, last, next, and previous links

MM_keepMove = MM_keepBoth
MM_moveParam = "index"

' if the page has a repeated region, remove 'offset' from the maintained
parameters
If (MM_size > 0) Then
  MM_moveParam = "offset"
  If (MM_keepMove <> "") Then
    params = Split(MM_keepMove, "&")
    MM_keepMove = ""
    For i = 0 To UBound(params)
      nextItem = Left(params(i), InStr(params(i),"=") - 1)
      If (StrComp(nextItem,MM_moveParam,1) <> 0) Then
        MM_keepMove = MM_keepMove & "&" & params(i)
      End If
    Next
    If (MM_keepMove <> "") Then
      MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)
    End If
  End If
End If

' set the strings for the move to links
If (MM_keepMove <> "") Then MM_keepMove = MM_keepMove & "&"
urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="
MM_moveFirst = urlStr & "0"
MM_moveLast  = urlStr & "-1"
MM_moveNext  = urlStr & Cstr(MM_offset + MM_size)
prev = MM_offset - MM_size
If (prev < 0) Then prev = 0
MM_movePrev  = urlStr & Cstr(prev)
%>
<html>
<head>
<title>Catalog</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFCC" leftmargin="0" topmargin="0" marginwidth="0"
marginheight="0">
<table width="650" border="0" cellpadding="5" cellspacing="0">
  <tr bgcolor="#000066">
    <td width="15%" bgcolor="#CCCCFF">&nbsp;</td>
    <td width="85%" align="center"><font face="Arial, Helvetica, sans-serif"
size="6" color="#FFFFFF">Product
      Catalog</font></td>
  </tr>
  <tr>
    <td width="15%" bgcolor="#CCCCFF" valign="top">
      <p><b><font face="Arial, Helvetica, sans-serif"><a
href="javascript:history.back()">Go
        Back</a></font></b></p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
    </td>
    <td width="85%" valign="top" bgcolor="#FFCC99">
      <table width="100%" border="0" cellspacing="0" cellpadding="10">
        <tr valign="top" align="center">
          <td height="304">
            <table border="0" cellspacing="0" cellpadding="5">
              <tr>
                <td width="46%" valign="middle" bgcolor="#FFFFFF"
align="center"><font face="Arial, Helvetica, sans-serif"><img
src="<%=(searchresults.Fields.Item("prodLgPic").Value)%>" width="250"
height="250"></font></td>
                <td width="54%" bgcolor="#FFFF66"><font face="Arial, Helvetica,
sans-serif"><b><%=(searchresults.Fields.Item("prodName").Value)%></b><br>
                  <font size="-1">Item
#:<%=(searchresults.Fields.Item("prodID").Value)%></font><br>
                  Price :<%=
FormatCurrency((searchresults.Fields.Item("prodPrice").Value), 2, -2, -2, -2)
%><br>
                  <br>
                  <br>
                  <br>
                  <% If Session("MM_Username")<>"" Then %>
                  <form name="frmAddtoCart" method="post"
action="<%=MM_editAction%>">
                    <input type="hidden" name="prodID"
value="<%=(searchresults.Fields.Item("prodID").Value)%>">
                    <input type="submit" name="Purchase" value="Add to Cart">
                    <input type="hidden" name="MM_insert" value="true">
                  </form>
                  <% End If %>
                  <% If Session("MM_Username")="" Then %>
                  <A HREF="login.asp">Log into the system</A> <% End If %>
                  </font></td>
              </tr>
              <tr>
                <td colspan="2" valign="middle"
bgcolor="#FFFFFF"><%=(searchresults.Fields.Item("prodDesc").Value)%></td>
              </tr>
            </table>
            <br>
            <font face="Arial, Helvetica, sans-serif">Related Items:<br>
            <%
While ((Repeat1__numRows <> 0) AND (NOT RelatedItems.EOF))
%><%=(RelatedItems.Fields.Item("prodName").Value)%><br>
            <%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
RelatedItems.MoveNext()
Wend
%> </font></td>
        </tr>
      </table>
      <br>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><font face="Arial, Helvetica, sans-serif"><A
HREF="<%=MM_movePrev%>">Previous</A>
            </font></td>
          <td>
            <div align="right"><font face="Arial, Helvetica, sans-serif"><A
HREF="<%=MM_moveNext%>">Next</A></font></div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>

<%
RelatedItems.Close()
%> <%
rsCart.Close()
%> <%
searchresults.Close()
%>


					  


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint