Page 1 of 1
Automatic email notification
Posted: Tue Mar 30, 2004 1:45 am
by robertngo
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
Re: Automatic email notification
Posted: Tue Mar 30, 2004 2:05 am
by twigletmac
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 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:another problem is how to send password in plain text to user that forgot their password. I encrupt password in mysql with password() function.
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.
Mac
Re: Automatic email notification
Posted: Tue Mar 30, 2004 2:27 am
by robertngo
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.
how do automate a php script in xppro with apache?
Thanks & Regards
Robert
Posted: Tue Mar 30, 2004 3:02 am
by Pyrite
You can make a batch file that calls php.exe that calls your php script. Then add the batch file to your Sheduled Tasks. .. just a thought.