Solved

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

Posted on 2003-11-26
3
208 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
ID: 9831235
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
ID: 9841460
HELLO ???
0
 

Author Comment

by:zakirdavis
ID: 9841754
should i store things in a structure?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Reverse Proxy Server 6 91
how can I backup my incomplete website from hostgator? 3 69
Apache SSL and mod_rewrite not working 8 189
AWS Advice on using WHM/cPanel 1 80
This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

830 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