Website coding help. (intermediate/advanced)?

Question

I have a site under construction, it will have a mysql database containing stock quantities of a product for sale... how would I include the feature that when an item is bought and stock levels drop that a notification email is sent to the site owner informing of either no stock remaining or low stock levels or simply that an irem has sold?

Would this require php and if so what code should be used?

Answer 1

What you need is to look into a thing called PEAR. http://pear.php.net/

You can install a pear module called "Mail" and using that module you can send emails out properly using the correct email header types.

Somewhere in your php code, all you have to do is have something like:

if($stock->level <= $minimum_items)
{
/* Mail an email out */
}

The standard php mail function doesn't allow you to do file attachments or what not. The PEAR one does. :)

Answer 2

I guess you know php, and you will have the mysql server installed on the machine...

the mysql hooks in php are easy to use... it's just a simple query.

Answer 3

The mail function is usually installed by default - at least on the servers I've used

Just go to PHP.net, and read the mail function in the manual, it's simple enough.

Answer 4

couldnt you jsut use a data base and turn it a webpage. that way you could set up a quiry that will alert the user when new stock is needed to be prdered and thats at gcse lever/a level.

Answer 5

i don;t know abt PHP as im a asp & asp.net developer try to send a mail on page postback whenever you try to insert a record in the query...

Answer 6

Get some professional help here-

http://tinyurl.com/o5e26