Hi,
I am currently developing a ecommerce site that sell trovel packages for my final year project. i want the system to automatically sent email alert to customer to make payment before the deadline. How can i do this in php.
another problem is how to send password in plain text to user that forgot their password. I encrupt password in mysql with password() function.
Thanks & Regards
Robert
Automatic email notification
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Re: Automatic email notification
You need to use automation on the server, if you are using a *nix system you would probably use a cronjob and on a Windows server set the task in the task scheduler.robertngo wrote:I am currently developing a ecommerce site that sell trovel packages for my final year project. i want the system to automatically sent email alert to customer to make payment before the deadline. How can i do this in php.
You can't. The password is being stored as a one-way hash, it is not encrypted and cannot therefore be decrypted. You also shouldn't be using the PASSWORD() function as this is intended for MySQL's user tables only, MD5() would be a better choice.robertngo wrote:another problem is how to send password in plain text to user that forgot their password. I encrupt password in mysql with password() function.
Mac
Re: Automatic email notification
how do automate a php script in xppro with apache?twigletmac wrote:You need to use automation on the server, if you are using a *nix system you would probably use a cronjob and on a Windows server set the task in the task scheduler.
Thanks & Regards
Robert