• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Sorting Columns, Add Items to a Cart, Send HTML Email

I've developed a webpage that displays the contents of my database. The user has 4 different views to look at, (View 1, View 2, View 3 and View All). In each of these views the user can select some rows, add the rows to a cart and continue browsing.

I know how to get what the user selected , but i don't know how to get what they selected, store their selection, allow them to continue surfing, store more rows, and then finally email the administrator their selections.

This is what i don't know how to do:

1. I do not know how to allow users to Sort Columns by clicking a Column Header.

2. I do not know how to allow user to select rows (via checkbox) and send the selections to a cart (structure i am assuming), continue browsing and add more items to cart.

3. I do not know how to have all the pages display how many items they have the the cart.

4. I do not know how to have user view cart and delete selections.

5. I do not know how to have user email their selections over to an email address that is stored in the same database (different table).

6. I do not know how to send html email to administrator.
0
zakirdavis
Asked:
zakirdavis
  • 2
1 Solution
 
anandkpCommented:
I guess - ur trying to have a project done here ...

U shld have ur requirements answered in small small queries ...

Sorting COlumns : have a look at
http://oldlook.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20799971.html

to display teh items & show view cart or delete selections .. u need to well versed with SQL
i hope u have a good knowledge of insert / update & delete queries

email :
<CFMAIL TO="anand@ee.com" FROM="yourname@yourdomain.com" SUBJECT="hi - html mail" TYPE="HTML">
      <!--- I hope u have configured teh IP address for ur mails erver in CFADMIN --->
      <TABLE>
            <TR>
                  <TD>name</TD>
                  <TD>Age</TD>
                  <TD>country</TD>
            </TR>
            <TR>
                  <TD>:</TD>
                  <TD>:</TD>
                  <TD>:</TD>
            </TR>
            <TR>
                  <TD><B>anand</B></TD>
                  <TD><B>19</B></TD>
                  <TD><B>india</B></TD>
            </TR>
      </TABLE>
</CFMAIL>

the same email can be generated for the selections done by the user & have them emailed in their inbox. all u need to do is run a CFQUERY & change ur email tag to

<CFQUERY NAME="Qry_eMailcart" DATASOURCE="Dsn">
    Select * from tbl_shoppingcart where userid = 'anandkp'
</CFQUERY>

<CFMAIL QUERY="Qry_eMailcart" TO="#useremailid#" FROM="yourname@yourdomain.com" SUBJECT="cart-details" TYPE="HTML">
      <!--- I hope u have configured teh IP address for ur mails erver in CFADMIN --->
      <TABLE>
            <TR>
                  <TD>name</TD>
                  <TD>Age</TD>
                  <TD>country</TD>
            </TR>
            <TR>
                  <TD>:</TD>
                  <TD>:</TD>
                  <TD>:</TD>
            </TR>
            <TR>
                  <TD><B>#name#</B></TD>
                  <TD><B>#age#</B></TD>
                  <TD><B>#country#</B></TD>
            </TR>
      </TABLE>
</CFMAIL>
0
 
anandkpCommented:
HELLO ???
0
 
zakirdavisAuthor Commented:
should i store things in a structure?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now