By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,304 Members | 3,201 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,304 IT Pros & Developers. It's quick & easy.

Convert html page or database shopping basket to an email

P: n/a
OK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:

Product Price Quantity

prod1 6.99 1
prod2 5.99 2
Postage 0.50

Total whatever..I'm
lazy

Formatting would be a little different (just spacing out the prod
table a little more.

Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).

The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.
Many thanks,

Richard Pain
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
My Solution has always been to create a UDF to which i can send parameters,
which in turn generates the HTML email and sends it.

In your case, you can just query the data in your hopping basket, and have
it spit out the rows containing the data you have below.

Mail me if you want an example of what i'm talking about

Laterz
Dominique
"Richard Pain" <rj*****@hotmail.com> wrote in message
news:3b*************************@posting.google.co m...
OK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:

Product Price Quantity

prod1 6.99 1
prod2 5.99 2
Postage 0.50

Total whatever..I'm
lazy

Formatting would be a little different (just spacing out the prod
table a little more.

Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).

The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.
Many thanks,

Richard Pain

Jul 19 '05 #2

P: n/a
Hmmm - unfortunately I'm using mysql (hosting on linux with chilliasp)

Thanks

Richard

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

P: n/a
"Richard Pain" wrote in message
news:3b*************************@posting.google.co m...
: OK - I have a shopping basket with data in a database. Once the person
: has successfully completed their order I want to be able to send them
: an email with the products ordered roughly in the following format:
:
: Product Price Quantity
:
: prod1 6.99 1
: prod2 5.99 2
: Postage 0.50
:
: Total whatever..I'm
: lazy
:
: Formatting would be a little different (just spacing out the prod
: table a little more.
:
: Any ideas or links to scripts that do this?. I've been looking for a
: while now but have had no luck in finding a solution. I just want to
: send a text email (and not html).
:
: The other thing is that on the last page but one, this shopping basket
: is displayed. Is there anyway I could capture the html data from that
: page, store it in a session variable and then generate the email after
: the order has been completed (so sort of like sending a mirror of that
: page)? In that case having a HTML formatted email would be ok.

Richard...

How are you sending the email, Sendmail?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 19 '05 #4

P: n/a
I think it's just 'mail' - the syntax is:

mail($to, $subject, $body);
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.