Solved

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

Posted on 2003-11-26
3
189 Views
Last Modified: 2013-12-24
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
Comment
Question by:zakirdavis
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
anandkp earned 250 total points
Comment Utility
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
 
LVL 17

Expert Comment

by:anandkp
Comment Utility
HELLO ???
0
 

Author Comment

by:zakirdavis
Comment Utility
should i store things in a structure?
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now