MySql to PHP to Email

[Anon]

Hi, i've created a shopping cart (or at least tried to), where users are able to insert products they'd like to order on a repeat (ie. once a month) basis. After creating a repeat order, the info is saved in the database (MySQl) and can be viewed online by going to the repeat orders page (php). My qst is how can i now get them to click on a "repeat my order" button, select, with a tick box, which orders they want to repeat, and send it to my email address. I quite new at php and mysql and would appreciate some feedback.

Thanx :-)

[Anon]

http://www.php.net/mail

Use the mail() function and mail yourself whatever you want 🙂

[Anon]

Thanx, but how can i send existing data in the database, that is already displayed on the page, to me. I don't know how to get them to use check boxes to only select 1 or all products and then only send those they picked to me? :-*)

[Anon]

You can try a checkbox array. Name them like this:

ch[0]
ch[1]
ch[2]

etc...

then, in the page where you submit the form, create a FOR loop, from 0 to the number of elements.

And use if(isset($ch[$i])){
//Add article...
}

Hope this helps

fLIPIS

[Anon]

Thanx, it sorta make sense, however, im totally new at the programming scene & will appreciate if u could perhaps give me a complete coded sample? Also remember i need to retrieve info from the database, then place a check box next to each and then submit the checked products to my email... pleeeaasseee, pleeeasseee send me a working example or if you know of a free script, can u send me the url address :-*)

[Anon]

Mail me at alejandro_alac.es _ for @ and i'll send you some sample code.

fLIPIS