Confirmation Email with Items

Dev Articles Community Forums Sponsor:

Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!

April 25th, 2003, 11:56 AM

charlielha

Junior Member

Join Date: Apr 2003

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

Confirmation Email with Items

Hi, I am working on a shopping cart with no checkout. Everything is working fine, the user has the ability to add products, update quantities and remove products. When he/she is done, he./she fill out a form and as soon as submit is pressed an email is generated. One goes to the order department and the other goes to the user. Now, what I need is to have the items the user picked in this emails.

Is there a way to store this using session variables? Or is there another way to do this?

Thanks

April 25th, 2003, 12:16 PM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

Ok - how are you storing the items now? If it is in session var's, show us the array structure...

__________________
~ Joe Penn

We work for free to help make this a valuable resource on the internet. Do you appreciate the help - did we provide help that will help you prosper and help that has contributed to sharpening your current skill set?

Show your appreciation and purchase something from our Amazon Wishlist's - it's simple and a great way to say thank you.

April 25th, 2003, 12:55 PM

charlielha

Junior Member

Join Date: Apr 2003

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

Building A Persistent Shopping Cart With PHP and MySQL

I am using the Building A Persistent Shopping Cart With PHP and MySQL tutorial and modify it to fit my needs. The items are store in a table and identified by itemId and cookieId.

April 25th, 2003, 01:32 PM

jpenn

Contributing User

Join Date: Oct 2002

Location: Washington, DC

Posts: 317

Time spent in forums: 2 m 3 sec
Reputation Power: 6

PHP Code:


		
			
/************************

Get User Data

************************/

$query = "SELECT * FROM the_table WHERE user_id_field = the_user_id";

$result = mysql_query( $query );

$i = ( int )0;

while( $res = mysql_fetch_object( $result ) )

{

        $data[$i]['product'] = $res->prod_desc;

        $data[$i]['quantity'] = $res->quantity;

        $i++;

}

The above will get your data into a structured array. Then, you can iterate the array and build your email ->

PHP Code:


		
			
 $body = 'Begin Order --------------------------';

foreach( $data as $prod )

{

        $body .= 'Product: ' . $prod['product'] . "\n\r";

        $body .= 'Product: ' . $prod['quantity'] . "\n\r\n\r\n\r";

}

$body .= 'End Of Order --------------------------';

Now, mail it ->

PHP Code:


		
			
function mail_it( $to )

{

        foreach( $to as $address )

        {

                /***************************

                Do your mail stuff here

                ***************************/

        }

}

$to[] = /* First Address */

$to[] = /* Second Address */

mail_it( $to );

Now, if you would have posted your code the above could have been taylored to what your needs - with no code, we can not provided you with cut and paste solutions. You are going to have to figure the above out on your own unless you post your code - thats why it is essential that code be posted when you guys ask questions...

April 25th, 2003, 01:40 PM

charlielha

Junior Member

Join Date: Apr 2003

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

Thanks

Thanks, I don't have my files here but when I ged to work, I'll try out that code and in case I can't figure it out, I'll post my code.

Thanks for your help

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: